Spire.XLS 11.3.4

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: