search

vinci1it2000 / formulas

Excel formulas interpreter in Python.
https://formulas.readthedocs.io/
European Union Public License 1.1
342 stars 75 forks source link

Error found during using formula reference in range #101

Open markm812 opened 2 years ago

markm812 commented 2 years ago

Describe the bug OFFSET(D2,0,3,1,1) will return the reference to cell G2 COUNT(D2:OFFSET(D2,0,3,1,1)) should give the answer of 3 But error was returned.

Error code: FormulaError: Not a valid formula:%s Formulas fails to parse it as a valid function.

=OFFSET(D3,0,3,1,1) works fine =OFFSET(D3,0,3,1,1):D3 works fine too =D3:OFFSET(D3,0,3,1,1) fails

Fail only when used in indicating range.