Spire.XLS 10.11.7

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: