search

LesterLyu / fast-formula-parser

Parse and evaluate MS Excel formula in javascript.
https://www.npmjs.com/package/fast-formula-parser
MIT License
454 stars 63 forks source link

Structured references #35

Closed rmdort closed 3 years ago

rmdort commented 3 years ago

Implemented some of the feature of structured reference

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

  1. Table, Column detection
  2. This row @ detection

Would be great to get some feedback.

Todo

  1. Detect #Total and #Data, #ThisRow
  2. Range formulas DeptSalesFYSummary[[2014]:[2012]]
LesterLyu commented 3 years ago

Will take a look in this weekend.

rmdort commented 3 years ago

Closing this. Will issue a new PR