search

audreyt / ethercalc

Node.js port of Multi-user SocialCalc
https://ethercalc.net
Other
2.96k stars 540 forks source link

Support for R1C1 reference and formula #474

Open r1c1 opened 7 years ago

r1c1 commented 7 years ago

https://support.office.com/en-US/article/Overview-of-formulas-in-Excel-ecfdc708-9162-49e8-b993-c311f47ca173

You can also use a reference style where both the rows and the columns on the worksheet are numbered. The R1C1 reference style is useful for computing row and column positions in macros. In the R1C1 style, Excel indicates the location of a cell with an "R" followed by a row number and a "C" followed by a column number.

eddyparkinson commented 7 years ago

Thanks for the feature request. Feature requests are always welcome, is good to know what is wanted. If possible, please cross reference this with related feature requests so that someone can add several related features at the same time.

Pull requests are welcome.

The code is here. https://github.com/marcelklehr/socialcalc/blob/master/formula1.js#L152 also parsestate.coord