Released: Nov 23, 2021

Updates in V1.3.2

Funktionen

• Added Microsoft .NET 5 support - The Spreadsheet.WPF distribution now includes assemblies for .NET 5. Locally installed assemblies don't show automatically in toolbox at this time, you can add them to projects either manually or through Nuget package manager.
• Miscellaneous
  • Custom format strings can now contain color names in square brackets, compatible with Microsoft Excel color specifiers.
  • Extends the set of expression types in which blank cells are promoted to zeros or empty strings when referenced from formulas.
  • Names of named ranges can now include backslash and question mark symbols.

Fehlerkorrekturen

• SUMIF and AVERAGEIF fixes for multiple-column ranges.
• Fixed diagonal borders showing in exported Excel files when border width is set to 0.
• Fixed skipping manual page breaks (set via PageBreak property).
• ExcelImporter fix for default false value of validations' showErrorMessage attribute.
• Fixed missing parentheses when ExcelImporter imports shared formulas.