Release v4.2.0
This is the major release of the version v4.2.0
Changes
-
Package: NanoXLSX.Core
- Added detection and metadata handling for external workbook references in formulas and defined names.
- Added support for defined names, including cell and range references, formulas, constants, workbook/worksheet scope and comments.
- Added
FormulaDatafor extended formula metadata, including formula types, ranges, cached values, defined-name references and external-reference detection. - Added support for cell error values (
CellType.ErrorandErrors.FormulaError). - Added
Validators.ValidateWorksheetName(...). - Extended and optimized internal feature detection and processing.
- Extended the plug-in infrastructure with additional Reader and Writer interfaces and updated plug-in registration.
- Fixed a bug regarding plug-in loading. Bug fix provided by yolkin-games
-
Package: NanoXLSX.Writer
- Added writing of defined names.
- Added writing of extended formula metadata and cached formula values.
- Added writing of cell error values.
- Updated internal writer processing and package-part handling.
- Added infrastructure for writing external workbook references through compatibility plug-ins.
-
General
- Various internal processing optimizations.
- Added and extended test coverage for formulas, defined names, cell errors, relationship discovery and plug-ins.
- Code maintenance.
Note: An optional package NanoXLSX.Compatibility is available to handle external links.
Content
-
The release libraries (DLLs) for .NET 4.5 and .NET Standard 2.0
- PicoXLSX (meta package)
- NanoXLSX.Core
- NanoXLSX.Writer
- NanoXLSX.Formatting
-
The debug libraries and XML documentation (DLLs) for .NET 4.5 and .NET Standard 2.0
- PicoXLSX (meta package)
- NanoXLSX.Core
- NanoXLSX.Writer
- NanoXLSX.Formatting
The NuGet packages can be found at:
- https://www.nuget.org/packages/PicoXLSX (Meta package; This is what most users will need)
- https://www.nuget.org/packages/NanoXLSX.Core
- https://www.nuget.org/packages/NanoXLSX.Writer
- https://www.nuget.org/packages/NanoXLSX.Formatting