2.0.0

What's Changed

• Expose formula copy visitor by @jahav in #11
• Add ReferenceArea.ParseA1 method by @jahav in #12
• Add ReferenceArea.TryParseA1 method by @jahav in #13
• Add ParseSheetA1 method by @jahav in #14
• Move reference parser methods to dedicated class by @jahav in #15
• Add Reference.TryParseSheetName by @jahav in #16
• Add ReferenceParser.TryParseA1(text, sheet, reference) by @jahav in #17
• Add ReferenceParser.TryParseName by @jahav in #18
• ReferenceArea To A1 logic by @jahav in #20
• Fix function extension point by @jahav in #23
• Add support for bang reference by @jahav in #22
• LOG10 function is not a cell func by @jahav in #24

Full Changelog: 1.2.0...2.0.0

2.0.0-preview1

What's Changed

• Expose formula copy visitor by @jahav in #11
• Add ReferenceArea.ParseA1 method by @jahav in #12
• Add ReferenceArea.TryParseA1 method by @jahav in #13
• Add ParseSheetA1 method by @jahav in #14
• Move reference parser methods to dedicated class by @jahav in #15
• Add Reference.TryParseSheetName by @jahav in #16
• Add ReferenceParser.TryParseA1(text, sheet, reference) by @jahav in #17
• Add ReferenceParser.TryParseName by @jahav in #18
• ReferenceArea To A1 logic by @jahav in #20
• Fix function extension point by @jahav in #23
• Add support for bang reference by @jahav in #22
• LOG10 function is not a cell func by @jahav in #24

Full Changelog: 1.3.0...2.0.0-preview1

1.3.0

Bugfixes

• ReferenceArea wasn't correctly serialized to A1 #20

Full Changelog: 1.2.0...1.3.0

1.2.0

What's Changed

• Accept references with deleted parts (Sheet!#REF!, #REF!A1 or #REF!#REF!) by @jahav in #6
• Fix incorrect parsing and serialization of row span (7:10) and col span (D:E). by @jahav in #7
• Add ability to delete sheet during formula conversion instead of just renaming. by @jahav in #8
• Split single copy+modify factory to a copy factory and modify references factory by @jahav in #9
• Publish RefModVisitor visitor by @jahav in #10

Full Changelog: 1.1.0...1.2.0

1.1.0

What's Changed

• Keep whitespaces during A1<->R1C1 conversion by @jahav in #4
• R1C1 -> A1 conversion results in #REF! when out of bounds by @jahav in #5

New Contributors

• @jahav made their first contribution in #4

Full Changelog: 1.0.0...1.1.0

Initial release

Initial release, the parser can parse formulas and convert between A1-R1C1.

There are things I would like to do (like review and clean codebase and run fuzzer against the parser), but let's say perfect is the enemy of good. It has nice test coverage and works for formulas I have found in the wild by CommonCrawl. A1-R1C1 conversion doesn't maintain whitespaces yet, but IAstFactory has sufficient surface to make it happen. The last changes slowed it a little, so it's ~2.5µs/formula.

1.0.0-beta4

Sign assemblies for nuget.

Rather useless, since I put .snk directly in the repo, but it's more about satisfying ClosedXML that needs signed dependency. I tried and failed to do it with github secrets and at the same time locally, will figure it out later (+ClosedXML does it same way).

1.0.0-beta3

ClosedParser parses all data sets and has reasonably good coverage. I can use it as a dependency for ClosedXML and have test pass, so good enough for initial version.

Grammar provided by MS is incomplete and in many cases incorrect/missing, so it will need more TLC in the future.