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.3.8

Category ID Description
New Feature SPIREXLS-1998 Supports setting chart marker's border weight.
chart.Series[0].DataFormat.MarkerBorderWeight = 2.5; //the unit is pt
New Feature SPIREXLS-2163 Supports calculating SUBTOTAL formula.
Bug SPIREXLS-2008 Fixes the issue that it failed to open output excel after setting time data validity.
Bug SPIREXLS-2015 Fixes the issue that the value of the chart pointer was lost when creating a meter chart.
Bug SPIREXLS-2020 Fixes the issue that it failed to set conditional format of the date.
Bug SPIREXLS-2023 Fixes the issue that it failed to remove hyperlinks of text.
Bug SPIREXLS-2026 Fixes the issue that it failed to set page order type.
Bug SPIREXLS-2029 Fixes the issue that it failed to unlock the protected worksheet.
Bug SPIREXLS-2031 Fixes the issue that it failed to hide/show sheet tab.
Bug SPIREXLS-2032 Fixes the issue that the incorrect version of the excel document was detected.
Bug SPIREXLS-2076 Fixes the issue that the coordinate axis value was incorrect when converting PivotChart to images.
Bug SPIREXLS-2121 Fixes the issue that the alignment of text was incorrect when converting excel to pdf.
Bug SPIREXLS-2162 Fixes the issue that the data source of chart was incorrect after using CopyFrom() method to copy sheet including a chart.
Bug SPIREXLS-2175 Fixes the issue that formula value was incorrect after calculating formula.
Bug SPIREXLS-2027 Fixes the issue that it failed to set the order of PivotTable fields.

Hotfix Version: 10.2.8

Bug Fixes:

  • Fixes the issue that the method sheet.AutoFilters.MatchNonBlanks didn't work.
  • Fixes the issue that the scale of images became smaller after adding images in chart.
  • Fixes the issue that the application threw the NullReferenceException when setting gradient for background.
  • Fixes the issue that the result was wrong after using MarkerDesigner function to copy cell style.
  • Fixes the issue that the result was incorrect after deleting the border of text box.
  • Fixes the issue that the color of comment changed from blue to yellow after saving the file.
  • Fixes the issue that the format was incorrect after converting Excel to PDF.
  • Fixes the issue that there were extra white borders after converting Excel to PDF.
  • Fixes the issue that the content was missing after converting Excel to PDF.
  • Fixes the issue that the alignment of chart title was incorrect after converting Excel to PDF.
  • Fixes the issue that category axis of chart was incorrect after converting Excel to PDF.
  • Fixes the issue that the result file hinted an error when opening after using the method SaveToHttpResponse to save to .xlsx file format file.

Hotfix Version: 10.1.8

New Features:

  • Support formatting the data of the trend line.
  • trendLine.DataLabel.NumberFormat = "#, ## 0.000";
    

Bug Fixes:

  • Fixes the issue that adding a hyperlink to a cell failed.
  • Fixes the issue that the formula was missing when adding a trend line to a chart.
  • Fixes the issue that the application threw “ArgumentOutOfRangeException” when loading an .xlsm document.
  • Fixes the issue that the content was incorrect when converting an .xlsx document to PDF.
  • Fixes the issue that the text in generated .xlsx document was wrapped.

Hotfix Version: 10.1.1

New Features:

  • Supports converting entire workbook to Html.
  • Workbook.SaveToHtml(string fileName);
    
  • Supports setting copy options when copying.
  • CopyRangeOptions copyOptions = CopyRangeOptions.OnlyCopyFormulaValue;
    CellRange.Copy(destRange, copyOptions);
    WorkSheet.Copy(sourceRange, destRange, copyOptions);
    

Bug Fixes:

  • Fixes the issue that the Bubble chart couldn't be created.
  • Fixes the issue that the application threw "KeyNotFoundException" when removing styles.
  • Fixes the issue that the content was incorrect after converting Excel to PDF.
  • Fixes the issue that the application threw "OverflowException" when loading a file.
  • Fixes the issue that the content was missing after converting Excel to PDF.
  • Fixes the issue that the leading 0 of the text was missing when using Marker Designer function.

Hotfix Version: 9.12.20

New Features:

  • Supports retaining the filtered stream data when converting Excel to CSV.
  • worksheet.SaveToStream (Stream stream, string separator, bool retainHiddenData);
    

