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)";…
Spire.XLS 15.3 supports creating, modifying and removing slicer
2025-02-28 08:49:25
We're pleased to announce the release of Spire.XLS 15.3. This version supports creating slicer using table data, modifying slicer, retrieving slicer information and removing slicer. Besides, it also fixes an issue that the slicers were lost when converting Excel to PDF. More details are shown below. Here is a list of changes made in this release Category ID Description New feature - Added support for creating slicer using table data. Workbook wb = new Workbook(); Worksheet worksheet = wb.Worksheets[0]; worksheet.Range["A1"].Value = "fruit"; worksheet.Range["A2"].Value = "grape"; worksheet.Range["A3"].Value = "blueberry"; worksheet.Range["A4"].Value = "kiwi"; worksheet.Range["A5"].Value = "cherry"; worksheet.Range["A6"].Value = "grape"; worksheet.Range["A7"].Value = "blueberry";…
Spire.XLS 15.2.3 supports preserving the original format in the ExportDataTable() function
2025-02-20 08:20:46
We are pleased to announce the release of Spire.XLS 15.2.3. The latest version supports preserving the original format in the ExportDataTable() function. Moreover, several known bugs are fixed successfully in this update, such as the issue that Japanese characters were converted to English characters after updating the pivot table. More details are shown below. Here is a list of changes made in this release Category ID Description New feature SPIREXLS-568 Supports preserving the original format in the ExportDataTable() function. ExportTableOptions op = new ExportTableOptions(); op.ExportColumnNames = true; op.KeepDataType = true; var r = sheet.Range["A1:M7"]; New feature SPIREXLS-5539 Supports the MUNIT…
Spire.XLS 15.1.3 supports the CSCH, RANDARRAY, COTH, SEQUENCE, EXPAND functions
2025-01-14 07:32:12
We're pleased to announce the release of Spire.XLS 15.1.3. This version adds the support for many functions, CSCH, RANDARRAY, COTH, SEQUENCE, EXPAND, CHOOSECOLS, CHOOSEROWS, and DROP. Besides, it also fixes some issues that occurred when converting XLSM to PDF, Excel to PDF, calculating formula values and setting tab color. More details are shown below. Here is a list of changes made in this release Category ID Description New feature SPIREXLS-5542 Supports the CSCH function New feature SPIREXLS-5548 Supports the RANDARRAY function. New feature SPIREXLS-5621 Supports the COTH function. New feature SPIREXLS-5622 Supports the SEQUENCE function. New feature SPIREXLS-5627 Supports the…
Spire.XLS 14.12.2 supports the SEC, WRAPCOLS, PERCENTOF, REPTARRAY, SUBSTITUTES functions
2024-12-19 03:11:42
We're pleased to announce the release of Spire.XLS 14.12.2. This version adds the support for many functions, including SEC, WRAPCOLS, WRAPROWS, PERCENTOF, REPTARRAY, SECH, SUBSTITUTES and more. Besides, it also fixes some issues that occurred when converting Excel to PDF and printing Excel files. More details are shown below. Here is a list of changes made in this release Category ID Description New feature SPIREXLS-5561 Supports the SEC function. New feature SPIREXLS-5562 Supports the WRAPCOLS function. New feature SPIREXLS-5563 Supports the WRAPROWS function. New feature SPIREXLS-5574 Supports the VSTACK function. New feature SPIREXLS-5577 Supports the PERCENTOF function. New feature SPIREXLS-5578…
