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 based on specific columns and headers sheet.RemoveDuplicates(int startRow, int startColumn, int endRow, int endColumn, boolean hasHeaders, int[] columnOffsets) |
| New feature | SPIREXLS-5793 SPIREXLS-5797 SPIREXLS-5798 SPIREXLS-5801 | Supports new functions (TRIMRANGE, ERF.PRECISE, ERFC.PRECISE, and PERMUTATIONA).
sheet.Range["A45"].Formula = "=TRIMRANGE(A1:H10, 1, 1)"; sheet.Range["B4"].Formula = "=ERF.PRECISE(1)"; sheet.Range["B4"].Formula = "=ERFC.PRECISE(NULL)"; sheet.Range["B9"].Formula = "=PERMUTATIONA(A5,A5)" |
| Bug | SPIREXLS-5785 | Fixes the issue that getting the font of cell text was incorrect. |
| Bug | SPIREXLS-5792 | Fixes the issue that the sorting results were incorrect. |
| Bug | SPIREXLS-5796 | Fixes the issue that the program threw “ArgumentOutOfRangeExceltion” when loading an Excel document. |
Click the link to download Spire.XLS 15.5.2:
More information of Spire.XLS new release or hotfix:
