search

spreadsheetlab / XLParser

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

Invalid ParserReference for range with OFFSET function #180

Closed WillemJann closed 1 year ago

WillemJann commented 1 year ago

Consider the following formula: =SUM(F13:OFFSET(E13,0,12))

The current version of XLParser parses this formula and returns one ParserReference with MinLocation of F13 and MaxLocation of E13. However, this represents an invalid range. Two ParserReferences are expected: one for F13 and one for E13.