Bytescout.Spreadsheet 4.6.0.2025

• .NETCoreApp 2.1

  • Microsoft.Windows.Compatibility (>= 5.0.2)

ByteScout Spreadsheet SDK for .NET, ASP.NET, ActiveX/COM
ByteScout, Inc. (c) 2006-2022.

- Does not require Excel or Office installed;
- Formula calculation support (Excel style formulas);
- Reads XLS, XLSX, ODS (Open Office Calc), CSV formats;
- Writes XLS, XLSX, CSV, TXT, XML, JSON, HTML, PDF formats;
- Imports from and exports to JSON format;
- Supports cell formating, rich text, charts, images, borders, etc.;
- Supports legacy languages like Visual Basic 6, VBScript, JScript, ASP through ActiveX/COM interface;
- Command line utility is included for conversion of spreadsheet files from command line or .BAT files;
- And more...

History of changes:

4.6.0.2025 (September 27, 2022)
= The row height and column width in Points are made public.
= Other minor fixes and improvements.

4.5.0.2012 (June 7, 2022)
- Fixed case sensitive issue in function names.
= Other minor fixes and improvements.

4.4.0.1994 (January 24, 2022)
= .NET Core min required version is 2.1 now (was 2.0).
= Other minor fixes and improvements.

4.3.0.1981 (October 4, 2021)
- Fixed ISO-8601 date parsing.
- Fixed formula parsing.
- Fixed handling of shared formulas.
- Fixed black charts background in XLS format.
= Other minor fixes and improvements.

4.2.0.1943 (May 18, 2021)
+ Added support for 'HYPERLINK' function.
= Improved import of CSV with nested quotation and multiline cells.
= Improved data types detection in CSV import.
- Fixed null exceptions during the loading of some SpreadsheetML (XML Spreadsheet) files.
- Fixed CSV export: do not convert numeric strings with leading zeros, like "00123" to numbers.
- Fixed saving of 'PageSetup.Zoom' property in XLS format.
- Fixed column auto-fit when the column contains merged cells.
- Fixed very rare 'temp file exists' conflict.

4.1.0.1943 (February 8, 2021)
+ WinFormsControl: Added support for touch gestures: panning and inertial scrolling.
= Improved CSV export.
= Improved parsing of formulas.
= Improved support for custom cell formats.
= Improved worksheet splitting and freezing.
- Added missing "COUNTIFS" formula.
- PDF export: fixed crash on empty spreadsheet.
- Fixed loading of SpreadsheetML (XML Spreadsheet) documents from stream.
= .NET Core build is now Linux-compatible.
= Other minor fixes and improvements.

4.0.0.1910 (October 26, 2020)
+ Added support for SUBSTITUTE and COUNTBLANK functions.
- Fixed parsing and calculation of the unary plus and minus operators.
- Fixed freezing of rows and columns.
- Fixed saving of named ranges in XLS and XLSX formats.
- Fixed editing of protected worksheets.
= Improved parsing of OpenXML spreadsheets.
= Added informational properties 'Cell.ColIndex' and 'Cell.RowIndex'.
- Fixed 'Row.NumberFormat' and 'Column.NumberFormat' properties.
- Fixed 'Cell.FontColorIndex' property.
= Improved ODF spreadsheet detection when reading from stream.
- Fixed tread-safety issue.
= Other minor fixes and improvements.
= Improved .NET Core compatibility.
= Other minor fixes and improvements.

3.9.0.1872 (July 1, 2020)
= Improved the parsing of formulas.
= Improved handling of protected worksheets.
= 'Workbook.PictureList' now contains collection of all images in the spreadsheet.
= Improved automatic page size when exporting to PDF.
= Other minor fixes and improvements.

3.8.0.1843 (March 19, 2020)
- Conditional formatting was lost when saving.
- Worksheet auto-calculation was not working for some formulas.
= Improved support for worksheet protection.
= Improved .NET Core compatibility.
= Other minor fixes and improvements.

3.7.0.1832 (February 11, 2020)
= Improved export to PDF format.
= Other minor fixes and improvements.

3.6.0.1814 (December 4, 2019)
+ Added Worksheet reference to `CustomFunctionsCallback` delegate providing access to worksheet that contains custom function.
- Fixed calculation of custom functions when opening a document.
= Other minor fixes and improvements.

3.5.0.1807 (November 1, 2019)
+ XLSX: Added support for Table objects and references.
- Fixed parsing of formulas with omitted arguments.
= Improved parsing of complex headers and footers.
= Other minor fixes and improvements.

...