Formula tokenizer cannot parse some ranges where a worksheet name in quotations is used

Issue #1117 resolved
Michael Thiesen
created an issue

More specifically, if the second part of the range references a worksheet using quotations, a TokenizerError is raised. Openpyxl 2.5.8 and Python 3.7.0 are being used.

Some examples:

>>> Tokenizer("='N'!A1:'N'!A2")
TokenizerError: Unexpected character at position 8 in '='N'!A1:'N'!A2'

>>> Tokenizer("=A1:'N'!A2")
TokenizerError: Unexpected character at position 4 in '=A1:'N'!A2'

These types of formulas work in Excel (and LibreOffice) leading me to believe they should work.

Comments (4)

  1. Log in to comment