.NET Excel API - Developing Excel in C#, VB.NET, ASP.NET

Spire. XLS for. NET

.NET Excel API - Developing Excel in C#, VB.NET, ASP.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.

Download Spire.XLS to start a free trial:

Hotfix Version: 12.11.3

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.

Hotfix Version: 12.10

Category ID Description
Bug SPIREXLS-3674 Fixes the issue that the content format was incorrect after converting Excel to HTML.
Bug SPIREXLS-4074 Fixes the issue that it failed to get text of checkbox.
Bug SPIREXLS-4098 Fixes the issue that the legend order was incorrect after converting chart to image.
Bug SPIREXLS-4106 Fixes the issue that the format of dropdown box was incorrect after converting Excel to ODS.
Bug SPIREXLS-4111 Fixes the issue that getting the FirstColumn returned incorrect value.
Bug SPIREXLS-4123 Fixes the issue that the date format was incorrect after converting Xml to Excel.
Bug SPIREXLS-4130 Fixes the issue that it failed to clear the "inconsistent formula" error prompt.
Bug SPIREXLS-4131 Fixes the issue that the shape was lost after converting Excel to PDF.
Bug SPIREXLS-4155 Fixes the issue that the effect was incorrect after setting the border style.
Bug SPIREXLS-4157 Fixes the issue that the application threw an exception when loading an Excel in which the sheet name contains the character "#".
Bug SPIREXLS-4162 Fixes the issue that using the method (firstSheet.PageSetup.DifferentFirst = 0) to cancel different header on the first page didn't take effect.
Bug SPIREXLS-4165 Fixes the issue that it failed to autofit row height.

Hotfix Version: 12.9.2

Category ID Description
New feature SPIREXLS-4084 Supports getting the color of condition formats.
Color color = cRange.GetConditionFormatsStyle().Color;
Bug SPIREXLS-718
SPIREXLS-4066

Fixes the issue that caused incorrect content formatting after converting Excel to PDF
Bug SPIREXLS-2073 Fixes the issue that the application threw the "System.ArgumentException" when getting RichText from Excel on Linux system.
Bug SPIREXLS-2308
Fixes the issue that when setting the DPI to 125%, the content was cropped after converting chart to image.
Bug SPIREXLS-3036 Fixes the issue that caused incorrect pagination after converting Excel to PDF.
Bug SPIREXLS-3278 Fixes the issue that when setting the DPI to 125%, the content was incomplete after converting Excel to image.
Bug SPIREXLS-4038 Fixes the issue that the content was incorrect after converting chart to image.
Bug SPIREXLS-4047 Fixes the issue that failed to insert Pdf OLE object in Excel.
Bug SPIREXLS-4051 Fixes the issue that the application threw the "Shape failing to render" when converting Excel to PDF.
Bug SPIREXLS-4069 Fixes the issue that the application hung when loading Excel.
Bug SPIREXLS-4087 Fixes the issue that the number format of the cell (sheet.Range[0, 1].Text= "=SUM(18,29)" ) generated in the new version is a formula calculated value instead of text.
Bug SPIREXLS-4099 Fixes the issue that the application threw the "Element is an invalid XmlNodeType" when loading Excel.
Bug SPIREXLS-4100 Fixes the issue that the content was lost after converting Excel to image.
Bug SPIREXLS-4104 Fixes the issue that the date format was lost after inserting a date into cell.

Hotfix Version: 12.8.1

