search

vinci1it2000 / formulas

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

Not a valid formula for decimal numbers missing any digits before the decimal #106

Closed alexespencer closed 8 months ago

alexespencer commented 1 year ago

Describe the bug Cells with formulas like this cannot be parsed: '=C20*.33'

To Reproduce Some excel sheets produced using the open XL format do not change '.33' to '0.33' before saving. Either directly try to parse the equation above or I may be able to provide an XLSX file that has this issue.

Expected behavior .33 is treated as 0.33

Desktop (please complete the following information):

vinci1it2000 commented 8 months ago

This is not the excel behaviour but it is a good compromise. This will be included in the next release.