search

vinci1it2000 / formulas

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

Regex doesn't match when sheet has a double quotation in its name ("). #113

Closed jonathanpedersen closed 8 months ago

jonathanpedersen commented 1 year ago

Describe the bug I have a sheet title with the word "Paper" in it. When I load it using the follow code...

xl_model = formulas.ExcelModel().loads(filepath)

it fails with the error...

for k, v in _re_range.match(ref).groupdict().items(): AttributeError: 'NoneType' object has no attribute 'groupdict'

Suggesting that the _re_range.match(ref) returns None, suggesting the regex doesn't match.

When I remove the double quotations from the sheet's title, it works flawlessly.

To Reproduce I would like to avoid this if possible, as the excel spreadsheet contains sensitive data that would be hard to remove.

Expected behavior Normal loading.

Desktop (please complete the following information):

Additional context Add any other context about the problem here.

vinci1it2000 commented 8 months ago

Fixed it will be included in the next release.