XLParser

• Fix: exception for parser references of special ranges (#184)

• Fix: invalid parser reference for range with reference in function (#181)
• Support user defined functions in parser references (#182)

• Target netstandard2.0 (#178)
• Fix: cannot parse table reference to whole row (#177)
• Fix: cannot parse table reference followed by sheet reference (#179)

• Fix: restrict row numbers in cell address (#167)
• Improve parser references, add parse tree node

• Performance improvement: add prefixes to regex terminals (#161)
• Performance improvement: new terminal for Excel functions (#163)
• Fix: can't parse cell-like named range (#165)

• Fix: missing rule in structured references grammar (#158)
• Improve intersection of table references (#160)

• Improved support for structured (table) references (#116, #132, #147)
• Add table specifiers and table columns in parser reference
• Fix: escape characters in external links (#136, #152)
• Fix: large range incorrectly parsed (#154, #156)

• Build for .NET 4.5.2, 4.6.1 and standard 1.6, thanks igitur.
• Remove embedded Irony dependency in favor of daxnets updated fork.

Reference implementation of the Excel grammar published in the Journal of Systems and Software SCAM special issue paper "A Grammar for Spreadsheet Formulas Evaluated on Two Large Datasets" by E. Aivaloglou, D. Hoepelman and F. Hermans.

• Fixed several errors in which names/named ranges were allowed
  • Question marks are now allowed
  • Can now start with all unicode letters (e.g. =äbc)
  • Corrected characters which are allowed if the name starts with a cell name or TRUE/FALSE (e.g. =A1.MYNAME)
• Allow for whitespace-only sheetnames (e.g. =' '!A1), altough they will always be returned as " " by PrefixInfo
• Made some corrections in how multiple sheet references (=Sheet1:Sheet3!A1) are parsed
• Removed escape sequences in strings (e.g. "Line1\nLine2") as these are not part of the Excel formula language
• Added support for structured references to a complete table (e.g. =MyTable[])

• Adds support for special characters in structured references.

• Adds equality to PrefixInfo class
• Fixes parse error if external reference file path contains a space (='C:\My Dir\[file.xlsx]Sheet'!A1)
• ExcelFormulaParser.SkipToRelevant no longer skips references without a prefix. <br> This is a breaking change, but the old behavior is arguably a bug. An argument is added to restore old behavior, defaults to new behavior.

• Adds GetReferenceNodes method to ExcelFormulaParser

• Added some missing methods that test for specific types of operators
• Added tests and fixes if necessary for methods that were missing tests

Reference implementation of the Excel grammar published in the paper "A Grammar for Spreadsheet Formulas Evaluated on Two Large Datasets" by E. Aivaloglou, D. Hoepelman and F. Hermans.

• Added all formulas from EUSES and Enron datasets and tests to check if they all parse
• Made parser thread safe
• Fixed #9: some tokens which would not accept all unicode characters (like UDF) now do so
• 'Sheet1:Sheet5' will now correctly parse as MULTIPLESHEETS instead of a single sheet