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

Hotfix Version: 9.9.5

New Features:

  • Adds a method to apply the style for a whole worksheet.
  • CellStyle style = book.Styles.add("newStyle");
    style.Color = Color.Pink;
    style.Font.Size = 15;
    book.Worksheets[0].ApplyStyle(style);
    
  • Adds a method to sort PivotTable data.
  • PivotTable pt = sheet.PivotTables[0] as PivotTable;
    (pt.RowFields[0] as PivotField).Sort(true,pt.DataFields[0]);
    //(pt.ColumnFields[0] as PivotField).Sort(false, pt.DataFields[1]);
    pt.CalculateData();
    

Bug Fixes:

  • Fixes the issue that the cell color was incorrect after converting Xlt to Xls.
  • Fixes the issue that the chart line displayed incorrectly after converting Excel to PDF and image.
  • Fixes the issue that the application threw the "NotImplementedException" when using the Time function to create PivotTable.
  • Fixes the issue that the formula value was acquired incorrectly.
  • Fixes the issue that the application threw an exception when loading an excel file.
  • Fixes the issue that the application threw the "StackOverFlowException" when executing CalculateAllValue.
  • Fixes the issue that the range of conditional expressions was wrong when copying a range.

Hotfix Version: 9.9.0

New Features:

  • Adds a netstandard2.0 folder to place the dll files which could work with Azure Function.

Hotfix Version: 9.8.11

New Features:

  • Supports to add arrow lines.
  • var arrowline = workbook.Worksheets[0].TypedLines.AddLine();
    line.Top = 50; 
    line.Left = 30; 
    line.Width = 300;
    line.Height = 500;
    line.BeginArrowHeadStyle = ShapeArrowStyleType.LineArrowDiamond;
    line.EndArrowHeadStyle = ShapeArrowStyleType.LineArrow;
    
  • Supports to add a copy of an existing shape which is a line, a checkbox, a textbox, a radio button, or a combo box.
  • //create a shape 
    var line = wb.Worksheets[0].TypedLines.AddLine();
    line.Top =50;
    line.Left=30;
    line.Width =300;
    line.Height = 500;
    //add a copy
    wb2.Worksheets[0].TypedLines.AddCopy(line);
    

Bug Fixes:

  • Fixes the issue that the page break was wrong after converting Excel to PDF.
  • Fixes the issue that the data displayed wrongly after saving Chart to image.
  • Fixes the issue that loading a file failed.
  • Fixes the issue that the application threw the exception StackOverflowException when saving Excel to PDF.
  • Fixes the issue that caused corrupt Excel when using Conditional Formatting.
  • Fixes the issue that the result file hinted an error when opening after deleting a row that contains formula.
  • Fixes the issue that setting fill horizontally for text didn't work.
  • Fixes the issue that the application threw the exception FormatException when loading a file.

Hotfix Version: 9.8.5

New Features:

  • Supports creating chart based on PivotTable.
  • worksheet.Charts.Add(ExcelChartType.BarClustered, pivotTable);
    

Bug Fixes:

  • Fixes the issue that incorrect line height was caused after setting AutoFitRow.
  • Fixes the issue that there were errors with the PivotTable after converting Excel to PDF or HTML.
  • Fixes the issue that messy content was caused after converting CSV to XLSX in .NET Core.
  • Fixes the issue that incorrect line was caused after converting Excel to PDF.
  • Fixes the issue that the conditional format was lost after copying range.
  • Fixes the issue that if the page number had blank space, there was a problem with the page number after adding.
  • Fixes the issue that incorrect Thai characters were caused after converting Excel to PDF.
  • Fixes the issue that incorrect chart data was caused after converting Excel to PDF.
  • Fixes the issue that the formula of trendline could not be returned correctly.
  • Fixes the issue that the color of range could not be cloned successfully.
  • Fixes the issue that the application failed to load a correct document if the first document had failed to be loaded.
  • Fixes the issue that Excel prompted a message to update link after removing a sheet which contains NamedRange.
  • Fixes the issue that the application caught an exception in try catch statement, but another exception was thrown after using GC to collect garbage.

Hotfix Version: 9.7

New Features:

  • Supports applying external font file to chart, such as axis labels and data labels. Note: embedding the font in Excel file is not supported, but it is supported when converting to PDF.
  • Workbook wb = new Workbook();
    wb.LoadFromFile("Book1.xlsx");
    Worksheet sheet = wb.Worksheets[0];
    Chart chart = sheet.Charts[0];
    
    wb.CustomFontFilePaths = new string[] { "C:\\gotham-book.ttf" };
    System.Collections.Hashtable result=wb.GetCustomFontParsedResult();
    chart.PrimaryValueAxis.Font.FontName= result["C:\\gotham-book.ttf"] as string;
    chart.SecondaryCategoryAxis.Font.FontName = result["C:\\gotham-book.ttf"] as string;
    
    Spire.Xls.Charts.ChartSerie cs1 = chart.Series[0];
    cs1.DataPoints.DefaultDataPoint.DataLabels.FontName = result["C:\\gotham-book.ttf"] as string;
    
    wb.SaveToFile("result.pdf", FileFormat.PDF);
    
  • Supports specifying EmfType in ToEMFStream method.
  • sheet.ToEMFStream(stream, sheet.FirstRow, sheet.FirstColumn, sheet.LastRow, sheet.LastColumn, EmfType.EmfOnly);
    

Bug Fixes:

  • Fixes the issue that incorrect content format was caused after converting Excel to HTML.
  • Fixes the issue that the application threw an exception when converting an Excel which contains formulas to PDF.
  • Fixes the issue that incorrect content was caused after copying a sheet which contains named ranges.
  • Fixes the issue that the application threw an exception "offset and length beyond the array bounds..." when loading Excel.
  • Fixed the issue that after creating a chart using an array with an empty first value, the generated Excel prompted an error when opening.
  • Fixes the issue that getting the formula of trendline returned incorrect data.
  • Fixes the issue that incorrect color was caused after converting .XLT to .XLS.
  • Fixes the issue that an exception "The ' [ '- unterminated [] set is being analyzed" was caused when converting Excel to PDF.

Hotfix Version: 9.6.12

Bug Fixes:

  • Fixes the issue that the same axis categories were expanded when converting chart to image.
  • Fixes the issue that setting the center alignment of checkbox text failed.
  • Fixes the issue that the thousand separator format of the number value obtained in the Spanish language system was incorrect.