It is not always possible, of course. But it normally is. For the edge cases a helper like this must be nice. Maybe some fields have lots of edge cases, mine has few.
Either make it a video so you can pause it or just have static screenshots without animation.
I noticed there is no license on the Github, do you intend for this to be open source?
Spreadsheet-blocks focuses more on building spreadsheets visually, while Frockly is primarily about inspecting and refactoring existing Excel formulas and making their structure explicit.
I think they’re exploring adjacent but slightly different problems.
– Added the i18n foundation – Introduced an initial French translation – Implemented URL parameter support for loading state and navigation
Thanks again for the feedback — it directly influenced this refactor.
leobg•1mo ago
I often have this problem in Google Sheets. So far, i’ve resorted to copying the formula into Sublime Text and then splitting it into multiple lines. Your editor looks much more intuitive.
As demo, it would be nice if one could press a button to load some real data abd formulas. I’m reading HN on my phone. I guess many people do. Coming up with a formula and example data is an extra hurdle, and doing it using just a thumb and dumb autocorrect doubly so.
I did see the screenshots on GitHub. Thumbs up for those!
bthallplz•1mo ago
tcho•1mo ago
> 1. You can drag down the bottom of the formula bar/field and make it multi-line.
> 2. You can insert arbitrary newlines in an Excel formula.
> For example:
I learned this from this comment from last week: https://news.ycombinator.com/item?id=46341227knollimar•1mo ago
=Let(table,$C$17:$S$24,
rowName,A6,
colName,C6,
headerRow,$C$15:$S$15,
headerCol,$A$17:$A$24,
rowIndex,MATCH(rowName,headerCol,0),
colIndex,MATCH(colName,headerRow,0),
index(table,rowIndex,colIndex)
)
or even
=LAMBDA(table,rowNames,colNames,rowToFind,colToFind,
)($C$17:$S$24,$A$17:$A$24,$C$15:$S$15,A6,C6)(Also alt+enter to input the newlines)
Cordiali•1mo ago
Also, almost everyone should be using tables instead of ranges. The references are missing a few features, but it makes formulas a brazillion times more readable.
croisillon•1mo ago
paulmooreparks•1mo ago