We are pleased to announce the release of Spire.XLS 14.3.3. This version supports PivotTable grouping functionality. In addition, it also supports adding the FindAll() method to CellRange and setting "Repeat All Item Labels" for PivotTable. Some known issues have also been successfully fixed in this version, such as the issue that the content was incorrect after saving Excel files. More details are listed below.
Here is a list of changes made in this release
| Category | ID | Description |
| New feature | SPIREXLS-765 | Supports PivotTable grouping function.
XlsPivotTable pt = worksheet.PivotTables[0] as XlsPivotTable;
IPivotField field = pt.RowFields[0];
DateTime start = new DateTime(2024, 5, 6);
DateTime end = new DateTime(2024, 10, 6);
PivotGroupByTypes[] types = new PivotGroupByTypes[]{ PivotGroupByTypes.Days };
field.CreateGroup(start, end, types, 1);
|
| New feature | SPIREXLS-5091 | Supports adding FindAll() method to CellRange.
Workbook workbook = new Workbook(); workbook.LoadFromFile(@"test.xlsx"); Worksheet sheet = workbook.Worksheets[0]; sheet.Range["A1"].FindAll() |
| New feature | SPIREXLS-5123 | Supports setting "Repeat All Item Labels" for PivotTable.
foreach (XlsPivotTable pt in wb.Worksheets["PivotTable"].PivotTables)
{
pt.Options.RepeatAllItemLabels = true;
}
|
| Bug | SPIREXLS-5097 | Fixes the issue that the content was incorrect after saving Excel files. |
| Bug | SPIREXLS-5103 | Fixes the issue that the sheet content exported using ExportDataTable was incorrect. |
| Bug | SPIREXLS-5105 | Fixes the issue that formula values were incorrect when converting Excel to PDF. |
| Bug | SPIREXLS-5106 | Fixes the issue that the program threw "Size of image is too large" exception when converting Excel to images. |
| Bug | SPIREXLS-5110 | Fixes the issue that the PivotTable column names were inconsistent when converting Excel to pictures. |
| Bug | SPIREXLS-5122 | Fixes the issue that there were some extra blank comments in result files after using CellRange.Comment.Text. |
| Bug | SPIREXLS-5125 | Fixes the issue that the styles were incorrect when converting Excel to PDF. |
| Bug | SPIREXLS-5126 | Fixes the issue that the program threw "ArgumentNullException" exception when loading files. |
| Bug | SPIREXLS-5148 | Fixed the issue that the program threw "NullReferenceException" exception when splitting a document. |
Click the link below to download Spire.XLS 14.3.3:
More information of Spire.XLS new release or hotfix:
