We are excited to announce the release of Spire.XLS 12.11.3. This version supports CEILING.MATH, BITOR, BITAND, BITLSHIFT, and BITRSHIFT formula, "SHA-512" encryption scheme, grouping shapes, and setting the layout pattern of the entire pivot table. Besides, it enhances the conversion from Excel to PDF and HTML to Excel. What’s more, some known issues are fixed successfully. More details are listed below.
Here is a list of changes made in this release
| Category | ID | Description |
| New feature | SPIREXLS-4120 | Supports CEILING.MATH formula.
Workbook workbook = new Workbook();
workbook.Worksheets[0].Range["A1"].Formula = "CEILING.MATH(-2.78,5,-1)";
workbook.CalculateAllValue();
workbook.SaveToFile("1.xlsx"，ExcelVersion.Version2016);
|
| New feature | SPIREXLS-4195 | Supports BITOR formula.
Workbook workbook = new Workbook();
workbook.Worksheets[0].Range["A1"].Formula = "BITOR(23,10)";
workbook.CalculateAllValue();
workbook.SaveToFile("1.xlsx"，ExcelVersion.Version2016);
|
| New feature | SPIREXLS-4199 | Supports BITAND formula.
Workbook workbook = new Workbook();
workbook.Worksheets[0].Range["A1"].Formula = "BITAND(23,10)";
workbook.CalculateAllValue();
workbook.SaveToFile("1.xlsx"，ExcelVersion.Version2016);
|
| New feature | SPIREXLS-4212 | Supports BITLSHIFT formula.
Supports BITLSHIFT formula.
Workbook workbook = new Workbook();
workbook.Worksheets[0].Range["A1"].Formula = "BITLSHIFT(23,2)";
workbook.CalculateAllValue();
workbook.SaveToFile("1.xlsx"，ExcelVersion.Version2016);
|
| New feature | SPIREXLS-4214 | Supports BITRSHIFT formula.
Workbook workbook = new Workbook();
workbook.Worksheets[0].Range["A1"].Formula = "BITRSHIFT(23,2)";
workbook.CalculateAllValue();
workbook.SaveToFile("1.xlsx"，ExcelVersion.Version2016);
|
| New feature | SPIREXLS-4191 | Supports grouping shape.
Workbook workbook = new Workbook();
Worksheet worksheet = workbook.Worksheets[0];
IPrstGeomShape shape1 = worksheet.PrstGeomShapes.AddPrstGeomShape(1, 3, 50, 50, PrstGeomShapeType.RoundRect);
IPrstGeomShape shape2 = worksheet.PrstGeomShapes.AddPrstGeomShape(5, 3, 50, 50, PrstGeomShapeType.Triangle);
GroupShapeCollection groupShapeCollection = worksheet.GroupShapeCollection;
groupShapeCollection.Group(new Spire.Xls.Core.IShape[] { shape1,shape2});
workbook.SaveToFile("1.xlsx",ExcelVersion.Version2013);
|
| New feature | SPIREXLS-4194 | Supports "SHA-512" encryption scheme. |
| New feature | SPIREXLS-4200 | Supports setting the layout pattern of the entire pivot table.
xlsPivotTable.Options.ReportLayout = PivotTableLayoutType.Tabular; |
| Bug | SPIREXLS-4161 | Fixes the issue that the border and the style of table lost after converting HTML to Excel. |
| Bug | SPIREXLS-4163 | Fixes the issue that the program threw System.NullReferenceException when getting the color of conditional formatting. |
| Bug | SPIREXLS-4164 | Fixes the issue that the content had an extra comma after converting chart to images. |
| Bug | SPIREXLS-4182 | Fixes the issue that the program did not throw an error when decrypting excel file with a wrong password. |
| Bug | SPIREXLS-4189 | Fixes the issue that there were blank columns after deleting hidden columns. |
| Bug | SPIREXLS-4197 | Fixes the issue that the content of the result document was different from that of the original document after the document was loaded and saved. |
| Bug | SPIREXLS-4211 | Fixes the issue that the double quotation marks were incorrect after converting Excel to CSV. |
| Bug | SPIREXLS-4218 | Fixes the issue that the result of the cell range calculation was incorrect. |
| Bug | SPIREXLS-4227 | Fixes the issue that the program threw an error "Unknown font" when getting RTF text of cell range. |
| Bug | SPIREXLS-4231 | Fixes the issue that the program threw an error "Shapes fail to be rendered" when converting Excel to PDF. |
| Bug | SPIREXLS-4245 | Fixes the issue that the program threw System.OutOfMemoryException when converting Excel to PDF. |
| Bug | SPIREXLS-4247 | Fixes the issue that the format was inconsistent after converting HTML to Excel. |
| Bug | SPIREXLS-4252 | Fixes the issue that the slicers lost after saving files as stream. |
| Bug | SPIREXLS-4254 | Fixes the issue that there was a prompt of content error when opening the saved document after OS language area was changed. |
| Bug | SPIREXLS-4258 | Fixes the issue that the program threw System.NullReferenceException when copying sheets. |
Click the link to download Spire.XLS 12.11.3:
More information of Spire.XLS new release or hotfix:
