Spire.XLS 15.10.3 adds support for reading Office cached cloud fonts by default
2025-10-27 08:52:44
We are delighted to announce the release of Spire.XLS 15.10.3. This version adds support for reading Office cached cloud fonts by default, in addition to system and in-memory fonts. It also adjusts the parameters of the AddDigitalSignature() and IDigitalSignatures.Add() methods, and fixes several known issues to improve the library’s stability and performance. Details are listed below. Here is a list of changes made in this release Category ID Description New feature SPIREXLS-5979 Adds support for reading Office cached cloud fonts by default, besides system font directories and in-memory fonts. Adjustment - Modifies the parameter list of the AddDigitalSignature() and IDigitalSignatures.Add()…
Spire.XLS 15.9.7 supports creating and modifying Equations
2025-09-24 06:10:59
We're pleased to announce the release of Spire.XLS 15.9.7. This version adds a new interface for creating and modifying Equations, and also supports the ISOMITTED, LAMBDA functions. Besides, some issues that occurred when converting Excel to PDF and copying worksheets have been successfully fixed. More details are shown below. Here is a list of changes made in this release Category ID Description Optimization SPIREXLS-5888 Optimizes the time consumption for converting Excel to PDF. Optimization SPIREXLS-5929 Optimizes the time consumption for converting Excel to HTML. New feature SPIREXLS-4316 Adds IXlsEquation Interface to support creating and modifying Equations. Workbook workbook = new…
Spire.XLS 15.8.3 supports FORMULATEXT and PDURATION functions
2025-08-26 06:18:45
We're pleased to announce the release of Spire.XLS 15.8.3. This version adds support for the FORMULATEXT and PDURATION functions. Meanwhile, several issues that occurred when converting Excel to PDF or images, saving workbooks, handling PivotTables, and preserving cell styles have also been successfully fixed. More details are listed below. Here is a list of changes made in this release Category ID Description New feature SPIREXLS-5800 Supports the FORMULATEXT function. sheet.Range["D2"].Formula = "=FORMULATEXT(B2)"; New feature SPIREXLS-5895 Supports the PDURATION function. sheet.Range["B2"].Formula = "=PDURATION(2.5%,2000,2200)"; Bug SPIREXLS-5878 Fixed an issue where text line breaks were incorrect when converting Excel to PDF. Bug SPIREXLS-5884…
Spire.XLS 15.7.8 adds support for loading Markdown documents
2025-07-16 09:40:39
We're pleased to announce the release of Spire.XLS 15.7.8. This version adds the LoadFromMarkdown() method to support for loading Markdown-format documents. It also includes several important bug fixes, such as issues with Excel-to-PDF conversion, AGGREGATE formula calculation, text layout, and formula evaluation. More details are listed below. Here is a list of changes made in this release Category ID Description New feature — Adds the LoadFromMarkdown() method to support for loading Markdown-format documents. Workbook wb = new Workbook(); wb.LoadFromMarkdown("test.md"); wb.SaveToFile("out.pdf", FileFormat.PDF); wb.SaveToFile("out.xlsx", ExcelVersion.Version2010); Bug SPIREXLS-5820 Fixes the issue where checkboxes were displayed incorrectly after converting Excel to PDF. Bug SPIREXLS-5833…
Spire.XLS 15.6.6 supports the SHEETS function
2025-06-23 06:20:49
We are excited to announce the release of Spire.XLS 15.6.6. The latest version supports the SHEETS function. Besides, some known bugs are fixed successfully in this version, such as the issue that the AutoFitColumns effect was not working correctly. More details are listed below. Here is a list of changes made in this release Category ID Description New feature SPIREXLS-5806 Supports the SHEETS function. sheet.Range["B2"].Formula = "=SHEETS()"; sheet.Range["B3"].Formula = "=SHEETS(Sheet2!C5)"; sheet.Range["B4"].Formula = "=SHEETS(Sheet3:Sheet5!A1)"; sheet.Range["B6"].Formula = "=SHEETS(Sheet4!C5); Bug SPIREXLS-5802 Fixes the issue where the AutoFitColumns effect was not working correctly. Bug SPIREXLS-5804 Fixes the issue where the style of shapes was…
Spire.XLS 15.5.2 supports detecting and removing duplicate rows
2025-05-27 01:27:20
We are excited to announce the release of Spire.XLS 15.5.2. This version supports detecting and removing duplicate rows and several new functions, such as TRIMRANGE and ERF.PRECISE. Besides, some known issues are fixed in this version, such as the issue that the sorting results were incorrect. More details are listed below. Here is a list of changes made in this release Category ID Description New feature SPIREXLS-5787 Supports detecting and deleting duplicate rows. // Remove duplicate rows in the worksheet sheet.RemoveDuplicates(); // Remove duplicate rows within specified range sheet.RemoveDuplicates(int startRow, int startColumn, int endRow, int endColumn); // Remove duplicate rows…
Spire.XLS 15.4.4 adds support for several formulas
2025-04-29 06:28:06
We're pleased to announce the release of Spire.XLS 15.4.4. This version adds support for several new formulas, and also supports auto-fitting row height in merged cells spanning multiple columns in a single row. Besides, some issues that occurred when converting Excel to PDF and saving files have been successfully fixed. More details are shown below. Here is a list of changes made in this release Category ID Description New feature SPIREXLS-5697 Supports auto-fitting row height in merged cells spanning multiple columns in a single row. Workbook workbook = new Workbook(); workbook.LoadFromFile(@"in.xlsx"); Worksheet sheet= workbook.Worksheets[0]; AutoFitterOptions options = new AutoFitterOptions(); options.AutoFitMergedCells…
Spire.XLS 15.4.0 supports more than ten new formulas
2025-04-09 01:42:00
We are excited to announce the release of Spire.XLS 15.4.0. This version introduces more than ten new formulas, such as RANK.AVG, PERCENTILE.INC, and BINOM.DIST. It also enhances the conversion from Excel to PDF. Besides, a lot known issues are fixed successfully in this version, such as the issue where the structure protection password was lost when saving Excel documents. More details are listed below. Here is a list of changes made in this release Category ID Description New feature SPIREXLS-5695 Supports the RANK.AVG formula. workbook.Worksheets[0].Range["E9"].Formula = "=RANK.AVG(10,A1:A6)"; New feature SPIREXLS-5696 Supports the RANK.EQ formula. //Default descending order workbook.Worksheets[0].Range["E9"].Formula = "=RANK.EQ(10,A1:A6)";…
