Spire.XLS.12.9.2 supports getting the color of condition formats
2022-09-23 10:08:17
We are excited to announce the release of Spire.XLS 12.9.2. This version supports getting the color of condition formats. Moreover, it also enhances the conversion from Excel to PDF and fixes some known issues such as the application threw the "System.ArgumentException" when getting RichText from Excel on Linux system. More details are listed below. Here is a list of changes made in this release Category ID Description New feature SPIREXLS-4084 Supports getting the color of condition formats. Color color = cRange.GetConditionFormatsStyle().Color; Bug SPIREXLS-718 SPIREXLS-4066 Fixes the issue that caused incorrect content formatting after converting Excel to PDF Bug SPIREXLS-2073 Fixes…
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.…
