Spire. XLS for. NET

Spire. XLS for. NET

Standalone. NET Excel Development Master

This is the list of changelogs of Spire.XLS New release and hotfix. You can get the detail information of each version's new features and bug solutions.

Welcome to experience Spire.XLS with downloading here:

Hotfix Version: 10.12.0

Category ID Description
New Feature SPIREXLS-2515 Supports adjusting the polyline position of the elebow arrow.
GeomertyAdjustValue ad = line.ShapeAdjustValues.AddAdjustValue(GeomertyAdjustValueFormulaType.LiteralValue);
// x is the position of the middle point. When it is less than 0, it is on the left side of the left point. When it is equal to 0, it is the same as the left point. When it is equal to 50, it is in the middle of the graph. When it is 100, it is the same as the right point.
ad.SetFormulaParameter(x);
Bug SPIREXLS-2585 Fixes the issue that the row height was incorrect after invoking the AutoFitRows method.
Bug SPIREXLS-2844 Fixes the issue that the font of the text box text was changed after converting XLS to XLSX.
Bug SPIREXLS-2903 Fixes the issue that the application hung when saving the Excel file.
Bug SPIREXLS-2907 Fixes the issue that the created line chart for pivot table was incorrect.
Bug SPIREXLS-2949 Fixes the issue that the content was incorrect after converting the chart to image.
Bug SPIREXLS-2950 Fixes the issue that the content was incorrect after converting XLS to PDF.
Bug SPIREXLS-2951 Fixes the issue that the obtained trend line equation was incorrect.
Bug SPIREXLS-2952 Fixes the issue that the method WorkBook.GetOleSize returned a wrong value.
Bug SPIREXLS-2957 Fixes the issue that the application threw the error “Object reference not set to an instance of an object” when converting XLS to PDF.
Bug SPIREXLS-2963 Fixes the issue that the calculation result was incorrect after invoking the CalculateAllValue method.
Bug SPIREXLS-2963 Fixes the issue that the content was changed after copying the sheet.
Bug SPIREXLS-2967 Fixes the issue that the application threw the error “The max length of the sheet name is 31“ when converting CSV to PDF.
Bug SPIREXLS-2980 Fixes the issue that the position of the inserted line was incorrect.
Bug SPIREXLS-2980 Fixes the issue that an error prompted when opening the result file after loading and saving the document twice.

Hotfix Version: 10.11.7

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.

Hotfix Version: 10.11.2

Category ID Description
New Feature SPIREXLS-1863 Supports adding/deleting digital signature function for Excel.
Workbook workbook = new Workbook();
workbook.LoadFromFile(inputFile);
//Add digital signature
X509Certificate2 cert = new X509Certificate2(inputFile_pfx, "e-iceblue");
DateTime certtime = new DateTime(2020, 7, 1, 7, 10, 36);
IDigitalSignatures dsc = workbook.AddDigitalSignature(cert, "e-iceblue", certtime);
//delete digital signature
workbook.RemoveAllDigitalSignatures();
workbook.SaveToFile(outputFile, FileFormat);
New Feature SPIREXLS-1571 Supports Track Changes function.
//Accept all tracked changes
Workbook workbook = new Workbook();
workbook.LoadFromFile(inputFile);
workbook.AcceptAllTrackedChanges();
workbook.SaveToFile(outputFile, FileFormat.Version2013);
//Reject all tracked changes
Workbook workbook = new Workbook();
workbook.LoadFromFile(inputFile);
workbook.RejectAllTrackedChanges();
workbook.SaveToFile(outputFile, FileFormat.Version2013);
New Feature SPIREXLS-1562
SPIREXLS-2561
Supports mathematical formulas when converting Excel to PDF.

Hotfix Version: 10.10.6

Category ID Description
New Feature SPIREXLS-2119 Supports converting Excel to PDF A/1B.
Workbook workbook = new Workbook();
workbook.LoadFromFile("test.xlsx", ExcelVersion.Version2013);
workbook.ConverterSetting.PdfConformanceLevel = Spire.Pdf.PdfConformanceLevel.Pdf_A1B;
workbook.SaveToFile(@"output.pdf", Spire.Xls.FileFormat.PDF);
New Feature SPIREXLS-2834 Supports calculating XLOOKUP formula in Office365 document.
Bug SPIREXLS-2253 Fixes the issue that the content was reduced when printing Excel by a needle printer.
Bug SPIREXLS-2763 Fixes the issue that circular reference error occurred after adding a document custom property.
Bug SPIREXLS-2778 Fixes the issue that font color and font style of chart was changed after loading and saving Excel files.
Bug SPIREXLS-2794 Fixes the issue that AutoFitRow setting did not work.
Bug SPIREXLS-2805 Fixes the issue that chart data was not updated correctly after modifying data source.
Bug SPIREXLS-2809 Fixes the issue that SUM formula update failed.
Bug SPIREXLS-2810 Fixes the issue that the shape of the line was changed when converting Excel to PDF.
Bug SPIREXLS-2813 Fixes the issue that the number format was inconsistent when converting sheet to HTML.
Bug SPIREXLS-2818 Fixes the issue that the Ole object could be not opened successfully when inserting a Word Ole object containing Chinese name.
Bug SPIREXLS-2822 Fixes the issue that the application threw an error"xl/drawings/_rels/vmlDrawingHF1.vml.rels does not exist or is empty" when converting Excel to PDF.

Hotfix Version: 10.9.16

Category ID Description
New Feature SPIREXLS-2705 Supports repeating item labels of PivotTable field.
pt.PivotFields["OnHand"].RepeatItemLabels = true;
Bug SPIREXLS-2666 Fixes the issue that the polygons became rectangles after converting xls to xlsx.
Bug SPIREXLS-2710 Fixes the issue that the value of Left property of the Rectangle that was created by Spire was 0.
Bug SPIREXLS-2734 Fixes the issue that the content was incorrect when converting the sheet that contains pivot table to PDF.
Bug SPIREXLS-2750 Fixes the issue that the added number format was incorrect in German environment when saving to Excel.
Bug SPIREXLS-2751 Fixes the issue that the height and width of rectangle changed after setting the left and top properties.
Bug SPIREXLS-2756 Fixes the issue that the value of "FIXED" formula was incorrect after converting to PDF.
Bug SPIREXLS-2762 Fixes the issue that failed to get correct end row index at pagination.
Bug SPIREXLS-2766 Fixes the issue that the content was incorrect when converting Excel to PDF.
Bug SPIREXLS-2771 Fixes the issue that the border was incorrect when converting Excel to PDF.
Bug SPIREXLS-2782 Fixes the issue that the border lost after converting xls to ods.

Hotfix Version: 10.9.0