Category ID Description
New feature SPIREXLS-1483 Supports getting the CurrentRegion of cell.
sheet.Range["A1"].CurrentRegion;
Bug SPIREXLS-3898 Fixes the issue that the repeated labels of pivot table lost after converting Excel to PDF.
Bug SPIREXLS-3973 Fixes the issue that the image in Excel was replaced after saving.
Bug SPIREXLS-3974 Fixes the issue that the content in Hebrew language was not displayed correctly after converting Xltx to PDF.
Bug SPIREXLS-3981 Fixes the issue that some contents lost after converting Excel to PDF
Bug SPIREXLS-3982 Fixes the issue that the content was overlapped after converting Excel to PDF.
Bug SPIREXLS-3985
SPIREXLS-4032
Fixes the issue that after saving Excel, the Microsoft Excel prompted that the content has error when opening.
Bug SPIREXLS-4006 Fixes the issue that the arrow lost after converting Excel to HTML.
Bug SPIREXLS-4007 Fixes the issue that the formula lost after converting XLS to XLSX.
Bug SPIREXLS-4019 Fixes the issue that caused incorrect format after converting chart to image.
Bug SPIREXLS-4021 Fixes the issue that the application threw the "ArgumentOutOfRangeException" when getting the RtfText of cell.
Bug SPIREXLS-4031 Fixes the issue that the application threw the "Specified argument was out of the range of valid values" when converting Excel to PDF.
Bug SPIREXLS-4034 Fixes the issue that the application threw the "Invalid autoFilter element" when loading Excel.

Hotfix Version: 12.7.1

Category ID Description
New feature SPIREXLS-3944 Supports setting whether to keep the number format of the data when exporting to DataTable.
ExportTableOptions options = new ExportTableOptions();
options.KeepDataFormat = false;
DataTable table = sheet.ExportDataTable(1, 1, sheet.LastDataRow, sheet.LastDataColumn, options);
New feature - Supports calculating "UNICODE" formulas.
Bug SPIREXLS-3902 Fixes the issue that the column names of the pivot table were offset after converting Excel to PDF.
Bug SPIREXLS-3957 Fixes the issue that "System.FormatException: Input string was not in a correct format" was thrown when loading HTML files
Bug SPIREXLS-3966 Fixes the issue that formulas were not calculated after inserting formulas.
Bug SPIREXLS-3967 Fixes the issue that "CellRange.DisplayedText" property getting incorrect value.
Bug SPIREXLS-3971 Fixes the issue that "System.FormatException: The string is not recognized as a valid DateTime" exception was thrown when converting Excel to PDF.
Bug SPIREXLS-3972 Fixes an issue that the application threw a null pointer exception when getting the name manager for a non-contiguous range.

Hotfix Version: 12.6.1

Category ID Description
New feature SPIREXLS-3812 Provides an interface that supports setting whether to apply styles to rows and columns.
worksheet.ApplyStyle(style, applyRowStyle, applyColumnStyle)
New feature - Supports converting new chart types in Excel 2016 like waterfall, treemap and boxandwhisker to PDF and image.
Bug SPIREXLS-3888 Fixes the issue that the content of cells in custom format was not correct after converting to PDF.
Bug SPIREXLS-3890 Fixes the issue that the header whose content contained carriage, its height was incorrect after converting to PDF.
Bug SPIREXLS-3900 Fixes the issue that the association between button and VBA was lost after copying sheet to another workbook.
Bug SPIREXLS-3901 Fixes the issue that the data of pivot table was incorrect after converting Excel to PDF.
Bug SPIREXLS-3908 Fixes the issue that caused blurry effect after inserting image in Excel with new versions.
Bug SPIREXLS-3909 Fixes the issue that failed to get the range of namedrange with non-contiguous ranges.

Hotfix Version: 12.5.3

Category ID Description
New feature SPIREXLS-3852 Provides an overload of InsertArray method, which supports setting whether to automatically convert date string to datetime format when inserting arrays into Excel document.
InsertArray(object[,] objectArray, int firstRow, int firstColumn, bool needConvert); 
Bug SPIREXLS-3821 Fixes an issue that the application threw "Invalid file format" when loading XML.
Bug SPIREXLS-3838 Fixes an issue that after inserting a picture with remote address into Excel and converting to PDF, the picture was lost.
Bug SPIREXLS-3861 Fixes an issue that caused incorrect scaling ratio after inserting a picture into Excel.
Bug SPIREXLS-3889 Fixes an issue that the obtained number value of cell in new version was incorrect.
Bug SPIREXLS-3905 Fixes an issue that the application threw "Value was either too large or too small for a Double" when converting Excel to PDF.

