We are pleased to announce the release of Spire.XLS 13.5.6. This version adds the method to optimize the speed of deleting rows and it adds two methods to realize the movement of chartsheets and worksheets between positions. Besides, it enhances the conversion from Excel to PDF and image. In addition, many known issues are fixed in this version, such as the issue that the setting on top function does not take effect when adding a text box. More details are listed below.
Here is a list of changes made in this release
| Category | ID | Description |
| New feature | SPIREXLS-4560 | Adds two methods to realize the movement of chartsheets and worksheets between positions.
workbook.Chartsheets[int index1].MoveSheet(int index2); workbook.Chartsheets[int index1].MoveChartsheet(int index2) |
| New feature | SPIREXLS-4684 | Adds the method to optimize the speed of deleting rows. |
| Bug | SPIREXLS-4587 | Fixes the issue that the pivot table fields were displayed as "Column Labels" after converting a sheet to images. |
| Bug | SPIREXLS-4605 | Fixes the issue that the chart data was not refreshed when converting an XLSX document to PDF. |
| Bug | SPIREXLS-4614 | Fixes the issue that the setting on top function does not take effect when adding a text box. |
| Bug | SPIREXLS-4643 | Fixes the issue that the table styles were incorrect when converting an XLSX document to PDF. |
| Bug | SPIREXLS-4644 | Fixes the issue that the application threw” Syste.OverflowException” when loading an XLS document. |
| Bug | SPIREXLS-4645 | Fixes the issue that the data format of retrieved cells was incorrect. |
| Bug | SPIREXLS-4646 | Fixes the issue that the application threw "System.FormatException” when adding HTML content. |
| Bug | SPIREXLS-4665 | Fixes the issue that the chartsheets could not be obtained after calling the MoveWorksheet method twice. |
| Bug | SPIREXLS-4666 | Fixes the issue that the text exceeds the cell after setting AutoFitColumns when the cell contains Chinese characters. |
| Bug | SPIREXLS-4673 | Fixes the issue that the background colors were inconsistent when converting an XLSX document to HTML. |
| Bug | SPIREXLS-4678 | Fixes the issue that the program reported an error "This structured storage version is not supported." when loading an XLS document. |
| Bug | SPIREXLS-4681 | Fixes the issue that the style of an added HTML strong tag was not recognized. |
Click the link to download Spire.XLS 13.5.6:
More information of Spire.XLS new release or hotfix:
