Formulas hangs on opening file with full-range formulas

vinci1it2000 / formulas

Excel formulas interpreter in Python.

https://formulas.readthedocs.io/

European Union Public License 1.1

358 stars 75 forks source link

Closed aglim closed 2 years ago

aglim commented 3 years ago

I have run into issue with full-range formulas like =SUM(A:A).

Formulas hangs in finish() method forever when loading attached example file:

xl_model = formulas.ExcelModel().loads("01.xlsx").finish()

(Now I am using this gist to set timeout for inputs like this)

vinci1it2000 commented 2 years ago

The new release improves the performance for parsing full ranges from 23 secs to about 3 secs.