onVariable - access to cell position

[rmdort]

https://github.com/LesterLyu/fast-formula-parser/blob/master/grammar/hooks.js#L107

Right now, onVariable callbacks has access to variable name and sheet, but not the cell position.

Can i propose to change

const res = {ref: this.onVariable(name, this.position.sheet)};

to

const res = {ref: this.onVariable(name, this.position)};

The reason is that lets say i have a formula =sales * 10, in a table. For each onVariable call, i want to access the cell position and return the correct position of sales column.

Eg:

Sales	total
11	=sales * 10
12	=sales * 10

[LesterLyu]

Is this achievable in Excel or Google Sheets?

[rmdort]

In Excel tables, it is supported

https://support.microsoft.com/en-us/office/using-structured-references-with-excel-tables-f5ed2452-2337-4f71-bed3-c8ae6d2b276e

[rmdort]

What do you think of this? Is there any otherway u propose I can access a row index of a variable cell?

[LesterLyu]

I'm not familiar with the structured reference, I think I will just make position the third parameter.
In the next v2 update, I will then move it to the second parameter.

[rmdort]

Cool thanks. Will be helpful.

[rmdort]

Any ETA on v2 release?

[LesterLyu]

Not sure yet, could be the beginning of 2021, or the end of 2020.

[rmdort]

Wondering if there is a way to access Table names as well =SUM(DeptSales[Sales Amount])

DeptSales => Table and Sales Amount => column name

More info - https://support.microsoft.com/en-us/office/using-structured-references-with-excel-tables-f5ed2452-2337-4f71-bed3-c8ae6d2b276e

[LesterLyu]

Implemented in the v2 branch, position is now the second parameter.