Category ID Description
New Feature SPIREXLS-2605 Supports hiding the view of xlsx file. (xls file doesn't support it.)
workbook.IsHideWindow = true; 
Optimization SPIREXLS-2631 Optimizes the time to insert/delete rows
Bug SPIREXLS-2337 Fixes the issue that there was extra borders when converting .xlsx to pdf.
Bug SPIREXLS-2405 Fixes the issue that the PivotTable's order was wrong when converting .xlsx to pdf.
Bug SPIREXLS-2405 Fixes the issue that the content was incorrect when converting .xltx to pdf
Bug SPIREXLS-2564 Fixes the issue that the application threw System.ArgumentOutOfRangeException when removing password protection.
Bug SPIREXLS-2576 Fixes the issue that setting the percentage format of data field in the PivotTable was invalid.
Bug SPIREXLS-2586
SPIREXLS-2606
Fixes the issue that the content was incorrect when converting .xlsx to pdf.
Bug SPIREXLS-2598 Fixes the issue that the application threw "Invalid sectionId of Header Footer image" when converting .xlsx to pdf.
Bug SPIREXLS-2604 Fixes the issue that the application threw "Data format error. NameRecord" when loading file.
Bug SPIREXLS-2604 Fixes the issue that the application threw System.ApplicationException"Mso Record identification code is wrong(zero)" when loading file
Bug SPIREXLS-2659 Fixes the issue that MS Excel failed to open .xltm file and .xltx file after setting document properties.
Bug SPIREXLS-2684 Fixes the issue that the application threw "the input string's format is incorrect" when converting sheet to pdf.
Bug SPIREXLS-2687 Fixes the issue that there was extra content when converting .xls to pdf.
Bug SPIREXLS-2694 Fixes the issue that the application threw "System.FormatException" when loading file.

Hotfix Version: 10.8.3

Category ID Description
Bug SPIREXLS-2404 Fixes the issue that a content error appeared when Excel opens the file after updating PivotTable.
Bug SPIREXLS-2485 Fixes the issue that a content error appeared when Excel opens the file after loading an .xlsx file and then saving to new file.
Bug SPIREXLS-2493 Fixes the issue that the application threw an error "Error in calculating cell B2 in Worksheet Sheet1" when converting Excel to PDF.
Bug SPIREXLS-2507 Fixes the issue that the application threw "InvalidCastException" when saving to an .xls file.
Bug SPIREXLS-2509 Fixes the issue that the number format was incorrect when converting Excel to PDF in German system.
Bug SPIREXLS-2535 Fixes the issue that the formula value was incorrect when converting Excel to PDF.

Hotfix Version: 10.7.2

Category ID Description
New Feature SPIREXLS-2391 Supports the effect of retaining field name labels when converting chart generated from PivotTable data to PDF.
Bug SPIREXLS-2319 Fixes the issue that the Adobe failed to open the PDF Ole which was extracted from Excel.
Bug SPIREXLS-2323 Fixes the issue that the application threw the "Cannot find record with specified index\r Parameter name: iColumnIndex." when loading XLSM file
Bug SPIREXLS-2335 Fixes the issue that the "Print Object" option didn't make sense after converting Excel to PDF.
Bug SPIREXLS-2338
SPIREXLS-2403
Fixes the issue that the application threw the "ArgumentOutOfRangeException" when loading Excel file.
Bug SPIREXLS-2358 Fixes the issue that the application threw an error "ArgumentNullException" when loading Excel file.
Bug SPIREXLS-2359 Fixes the issue that the content format was inconsistent after converting Excel to PDF.
Bug SPIREXLS-2360
SPIREXLS-2378
Fixes the issue that the application hung when loading Excel file.
Bug SPIREXLS-2363 Fixes the issue that the chart data was incorrect after converting Excel to PDF.
Bug SPIREXLS-2369
SPIREXLS-2418
Fixes the issue that the chart lost after converting Excel to Image.
Bug SPIREXLS-2379 Fixes the issue that the text of comment created in Office365 version cannot be obtained.
Bug SPIREXLS-2380 Fixes the issue that the application threw an error"ArgumentOutOfRangeException" when setting MajorUnit of PrimaryCategoryAxis.
Bug SPIREXLS-2389 Fixes the issue that DATEDIF function cannot be calculated correctly.
Bug SPIREXLS-2394 Fixes the issue that the bar color of chart lost after converting Excel to PDF.
Bug SPIREXLS-2417 Fixes the issue that changing Preview mode to Normal mode didn't take effect.
Bug SPIREXLS-2481 Fixes the issue that the chart was incorrect after converting Excel to PDF.

Hotfix Version: 10.5.7

Category ID Description
New Feature SPIREXLS-902
SPIREXLS-1842
Adds the LoadFromHtml and LoadFromMHtml methods that support converting HTML to Excel.
workbook.LoadFromHtml(string fileName);
workbook.LoadFromHtml(Stream stream);
workbook.LoadFromMHtml(string fileName);
workbook.LoadFromMHtml(Stream stream);
Bug SPIREXLS-2045 Fixes the issue that the picture went black when converting Excel to PDF.
Bug SPIREXLS-2165 Fixes the issue that the application threw an error "ArgumentOutOfRangeException.".
Bug SPIREXLS-2243 Fixes the issue that the application threw an error "FormatException.".
Bug SPIREXLS-2202 Fixes the issue that the right margin was incorrect when converting Excel to PDF.
Bug SPIREXLS-2266 Fixes the issue that line feed of text was incorrect when converting Excel to PDF.
Bug SPIREXLS-2269 Fixes the issue that the style of pivotTable was missing when converting Excel to HTML.
Bug SPIREXLS-2270
SPIREXLS-2321
Fixes the issue that the data of chart created from the PivotTable was not updated correctly when converting Excel to PDF.
Bug SPIREXLS-2287 Fixes the issue that the grid lost when converting XML to PDF.
Bug SPIREXLS-2289 Fixes the issue that the content was narrowed down when printing Excel using customized printing size.
Bug SPIREXLS-2309 Fixes the issue that the content was incorrect when converting XLTX to PDF.
Bug SPIREXLS-2311 Fixes the issue that the application threw an error "NullReferenceException.".
Bug SPIREXLS-2324 Fixes the issue that the border style was changed when converting Excel to PDF.
Bug SPIREXLS-2325 Fixes the issue that the application threw an error "ArgumentNullException.".

Hotfix Version: 10.4.9

Category ID Description
New Feature SPIREXLS-2057 Supports showing or not showing subtotals of PivotTable.
pt.ShowSubtotals = true;
pt.ShowSubtotals = false;
Bug SPIREXLS-1810 Fixes the issue that the DisplayedText returned the incorrect date format.
Bug SPIREXLS-2006 Fixes the issue that after converting .xls to .xlsm, the generated .xlsm prompted an error when opening it.
Bug SPIREXLS-2018 Fixes the issue that it failed to set chart title and the font of chart axis.
Bug SPIREXLS-2044 Fixes the issue that the application threw an exception when loading Excel on .NET Core 2.2 platform.
Bug SPIREXLS-2051 Fixes the issue that it caused incorrect content format after converting Excel to image.
Bug SPIREXLS-2120 Fixes the issue that after converting a sheet which contains a chart (whose data is from a pivot table) to PDF, the data of chart was incorrect.
Bug SPIREXLS-2147 Fixes the issue that the markerdesigner couldn’t copy the correct style.
Bug SPIREXLS-2164 Fixes the issue that the application threw the exception “InvalidOperationException” when loading an Excel.
Bug SPIREXLS-2187 Fixes the issue that the formula value could not be calculated correctly.
Bug SPIREXLS-2201 Fixes the issue that the application threw the “NullReferenceException” when loading an Excel.
Bug SPIREXLS-2203 Fixes the issue that after merging Excel files, the generated file prompted an error when opening it.
Bug SPIREXLS-2214 Fixes the issue that after adding filter, the generated file prompted an error when opening it.
Bug SPIREXLS-2224
SPIREXLS-2232
Fixes the issue that it caused incorrect content format after converting Excel to PDF.
Bug SPIREXLS-2230 Fixes the issue that the application threw the “NullReferenceException” when inserting a new row in a copied sheet.
Bug SPIREXLS-2240 Fixes the issue that it caused incorrect date format after converting Excel to XML.
Bug SPIREXLS-2241 Fixes the issue that after creating a pivot table, the generated file prompted an error when opening it.