spreadsheetlab / XLParser

A C# parser for Microsoft Excel formulas with a 99.9% compatibility rate
Other
407 stars 91 forks source link

Can't parse cell-like named range #165

Closed jahav closed 1 year ago

jahav commented 1 year ago

The type of error: The parser can't parse a formula that Excel accepts. The input: W1.

The XLParser takes W1 as a CellToken (priority 100) and, it doesn't even try NameToken (priority -800). It then fails to parse the dot. For these situations, there is the NamedRangeCombinationToken... that fails because of a likely regex.

Original bug report: https://github.com/ClosedXML/ClosedXML/issues/1885