Show HN: React SpreadSheet – Google Sheets-like performance

Re:Show HN: React SpreadSheet – Google Sheets-like performance by kbenson on Thursday July 23, 2020 @06:04PM (#23932951)

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.

[ Parent | on HN ]

Re:Show HN: React SpreadSheet – Google Sheets-like performance by artminister on Thursday July 23, 2020 @06:12PM (#23933084)

Hi, 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.

[ Parent | on HN ]

Re:Show HN: React SpreadSheet – Google Sheets-like performance by artminister on Thursday July 23, 2020 @06:13PM (#23933110)

For the parser, we will be using https://github.com/LesterLyu/fast-formula-parser

[ Parent | on HN ]