Bug Fixes:

  • Fixes the issue of the drop-down box was missed.
  • Fixes the issue that the worksheet.IsEmpty returned incorrect results.
  • Fixes the issue that it threw the exception "the object reference was not set to the object instance" when loading an Xlsx file.
  • Fixes the issue that the worksheet.IsPasswordProtected returned incorrect results.
  • Fixes the issue that the content was incorrect when converting from Excel to PDF.
  • Fixes the issue that the speed was slow when using Filter() method to filter.
  • Fixes the issue that it threw the exception “ArgumentOutOfRangeException” when loading an Xlsm file.
  • Fixes the issue that it threw the exception “The specified parameter has exceeded the range of valid value “when copying a sheet by using the workbook.Worksheets. AddCopy (sheet) method.
  • Fixes the issue that the image was shrunk when converting Excel to PDF.
  • Fixes the issue that it threw “XmlException” when loading an Xlsx file.
  • Fixes the issue that the content was missed when converting from an Xlsm file to PDF.
  • Fixes the issue that the additional content appeared when converting an Xlsx file to PDF.

Hotfix Version: 9.11.14

New Features:

  • Supports retaining the filtered data when converting Excel to CSV.
  • workbook.SaveToFile(string fileName,FileFormat fileFormat , bool retainHiddenData);
    worksheet.SaveToFile(string fileName, string separator , bool retainHiddenData);
    

Bug Fixes:

  • Fixes the issue that setting the row height using the values that are stored in a dynamic list didn't take effect in Excel file.
  • Fixes the issue that the formula "=COUNTIF(Q2:Q1839,\"New South Wales\") " could not be calculated successfully.
  • Fixes the issue that the application threw the exception "An item with the same key has been added" when loading an Excel.
  • Fixes the issue that getting the AlternativeTextTitle of picture returned null.
  • Fixes the issue that incorrect chart format was caused after converting Excel to PDF.
  • Fixes the issue that the application threw the exception "ArgumentOutOfRangeException" when getting the ChartSheet.
  • Fixes the issue that messy content was caused after converting Excel to PDF.
  • Fixes the issue that using the method pivotTable.DataFields.Clear() to clear the data fields of pivot table didn't take effect.

Hotfix Version: 9.11.2

Bug Fixes:

  • Fixes the issue that the xlsm converted from xltm hinted an error when opening in MS Excel.
  • Fixes the issue that the application threw an exception "Value was either too large or too small for an unsigned byte" when loading an Excel file.
  • Fixes the issue that after inserting an image in Excel, the image was lost when opening the generated Excel in LibreOffice.
  • Fixes the issue that the format of table was lost after converting sheet to image.
  • Fixes the issue that caused incorrect content after converting Excel to PDF.
  • Fixes the issue that caused incorrect content after converting sheet to html.

Hotfix Version: 9.10.12

Bug Fixes:

  • Fixes the issue that the application threw an exception when converting an Excel file which contains Pivot Table to PDF or HTML.
  • Fixes the issue that the number format and the rules of conditional formatting were wrong after converting an Excel file which contains Pivot Table to PDF or HTML.
  • Fixes the issue that the application threw XmlException when loading an Excel file.
  • Fixes the issue that the links placed in the pictures were missing after converting Excel to PDF.
  • Fixes the issue that there were extra blank columns after converting .xlt to .xlsx file.
  • Fixes the issue that the application threw OverflowException when loading a .xlsm file.

Hotfix Version: 9.10.4

New Features:

  • Adds two parameters"horizontal:right_to_left" and "vertical:bottom_to_top" for Marker Designer.
  • //add in original file, the data will be inserted from the bottom to the top in vertical orientation.
    &=Country.Capital(vertical:bottom_to_top,add:styles)
    // add in original file, the data will be inserted from the right to the left in horizontal orientation.
    &=Country.Capital(horizontal:right_to_left,add:styles)
    

Bug Fixes:

  • Fixes the issue that there were empty additional columns after saving .xls to .xlsx.
  • Fixes the issue that the content was cut off after converting Excel to PDF.
  • Fixes the issue that the application threw the NullReferenceException when loading a .xlsx file.

Hotfix Version: 9.9.13

New Features:

  • Add new property "IsWrapText" under the class XlsTextBoxShape to set wrapping text.
  • XlsTextBoxShape.IsWrapText = true;
    

Bug Fixes:

  • Fixes the issue that the extracted cell data was incomplete.
  • Fixes the issue that the rule of conditional format was incorrect after copying cells.
  • Fixes the issue that the application threw NullReferenceException when loading an Excel file.
  • Fixes the issue that the property DisplayedText returned the value with wrong format.
  • Fixes the issue that some data were missing after converting Excel to HTML.