Spire.XLS 12.8.1 supports getting the CurrentRegion of cell
2022-08-17 04:18:38
We are excited to announce the release of Spire.XLS 12.8.1. This version supports getting the CurrentRegion of cell. Moreover, it also enhances the conversion from Excel to PDF and fixes some known issues such as the image in Excel was replaced after saving. More details are listed below. Here is a list of changes made in this release Category ID Description New feature SPIREXLS-1483 Supports getting the CurrentRegion of cell. sheet.Range["A1"].CurrentRegion; Bug SPIREXLS-3898 Fixes the issue that the repeated labels of pivot table lost after converting Excel to PDF. Bug SPIREXLS-3973 Fixes the issue that the image in Excel was…
Spire.XLS 12.7.1 supports setting whether to keep the number format of the data when exporting to DataTable
2022-07-13 09:28:28
We are excited to announce the release of Spire.XLS 12.7.1. This version supports setting whether to keep the number format of the data when exporting to DataTable and supports calculating "UNICODE" formulas. Moreover, it also enhances the conversion from Excel to PDF and fixes some known issues such as formulas were not calculated after inserting formulas. More details are listed below. Here is a list of changes made in this release Category ID Description New feature SPIREXLS-3944 Supports setting whether to keep the number format of the data when exporting to DataTable. ExportTableOptions options = new ExportTableOptions(); options.KeepDataFormat = false;…
Spire.XLS.12.6.1 provides an interface that supports setting whether to apply styles to rows and columns
2022-06-14 01:21:50
We are excited to announce the release of Spire.XLS 12.6.1. This version provides an interface that supports setting whether to apply styles to rows and columns. And it supports converting new chart types in Excel 2016 like waterfall, treemap and boxandwhisker to PDF and image. What’s more, it also enhances the conversion from Excel to PDF and fixes some known issues such as the content of cells in custom format was not correct after converting to PDF. More details are listed below. Here is a list of changes made in this release Category ID Description New feature SPIREXLS-3812 Provides an…
Spire.XLS 12.5.3 provides an overload of InsertArray method
2022-05-26 08:42:35
We are excited to announce the release of Spire.XLS 12.5.3. This version provides an overload of InsertArray method, which supports setting whether to automatically convert date string to datetime format when inserting arrays into Excel document. In addition, it enhances the conversion from Excel to PDF and fixes some known issues such as the application threw "Invalid file format" when loading XML. More details are listed below. Here is a list of changes made in this release Category ID Description New feature SPIREXLS-3852 Provides an overload of InsertArray method, which supports setting whether to automatically convert date string to datetime…
Spire.XLS 12.5.1 supports centering text via PrstGeomShape class
2022-05-16 03:31:19
We are excited to announce the release of Spire.XLS 12.5.1. This release supports centering text via IPrstGeomShape class. It also enhances the conversion from Excel to PDF, HTML as well as CSV, and optimizes the time and memory used for formatting cell numbers. Moreover, it fixes some known issues such as the issue that the data was not correct when transferring Excel data to a data table. More details are listed below. Here is a list of changes made in this release Category ID Description New feature SPIREXLS-3806 IPrstGeomShape Implements the style of centered text. IPrstGeomShape shape = book.Worksheets[0].PrstGeomShapes[0]; shape.TextVerticalAlignment…
Spire.XLS 12.4.1 supports converting Pareto, Sunburst, Histogram charts of Chart2016 when converting Excel to PDF and image
2022-04-15 03:22:01
We are happy to announce the release of Spire.XLS 12.4.1. This version supports converting Pareto, Sunburst, Histogram charts of Chart2016 in the function of converting Excel to PDF and Image, and enhances the conversion from Excel to HTML and Excel to CSV. In addition, it fixes some known issues such as the application threw "Invalid cell name" when loading an Excel file. More details are listed below. Here is a list of changes made in this release Category ID Description New feature - In the functions of converting Excel to PDF and Image, added supports converting Pareto, Sunburst, Histogram charts…
Spire.XLS 12.3.8 supports setting content to fit page width when converting Excel to PDF
2022-03-23 05:37:19
We are happy to announce the release of Spire.XLS 12.3.8. This version supports setting content to fit page width when converting Excel to PDF. Besides, it fixes some known issues such as the incorrect pagination issue when converting Excel to PDF. More details are listed below. Here is a list of changes made in this release Category ID Description New feature SPIREXLS-3727 Supported that setting content to fit page width when converting Excel to PDF. workbook.ConverterSetting.SheetFitToWidth = true; Bug SPIREXLS-1625 Fixed the incorrect pagination issue when converting Excel to PDF. Bug SPIREXLS-3682 Fixed the incorrect pagination issue when printing Excel.…
Spire.XLS 12.3.2 enhances the conversion from Excel to PDF
2022-03-04 07:38:15
We are happy to announce the release of Spire.XLS 12.3.2. This version enhances the conversion from Excel to PDF. Besides, it fixes some known issues such as the application is interrupted even it catches the “NullReferenceException”. More details are listed below. Here is a list of changes made in this release Category ID Description Bug SPIREXLS-3605 Fixes the issue that the lines were thicker after converting Excel to PDF. Bug SPIREXLS-3639 Fixes the issue that the font size and borders were changed after converting Excel to PDF. Bug SPIREXLS-3644 SPIREXLS-3670 SPIREXLS-3678 Fixes the issue that the content was incorrect after…
