News & Releases
|
Spire.XLS 10.11.7 supports adding Subtotal functionality
We're pleased to announce the release of Spire.XLS 10.11.7. This version supports adding Subtotal functionality, adding lines through two points and setting bubble size of Bubble Chart. In addition, a series of issues that occurred when converting Excel to PDF/HTML/Image, loading and manipulating Excel files have been successfully fixed. See the content below for more details.
Here is a list of changes made in this release
Category | ID | Description |
New Feature | SPIREXLS-332 | Supports adding Subtotal functionality.
Workbook workbook = new Workbook(); workbook.LoadFromFile(input); Worksheet sheet = workbook.Worksheets[0]; CellRange range = sheet.Range["A5:D20"]; sheet.Subtotal(range, 0, cols.ToArray(), SubtotalTypes.Sum, true, false, true); workbook.SaveToFile(output,FileFormat.Version2013); |
New Feature | SPIREXLS-2869 | Supports setting bubble size of Bubble Chart.
chart.Series[0].Format.Options.BubbleScale = x; |
New Feature | SPIREXLS-2909 | Supports adding lines through two points.
//1)Relative location Workbook workbook = new Workbook(); Worksheet worksheet = workbook.Worksheets[0]; XlsLineShape line = worksheet.TypedLines.AddLine() as XlsLineShape; line.LeftColumn = 10; //The column index of the starting point line.LeftColumnOffset = 10; //The amount of column deviation from the starting point line.TopRow = 10; //The row index of the starting point line.TopRowOffset = 10; //The amount of row deviation from the starting point line.RightColumn = 17; //The column index of the end point line.RightColumnOffset = 10; //The amount of column deviation from the end point line.BottomRow = 18; //The row index of the end point line.BottomRowOffset = 10; //The amount of row deviation from the end point workbook.SaveToFile("result.xlsx", ExcelVersion.Version2013); workbook.Dispose(); //2)Absolute location in pixels Workbook workbook1 = new Workbook(); Worksheet worksheet1 = workbook1.Worksheets[0]; XlsLineShape line1 = worksheet1.TypedLines.AddLine() as XlsLineShape; line1.StartPoint = new Point(20, 30); line1.EndPoint = new Point(20, 50); workbook1.SaveToFile("result2.xlsx", ExcelVersion.Version2013); workbook1.Dispose(); |
Bug | SPIREXLS-2821 SPIREXLS-2863 |
Fixes the issue that the content was inconsistent when converting Excel to PDF. |
Bug | SPIREXLS-2824 | Fixes the issue that the pivottable's data was incorrectly updated when converting Excel to PDF. |
Bug | SPIREXLS-2835 | Fixes the issue that the text alignment was changed when converting Excel to PDF. |
Bug | SPIREXLS-2836 | Fixes the issue that the application threw "Remote service access error: (502) the wrong gateway" when loading Excel document. |
Bug | SPIREXLS-2841 | Fixes the issue that the application threw "System.ArgumentOutOfRangeException" when loading Excel. |
Bug | SPIREXLS-2842 | Fixes the issue that the color format was lost when converting Excel to HTML. |
Bug | SPIREXLS-2846 | Fixes the issue that the application threw "System.ArgumentException" when converting xls to xlsx. |
Bug | SPIREXLS-2850 | Fixes the issue that it reported an error when opening the document with MS Excel after adding special symbols. |
Bug | SPIREXLS-2851 | Fixes the issue that the application threw "System.FormateException" when loading xlsm files. |
Bug | SPIREXLS-2853 | Fixes the issue that there was an error when calculating XLOOKUP formula. |
Bug | SPIREXLS-2854 | Fixes the issue that a picture was missing when converting Excel to PDF. |
Bug | SPIREXLS-2861 | Fixes the issue that the legend was changed after modifying the data label. |
Bug | SPIREXLS-2871 | Fixes the issue that the value in the chart was changed after the Excel file generated by Spire.XLS was opened and saved as MS Excel. |
Bug | SPIREXLS-2902 | Fixes the issue that the result Excel document failed to open when using the value "#N/A" to create a chart. |
Bug | SPIREXLS-2908 | Fixes the issue that row height was not automatically adjusted by AutoFitRow() when Excel file has hidden content. |
Bug | SPIREXLS-2917 | Fixes the issue that the application threw "System.StackOverflowException" when converting Excel to Image. |
Bug | SPIREXLS-2910 | Fixes the issue that data was lost when converting charts to pictures. |
Click the link to download Spire.XLS 10.11.7:
More information of Spire.XLS new release or hotfix: