4 ms·
I can't seem to figure out how to reference another cell. I Also can't seem to get it to use the "=SUM(1,2)" example in the documentation page for formula. Am
by kbenson 6y ago
I can't seem to figure out how to reference another cell. I Also can't seem to get it to use the "=SUM(1,2)" example in the documentation page for formula.
Am I doing something wrong?
Edit: Okay, I can use formulas in the demo spreadsheet on the Formula documentation page, but not the demo linked from the main page. I'm not sure how to reference other cells though.
- artminister 6y agoHi, I have not shipped Core support for formula yet. Working on it actively In the demo you see, I am using hot-formula-parser to parse formula during render. This won't scale for large applications, cos any parent render will re-render the grid and trigger a recalc Am working on adding a Directed Acyclic Graph to manage cell dependencies, so that Grid knows which cells needs to be re-rendered.
- artminister 6y agoFor the parser, we will be using https://github.com/LesterLyu/fast-formula-parser https://github.com/LesterLyu/fast-formula-parser