fast-formula-parser icon indicating copy to clipboard operation
fast-formula-parser copied to clipboard

Dependency parsing of index formulas in incorrect

Open mountEvarus opened this issue 2 years ago • 0 comments

When parsing an index formula like the following:

INDEX('Sheet1'!A1:AV90,'Sheet2'!C28,'Sheet2'!G2)

The result of new FormulaParser.DepParser().parse() is:

[{ from: { row: 1, col: 1 } }, sheet: "Sheet 1", to: { row: 90, col: 48 } ]

This would suggest there are thousands of dependencies, but really is are only 1 when the index is resolved, the row & column values given by arguments 2 & 3 are used to get the cell in question.

Maybe I am thinking about this wrong but this is how I see it, any thoughts are welcome

mountEvarus avatar Jun 09 '23 13:06 mountEvarus