Hotfix Version: 12.5.1

Category ID Description
New feature SPIREXLS-3806 IPrstGeomShape Implements the style of centered text.
IPrstGeomShape shape = book.Worksheets[0].PrstGeomShapes[0];
shape.TextVerticalAlignment = ExcelVerticalAlignment.MiddleCentered;
Bug SPIREXLS-3758 Optimizes the time and amount of memory used to format cell numbers.
Bug SPIREXLS-3320 Fixed an issue that the chart content was incorrect when converting Excel to PDF.
Bug SPIREXLS-3762 Fixed an issue that the grid lines' style changed from solid to dotted when converting Excel to PDF.
Bug SPIREXLS-3784 Fixed an issue that the application threw System.ArgumentException when converting Excel to HTML.
Bug SPIREXLS-3785 Fixed an issue that the formatting of content was incorrect when converting Excel to PDF.
Bug SPIREXLS-3793 Fixed an issue that the double quotes were added to text when converting Excel to CSV.
Bug SPIREXLS-3794 Fixed an issue that the data was not correct when transferring Excel data to a data table.
Bug SPIREXLS-3802 Fixed an issue that the data was incorrect when adding data using sheet.insertarrayList method.
Bug SPIREXLS-3808 Fixed an issue that the application threw InvalidOperationException when loading an xlsx file.
Bug SPIREXLS-3822 Fixed an issue that the application threw an error "object reference not set to an instance of object" when loading an xlsx file.
Bug SPIREXLS-3823 Fixed an issue that the application threw an error "different formulas in the copied rows" when calling workbook.ActiveSheet.ReparseFormula().
Bug SPIREXLS-3834 Fixed an issue that the value obtained was incorrect.

Hotfix Version: 12.4.1

Category ID Description
New feature - In the functions of converting Excel to PDF and Image, added supports converting Pareto, Sunburst, Histogram charts of Chart2016.
Bug SPIREXLS-3654 Fixes the issue that some cells value were incorrect after doing CalculateAllValue().
Bug SPIREXLS-3676 Fixes the issue that the application threw "System.NullReferenceException" when loading csv file.
Bug SPIREXLS-3680 Fixes the issue that the application threw "System.ArgumentOutOfRangeException" when loading .xlsb file.
Bug SPIREXLS-3709 Fixes the issue that the text wrap effect was lost after converting Excel to Html.
Bug SPIREXLS-3723 Fixes the issue that the PDF content converted from Excel file was garbled when opening on MAC system.
Bug SPIREXLS-3732 Fixes the issue that the output effect of replacing text with image was incorrect when system DPI sets as 125%.
Bug SPIREXLS-3737 Fixes the issue that the application threw "Invalid cell name" when loading an Excel file.
Bug SPIREXLS-3742 Fixes the issue that the output effect was incorrect after converting Excel to CSV.
Bug SPIREXLS-3754 Fixes the issue that some datas was unable to display even setting AllocatedRange.AutoFitColumns() and AllocatedRange.AutoFitRows().
Bug SPIREXLS-3757 Fixes the issue that the 'AutoFitColumn' setting didn't take effect.

Hotfix Version: 12.3.8

Category ID Description
New feature SPIREXLS-3727 Supported that setting content to fit page width when converting Excel to PDF.
workbook.ConverterSetting.SheetFitToWidth = true;
Bug SPIREXLS-1625 Fixed the incorrect pagination issue when converting Excel to PDF.
Bug SPIREXLS-3682 Fixed the incorrect pagination issue when printing Excel.
Bug SPIREXLS-3690 Fixed the issue that the program threw NullReferenceException when setting the active cell (sheet.SetActiveCell(cell)).
Bug SPIREXLS-3705 Fixed the issue that it was inconsistent between converted date format and system settings when converting Excel to PDF.
Bug SPIREXLE-3708 Fixed the issue that the program threw IndexOutOfRangeException when assigning a value to a cell.
Bug SPIREXLS-3715 Fixed the issue that there were extra blank lines in cell when converting Excel to PDF.