Re:JavaScript-Based Spreadsheet-Like Formulas in Google Docs
by amelius on Tuesday February 19, 2019 @05:36AM
(#19198005)
So by creating a table inside the text document, you can essentially make a spreadsheet?
[ Parent
| on HN ]
Re:JavaScript-Based Spreadsheet-Like Formulas in Google Docs
by MikaelMayer on Tuesday February 19, 2019 @01:43PM
(#19201558)
Indeed!
However, without range support like A1:A10 or relative references.
Besides, values should be defined in order (top-bottom, left-right)
Try to create a 2x2 table like this:
=(/A1=/”Hello”) =(/B1=/”World”)
=(A1 + “ “ + B1)
Click on Evaluate formula, tadaa. I just fixed a bug to make it work, the publication might take up to 24h.