Skip to content

Releases: spreadsheetlab/XLParser

Version 1.5.1

06 Jan 14:04
Compare
Choose a tag to compare
  • Support for multi range formulas (#98, #124)
  • Fix: incorrect operator precedence
  • Fix: MinLocation and MaxLocation of row/column references

Version 1.5.0

30 Nov 14:50
Compare
Choose a tag to compare
  • Support for implicit intersection operator, spill range operator, spill error (#113, thanks to @drmason789)
  • Accept references to file paths with URL (#114, thanks to @joerivv)
  • Include dynamic array and spill functions (#120, thanks to @drmason789)
  • Include some new Office 365 functions
  • Remove some invalid Excel functions
  • Fix invalid MinLocation and MaxLocation of row and column references (#123)
  • Add #GETTING_DATA error token (#125, thanks to @PleasantSolutionsDev2)
  • Fix incorrect whitespace in Print method (#128, thanks @terryaney)

Version 1.4.2

06 Oct 07:25
Compare
Choose a tag to compare
  • Parse defined names with euro sign (#106)
  • Fixed problems with dashes in external file paths (#107)
  • Fixed problems with URLs in external file paths (#108)
  • Fixed problems with relative external file paths (#109)
  • Add file path to the parser references of the formula analyzer

Version 1.4.1

16 Jul 08:37
Compare
Choose a tag to compare
  • Add support for external defined name (#101)
  • Add support for structured table references (#102)
  • Improved detection of external file names (#105)

XLParser 1.3.10

17 Mar 16:57
Compare
Choose a tag to compare
  • Add support for formulas with a worksheet name that is #REF! (#76)
  • Fix for UDF names consisting only of "R" or "C" (#56)

XLParser 1.3.9

12 Feb 18:09
Compare
Choose a tag to compare
  • Fix problem with quoted sheet names starting with white space #87

XLParser 1.3.8

03 Feb 12:15
Compare
Choose a tag to compare
  • Fixed parser fails on formulas with addin (.xla) explicit references (#53 and #84)
  • Add ParserReference.RefError

XLParser 1.3.7

19 Jun 13:53
Compare
Choose a tag to compare
  • Added method for getting all references (to cells or ranges) included in formulas (thanks to aivaloglou)
  • Fixed regression where the parse tree was used before testing if the parser was successful
  • Updated Irony.NetCore from 1.0.10 to 1.0.11

XLParser 1.3.6

19 Jun 13:54
Compare
Choose a tag to compare
  • Added sign assembly attributes and key file for strong named assemblies (thanks to greggbjensen)
  • Fix the span position of the intersect operators (thanks to joerivv)

XLParser 1.3.4

09 May 06:27
7193cac
Compare
Choose a tag to compare

Changes between 1.3.1 and 1.3.4:

  • Added several built-in functions (#69, #70)
  • Switch to Irony.NetCore on NuGet - don't use MyGet anymore. (#66)