Column range interpreted as intersection

spreadsheetlab / XLParser

A C# parser for Microsoft Excel formulas with a 99.9% compatibility rate

Other

407 stars 91 forks source link

Column range interpreted as intersection #156

Closed jahav closed 2 years ago

jahav commented 2 years ago

Column ranges ending with 3 letter column ranges (e.g. =A:AAA) are interpreted as intersection of the first two letter column range (e.g. A:AA) and a named range with the remaining name (e.g. A), but should be interpreted as a really wide column range.

Version 1.5.2.

WillemJann commented 2 years ago

Resolved in commit be994bdcefcb0656f109be407619097db833125f. A new version (v1.6.0) has just been released with this fix included.

jahav commented 2 years ago

Thank you.