News & Releases
|
|

Spire.XLS 11.3.4 supports setting the shape order
We are glad to announce the release of Spire.XLS 11.3.4. This version supports setting the shape order and operating the theme of Workbook as well as supports getting the range of freeze panes. Meanwhile, it enhances the conversions from Excel to PDF/Image and fixes the issues occurred in the course of saving Excel files. More details are listed below.
Here is a list of changes made in this release
| Category | ID | Description |
| New Feature | SPIREXLS-3112 | Supports setting the shape order.
wb.Worksheets[0].Pictures[0].ChangeLayer(ShapeLayerChangeType.BringForward); wb.Worksheets[1].Pictures[0].ChangeLayer(ShapeLayerChangeType.BringToFront); wb.Worksheets[2].Pictures[1].ChangeLayer(ShapeLayerChangeType.SendBackward); wb.Worksheets[3].Pictures[1].ChangeLayer(ShapeLayerChangeType.SendToBack); |
| New Feature | SPIREXLS-3117 | Supports operating the theme of Workbook.
//copy the theme from Excel workbook.CopyTheme(srcWorkbook); //set theme color workbook.SetThemeColor(ThemeColorType.Accent1, Color.Blue); //get theme color Color color = workbook.GetThemeColor(ThemeColorType.Accent2); //set style as theme color style.SetThemeColor(ThemeColorType.Lt1, 0.1); //get theme color of style bool isThemeColor = style.GetThemeColor(out themeType, out tint); |
| New Feature | SPIREXLS-3120 | Supports getting the range of freeze panes.
sheet.GetFreezePanes(out rowIndex, out colIndex); |
| Bug | SPIREXLS-2223 SPIREXLS-2575 |
Fixes the issue that the content was incorrect after converting Excel to Image. |
| Bug | SPIREXLS-2724 | Fixes the issue that the font format was incorrect after converting Excel to PDF. |
| Bug | SPIREXLS-2820 | Fixes the issue that the pagination was incorrect after converting Excel to PDF. |
| Bug | SPIREXLS-3084 | Fixes the issue that the chart format was incorrect after saving it. |
| Bug | SPIREXLS-3113 | Fixes the issue that the color of pie chart was incorrect. |
Click the link to download Spire.XLS 11.3.4:
More information of Spire.XLS new release or hotfix: