Spire.XLS for .NET is a professional Excel .NET library that can be used to any type of .NET( C#, VB.NET, ASP.NET, .NET Core) application, both ASP.NET web sites and Windows Forms application.

Mon Jan 20, 2014 8:19 am

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:
http://www.e-iceblue.com/Download/downl ... t-now.html

Spire.XLS Pack Version:9.11.2(2019-11-08)
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.

Spire.XLS Pack Version:9.10.12(2019-10-25)
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.

Spire.XLS Pack Version:9.10.4(2019-10-11)
New Features:
Adds two parameters"horizontal:right_to_left" and "vertical:bottom_to_top" for Marker Designer.
Code: Select all
//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.

Spire.XLS Pack Version:9.9.13(2019-09-26)
New Features:
Adds new property "IsWrapText" under the class XlsTextBoxShape to set wrapping text.
Code: Select all
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.

Spire.XLS Pack Version:9.9.5(2019-09-12)
New Features:
Adds a method to apply the style for a whole worksheet.
Code: Select all
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.
Code: Select all
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.

Spire.XLS Pack Version:9.9.0(2019-09-02)
New Features:
Adds a netstandard2.0 folder to place the dll files which could work with Azure Function.

Spire.XLS Pack Version:9.8.11(2019-08-23)
New Features:
Supports to add arrow lines.
Code: Select all
    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.
Code: Select all
 //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.

Spire.XLS Pack Version:9.8.5(2019-08-15)
New Features:
Supports creating chart based on PivotTable.
Code: Select all
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.

Spire.XLS Pack Version:9.7(2019-07-11)
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.
Code: Select all
 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.
Code: Select all
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.

Spire.XLS Pack(Hotfix) Version:9.6.12(2019-06-28)
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.

Spire.XLS Pack(Hotfix) Version:9.6.7(2019-06-19)
Bug Fixes:
Fixes the issue that caused incorrect format when converting Excel to image.
Fixes the issue that the application threw an exception "the length can't be less than 0" when getting a specific range.
Fixes the issue that caused incorrect format when converting chart to image.
Fixes the issue that the application threw the exception "the specified parameter is out of range of valid values" when loading a CSV file.
Fixes the issue that caused incorrect columns of Pivot Table after adding data.
Fixes the issue that the formula of trendline could not be obtained correctly.

Spire.XLS Pack(Hotfix) Version:9.6.1(2019-06-06)
Bug Fixes:
Fixes the issue that caused incorrect format when converting Excel to PDF.
Fixes the issue that the transparency of image was lost after saving to Version97to2003 file format.
Fixes the issue that some characters became "□" when converting Excel to PDF.
Fixes the issue that the application threw an exception when using the code CalculateAllValue.
Fixes the issue that color setting for chart markers didn't work.
Fixes the issue that the application threw the exception "ArgumentException" when saving Excel to image.
Fixes the issue that the application threw an exception when loading a file.

Spire.XLS Pack(Hotfix) Version:9.5.11(2019-05-23)
New Features:
Supports converting Text format to Number format.
Code: Select all
 range.ConvertToNumber();

Bug Fixes:
Fixes the issue that the content format was incorrect in PDF which was converted from Excel with the A3 paper size setting.
Fixes the issue that the application couldn't get the correct NumberText after setting NumberFormat.
Fixes the issue that the text alignment was incorrect after converting Excel to PDF.

Spire.XLS Pack(Hotfix) Version:9.5.6(2019-05-16)
Bug Fixes:
Fixes the issue that the application threw an "Object reference not set to an instance of an object" error when converting excel to pdf/images in a Docker container hosted on Linux.

Spire.XLS Pack(Hotfix) Version:9.5.4(2019-05-13)
New Features:
Improves the speed of loading a file which contains EMF.
Bug Fixes:
Fixes the issue that the application threw an exception when saving a sheet which contains 3d pie chart to SVG.
Fixes the issue that MS excel hinted a problem when opening the result file after adding a pivot table.
Fixes the issue that the progress threw an exception "ArgumentOutOfException" when loading a file.
Fixes the issue that the progress threw an exception "ArgumentOutOfException" when saving sheet to image.
Fixes the issue that the content exceeded the cell after converting Excel to PDF.
Fixes the issue that the application threw an exception "OverflowException" when converting chart to image.
Fixes the issue that a cell was filled wrong color for a new file.
Fixes the issue that the content of some rows were lost after converting sheet to image.

Spire.XLS Pack(Hotfix) Version:9.5.0(2019-05-01)
Bug Fixes:
Fixes the issue that getting the page number of worksheet returned incorrect data.
Fixes the issue that after adding background image and then saving to Version97to2003 format, the generated .xls had problems on content.
Fixes the issue that the application threw "OverflowException" when loading an Excel.
Fixes the issue that the superscript was incorrect after saving an Excel to image.
Fixes the issue that the application threw an error "XXX is not valid named range" when executing InsertArray method.
Fixes the issue that the application threw an error "Input string was not in a correct format" when loading an Excel.
Fixes the issue that the conditional format was lost after converting worksheet to HTML.

Spire.XLS Pack(Hotfix) Version:9.4.6(2019-04-15)
New Features:
Adds CustomFontFilePaths property to set the font files that are not installed on the computer.
Code: Select all
workbook.CustomFontFilePaths = new string[] { inputFontfile };


Optimizations:

Optimizes the time of creating a chart when setting a larger chart data range.
Optimizes the speed of copying worksheets.
Bug Fixes:
Fixes the issue that the content was lost when converting an .xlsx document to images.
Fixes the issue that the application threw an error "don't set the object reference to the object instance" when copying a sheet containing a chart.
Fixes the issue that the application threw an error "cannot find the required relation" when loading an .xlsx document.
Fixes the issue that the content was lost when converting an .xlsx document generated by NPOI to PDF.
Fixes the issue that the application threw an error "don't set the object reference to the object instance" when calculating the formulas using CalculateAllValue method.

Spire.XLS Pack(Hotfix) Version:9.4.0(2019-04-02)
Bug Fixes:
Fixes the issue that incorrect content was caused after converting Excel to PDF.
Fixes the issue that setting DocumentProperties of version97-2003 format but didn't take effect.
Fixes the issue that the exception (“XmlException was unhandled”) was caused when loading an Excel.
Fixes the issue that the DisplayedText of cell in Excel could not be obtained correctly.
Fixes the issue that after saving as a new Excel file, an error dialog popped up when opening the saved Excel.
Fixes the issue that the count of NameRange could not be obtained correctly.

Spire.XLS Pack(Hotfix) Version:9.3.10(2019-03-21)
New Features:
Supports setting the inner margins of the textbox
Code: Select all
TextBoxShapeBase texbox = workbook.Worksheets[0].TextBoxes[0] as TextBoxShapeBase;
texbox.InnerLeftMargin = 1;
texbox.InnerRightMargin = 3;
texbox.InnerTopMargin = 1;
texbox.InnerBottomMargin = 3;

Bug Fixes:
Fixes the issue that the rotation of the shape didn't work when saving to ExcelVersion.Version97to2003.
Fixes the issue that an error dialog popped up when opening a document after copying the formulas and saving it to an .xlsx file.
Fixes the issue that image transparency was lost after saving as an .xls document.

Spire.XLS Pack(Hotfix) Version:9.3.4(2019-03-13)
New Features:
Supports to set the page size as A6 when converting Excel to PDF.
Code: Select all
sheet.PageSetup.PaperSize = PaperSizeType.PaperA6;

Supports to keep the original cell format after replacing a part of text.
Code: Select all
XlsRange.TextPartReplace(string old, string new);

Bug Fixes:
Fixes the issue that the content was incorrect after converting Excel to HTML.
Fixes the issue that the data was split incorrectly after converting Excel to CSV.
Fixes the issue that the process threw System.ApplicationException when loading a file.
Fixes the issue that replacing image failed.
Fixes the issue that MS Excel 2007 hint an error when opening the result after adding Pivot table.
Fixes the issue that the process threw an ArgumentNullException when loading a file.
Fixes the issue that opening the result file hinted an error after adding header and footer.
Fixes the issue that some part of hyperlink string was missing after converting Excel to HTML.
Fixes the issue that the text was not wrapped properly when converting Excel to PDF.

Spire.XLS Pack(Hotfix) Version:9.2.11(2019-02-27)
New Features:
Some interfaces are adjusted:
Code: Select all
Spire.Xls.Core.Converter.Exporting.EMF.ConverterSetting is adjusted to Spire.Xls.ConverterSetting
Spire.Xls.Core.Converter.Exporting.EMF.PrintingPageType is adjusted to Spire.Xls.PrintingPageType
Spire.Xls.Core.Converter.Exporting.EMF.PageColRow is adjusted to Spire.Xls.PageColRow
Spire.CompoundFile.XLS.XlsDocumentProperty is adjusted to Spire.Xls.XlsDocumentProperty
Spire.CompoundFile.XLS.PropertyType is adjusted to Spire.Xls.PropertyType
Spire.CompoundFile.XLS.Net.IPropertyData is adjusted to Spire.Xls.IPropertyData

Bug Fixes:
Fixes the issue that an error popped up when opening the converted PDF from an .xlsx file in Adobe Reader.
Fixes the issue that the font size was changed when converting an .xlsx file to PDF.
Fixes the issue that the application threw an exception when loading an .xlsx stream on .net core platform.

Spire.XLS Pack(Hotfix) Version:9.2.8(2019-02-21)
Bug Fixes:
Fixes the issue that the application threw an exception when setting the font for a textbox.
Fixes the issue that the result was incorrect for "MatchEntireCellContent" mode when finding the same content.
Fixes the issue that the application threw an exception when unprotecting an Excel document.
Fixes the issue that the number format was incorrect when converting Excel to CSV.
Fixes the issue that the application threw an exception when loading an Excel document.
Fixes the issue that the application threw an exception when loading an XML file.
Fixes the issue that an error was prompted when opening the PDF converted from Excel in Adobe.
Fixes the issue that an error was prompted when opening the generated .xlsm file converted from .xlsb in Excel.
Fixes the issue that the worksheet tab color was changed after loading and resaving an Excel file.
Fixes the issue that the application threw an exception when loading an Excel file or saving the worksheet to image.

Spire.XLS Pack(Hotfix) Version:9.1.22(2019-02-01)
New Features:
Supports .NET Core 2.0.

Spire.XLS Pack(Hotfix) Version:9.1.14(2019-01-24)
New Features:
Adds a new attribute to add cell link for CheckBox.
ICheckBox.LinkedCell
Bug Fixes:
Fixes the issue that caused an exception when loading Excel.
Fixes the issue that an exception occurred after merging multiple Excel file and while converting the merged file to PDF.
Fixes the issue that an exception occurred after merging the file which contains image Group with another Excel file and while converting the merged file to PDF.
Fixed the issue that caused extra blank columns after saving .xlsb to .xls.

Spire.XLS Pack Version:9.1(2019-01-10)
Bug Fixes:
Fixes the issue that font attribute of chart legend didn't work.
Fixes the issue that the application was hanging when converting an Excel file to HTML.
Fixes the issue that the application threw an exception "The key is not found in the dictionary." when converting an Excel file to PDF.
Fixes the issue that the application threw an exception "The value cannot be null." when loading an excel file.

Spire.XLS Pack(Hotfix) Version:8.12.11(2018-12-28)
Bug Fixes:
Fixes the issue that the images with transparency were not converted correctly after converting Excel to PDF.
Fixes the issue that caused XmlException when loading an Excel file.
Fixes the issue that the application threw an exception "Object reference not set to an instance of an object" when using the method CalculateAllValue().
Fixes the issue that caused ArgumentException when loading an Excel file.
Fixes the issue that caused ArgumentOutOfRangeException when loading an Excel file.
Fixes the issue that the application threw the exception "Error in calculating cell F15 in Worksheet" when saving Excel to PDF.
Fixes the issue that the row height was not auto-fit after setting WrapText for ranges.
Fixes the issue that the content was missing after saving Excel to PDF.

Spire.XLS Pack(Hotfix) Version:8.12.3(2018-12-11)
Bug Fixes:
Fixes the issue that caused "File does not contain workbook stream" exception when loading Excel from stream.
Fixes the issue that the SaveToFile method threw "NullReferenceException" after deleting sheet.
Fixes the issue that setting Rotation property of picture didn't take effect after saving as Excel 97-2003 version.
Fixed the issue that failed to delete Legend of chart.
Fixed the issue that the String format displayed as Numbered format after applying marker designer.

Spire.XLS Pack(Hotfix) Version:8.11.6(2018-11-21)
Bug Fixes:
Fixes the issue that the application threw an exception ArgumentOutOfRangeException when using the code row.AutoFitRows().
Fixes the issue that the application threw an exception when loading an Excel file.

Spire.XLS Pack(Hotfix) Version:8.11.2(2018-11-12)
New Features:
Add new properties to set the size of the image in header and footer.
Code: Select all
sheet.PageSetup.CenterFooterPictureWidth = 100;
sheet.PageSetup.LeftHeaderPictureHeight = 100;

Supports the IFNA function.
Supports to save Excel to PostScript file.
Code: Select all
workbook.SaveToFile(output, FileFormat.POSTSCRIPT);

Bug Fixes:
Fixes the issue that failing to get the correct border color of a cell.
Fixes the issue that extra blank spaces were added after converting Excel to PDF.
Fixes the issue that some extra pages were added after converting Excel to PDF when the region and language setting is Australia(English).
Fixes the issue that the application hang when loading a Excel file.
Fixes the issue that an error occured in GDI+ when adding an image into EXCEL.
Fixes the issue that the applicaition threw an exception when searching content in a range where there's no such text.

Spire.XLS Pack(Hotfix) Version:8.10.7(2018-10-30)
New Features:
Add new properties to print comment visible/invisible:
Code: Select all
 
sheet.PageSetup.PrintComments = PrintCommentType.InPlace;
sheet.PageSetup.PrintComments = PrintCommentType.NoComments;

Add new properties to set the position of ChartTitleArea:
Code: Select all
chart.ChartTitleArea.X = xx;
chart.ChartTitleArea.Y = xx;

Bug Fixes:
Fixes the issue that extracting the OLE in Excel but got empty oleData.
Fixes the issue that changing the font of chart title had impacts on other fonts of text.
Fixes the issue that caused an exception when loading an Excel file.
Fixes the issue that adding the fill color failed.
Fixes the issue that copying range didn't succeed.
Fixes the issue that caused an exception when converting Excel to PDF.
Fixes the issue that caused an exception when saving Excel to stream.
Fixes the issue that caused incorrect page number after converting Excel to PDF.

Spire.XLS Pack(Hotfix) Version:8.10.2(2018-10-12)
New Features:
Adds a new method to get ChartSheet via sheet name.
Code: Select all
ChartSheet cs = workbook.GetChartSheetByName("name");

Adds a new method to save ChartSheet to SVG stream.
Code: Select all
chartSheet.ToSVGStream(fs);

Bug Fixes:
Fixes the issue that the returned value was incorrect when obtaining the color of border.
Fixes the issue that caused an ArgumentException when loading an Excel file.
Fixes the issue that caused an exception when loading an Excel file from a folder that was set with the checked option "Read-only recommended".
Fixes the issue that an error occurred when opening the result file after copying a worksheet.
Fixes the issue that an exception occurred in this line of code "Worksheets.AddCopy" after setting thread culture.
Fixes the issue that the progress hung when converting worksheet to image.
Improves the speed of loading a big Excel file.

Spire.XLS Pack(Hotfix) Version:8.9.8(2018-09-30)
Bug Fixes:
Adjusted the value of range.Style.Rotation.
Fixes the issue that the character changed after saving Excel in the Czech region.
Fixes the issue that the application threw an exception when reloading the Excel which is saved in the last time.
Fixes the issue that the application took too much time when converting sheet to image.
Fixes the issue that the application hang when executing InsertRow method.
Fixes the issue that after creating pivot tables, the generated file popped up an error message when opening.

Spire.XLS Pack(Hotfix) Version:8.9.3(2018-09-17)
New Features:
Overloads the method "SaveChartAsImage" for supporting saving the charts from chartsheet as images.
Code: Select all
workbook.SaveChartAsImage(ChartSheet cs);

Bug Fixes:
Fixes the issue that the application threw an exception when getting the cell range of the OLE object.
Fixes the issue that the table format became incorrect after converting Excel to PDF.
Fixes the issue that the application threw an exception when loading an Excel.
Fixes the issue that the application threw an exception when loading the same Excel file twice.
Fixes the issue that the formula did not get calculated after printing or converting to PDF.
Fixes the issue that the formula became incorrect after converting XML to Excel.

Spire.XLS Pack(Hotfix) Version:8.8.5(2018-08-29)
Bug Fixes:
Fixes the issue that the text displayed incorrectly when converting Excel to PDF.
Fixes the issue that setting the NoFill property to series did not work.
Fixes the issue that the FormatException exception was thrown when loading a document.
Fixes the issue that threw exception when executing structured references.
Fixes the issue that the chart in the generated Excel got lost and the generated Excel prompted a message to repair the document after saving.
Fixes the issue that threw exception when executing sheet.AllocatedRange.FindAllString method.
Fixes the issue that both the content of a specific cell and language of the date were incorrect when converting Excel to PDF.
Fixes the issue that caused ArgumentOutOfRangeException when loading a file.

Spire.XLS Pack(Hotfix) Version:8.8.1(2018-08-08)
Bug Fixes:
Fixes the issue that the text content got duplicated when converting Excel to XPS.

Spire.XLS Pack(Hotfix) Version:8.8.0(2018-08-01)
New features:
Adds a new method ClearFilter to clear a filter which is not in a pivot table.
Code: Select all
   AutoFiltersCollection filter = workbook.Worksheets["Sheet2"].AutoFilters;
    filter.ClearFilter(int);
    //filter.ClearFilter(columnName);
    //refresh data
    filter.Filter();

Bug Fixes:
Fixes the issue that the option "Autofit column widths on update" for pivot table changed to be checked after saving.
Fixes the issue that the text color couldn’t be set for an existing file.
Fixes the issue that the chart type "Line" changed to "Line Marker" when creating a chart in .xls file.
Fixes the issue that caused an ArgumentOutOfRangeException when loading a file.
Fixes the issue that text and lines got overlapped when converting Excel to XPS.
Fixes the issue that caused a NullReferenceException when saving Excel to PDF.
Fixes the issue that the format was wrong when converting Excel to PDF.
Fixes the issue that caused an ArgumentOutOfRangeException when loading a file.

Spire.XLS Pack(Hotfix) Version:8.7.2(2018-07-12)
Bug Fixes:
Fixes the issue that the color settings for columns with negative values in Column Chart did not work.
Fixes the issue that the named ranges got lost after copying a worksheet.
Fixes the issue that the application threw "ArgumentException" exception when loading an .xlsx file.

Spire.XLS Pack(Hotfix) Version:8.6.6(2018-06-27)
New features:
Add a new property "XlsPivotTable.Options.IsAutoFormat" for setting whether the autoformat is applied for pivot table or not. Default value is true.
Code: Select all
 bool IsAutoFormat { get; set; }

Add following three new methods to delete filters in pivot table.
Code: Select all
 
    public void ClearColumnFieldFilter(string fieldName);
    public void ClearFilter(string fieldName);
    public void ClearRowFieldFilter(string fieldName);

Add a new property "IChart.ChartArea.Shadow.SoftEdge" to support the setting for chart soft edge.
Code: Select all
  public int SoftEdge { get; set; }

Bug Fixes:
Fixes the issue that the content of R1C1-Formula would change when inserting a row.
Fixes the issue that the "CellRange.FormulaValue" returned the wrong value.
Fixes the issue that the "ValueFromCell" setting would result in an invalid color effect for the negative column.
Fixes the issue that the original images in Excel1 had all been replaced when copying one of the sheets in Excel2 to Excel1.
Fixes the issue that some structural references were not supported.
Fixes the issue that the property "IsAutoMajor" must be set to false when setting the label unit.
Fixes the issue that the "pageInfoList[0].Count" returned wrong value for the page count.
Fixes the issue that the application thraw an "ArgumentOutOfRangeException" when loading an EXCEL document.


Spire.XLS Pack(Hotfix) Version:8.6.1(2018-06-08)
Bug fixes:
Fixes the issue that caused ArgumentException when loading the file.
Fixes the issue that caused NullReferenceException when using the code trendLine.DisplayEquation.
Fixes the issue that setting number format didn't work in Spain's environment.
Fixes the issue that the number format was wrong after converting Excel to PDF in Spain's environment.
Fixes the issue that the content was incorrect after converting Excel to PDF.
Fixes the issue that setting default value for the filter of pivot table didn't work.
Fixes the issue that the process hung when converting Excel to HTML.
Fixes the issue that caused NullReferenceException when loading a file.

Spire.XLS Pack(Hotfix) Version:8.4.13(2018-04-25)
Bug fixes:
Fixes the issue that the cell content of the result file was incorrect when printing Excel with the DPI of 125.
Fixes the issue that the text format was incorrect when converting Excel to PDF with the DPI of 125.
Fixes the issue that the result images were incorrect when converting Excel Sheets to Images.
Fixes the issue that the calculation is incorrect after calculating formula value("=ROUND(2.135,2)").

Spire.XLS Pack(Hotfix) Version:8.4.6(2018-04-18)
New features:
Add new feature to specify the Image Location type (GlobalAbsolute or Relative to Table) when converting sheet to html.
Code: Select all
       HTMLOptions opt = new HTMLOptions();
       opt.ImageLocationType = ImageLocationTypes.TableRelative;
       //opt.ImageLocationType = ImageLocationTypes.GlobalAbsolute;
       sheet.SaveToHtml(string fileName, HTMLOptions saveOption);

Add a series of new interfaces to create conditional formats.
Code: Select all
        XlsConditionalFormats xcfs = sheet.ConditionalFormats.Add();
       xcfs.AddAverageCondition(AverageType averageType)   
       xcfs.AddBeginsWithCondition(string text); 
       xcfs.AddCellValueCondition(ComparisonOperatorType operatorType, double value1, double value2);   
       xcfs.AddCellValueCondition(ComparisonOperatorType operatorType, string value1, string value2);   
       xcfs.AddContainsBlanksCondition();   
       xcfs.AddContainsErrorsCondition();   
       xcfs.AddNotContainsTextCondition(string text);   
       xcfs.AddTimePeriodCondition(TimePeriodType timePeriodType);   
       xcfs.AddTopBottomCondition(TopBottomType topBottomType, int rank);
       xcfs.AddUniqueValuesCondition();

Bug solutions:
Fixes the issue that the "Percent" attribute did not make sense in "chart.Series[0].DataPoints[0].DataFormat.Percent=20; ".
Fixes the issue that caused incorrect style and content when converting Excel to Pdf.
Fixes the issue that the bottom graphic was incorrect when converting Excel to Pdf.
Fixes the issue that the cell filling lost when converting Excel to Pdf.
Fixes the issue that caused incorrect content when converting Excel to Pdf.
Fixes the issue that caused incorrect text color when converting Excel to HTML.
Fixes the issue that caused incomplete content on local and blank content on Azure after using sheet.ToImage() to save sheet to image.
Fixes the issue that caused a gradual increase in the size of the generated file when circularly changing the value of a cell.
Fixes the issue that caused incorrect content after saving.
Fixes the issue that the cell style lost after merging data.
Fixes the issue that caused InvaildCastException when changing text color.
Fixes the issue that the font of next text font had changed after modifying subscripts.

Spire.XLS Pack(Hotfix) Version:8.3.5(2018-03-15)
Bug Fixes:
Fixes the issue that the CellRange.HasConditionFormats property returned wrong value.
Fixes the issue that the results calculated by CalculateAllValue method were not accurate.
Fixes the issue that caused the process hanging when converting Excel to PDF.
Fixes the issue that an additional page was added when converting Excel to PDF.
Fixes the issue that an exception was thrown when converting worksheet to Image.
Fixes the issue that some data was lost when converting worksheet to Image.
Fixes the issue that some images were lost when converting Excel to PDF.

Spire.XLS Pack(Hotfix) Version:8.3.0(2018-03-05)
Bug Fixes:
Fixes the issue that the CellRange.HasConditionFormats property always return false.
Fixes the issue that the table border was lost when converting Excel to SVG.
Fixes the issue that caused FormatException when loading file.
Fixes the issue that the result was incorrect when adding shadow for a chart.
Fixes the issue that caused exception when setting the Gradient with "Radial" type in Chart Plot Area.
Fixes the issue that the data label of chart was missing when converting Excel to PDF.
Fixes the issue that the "Garamond" font cannot be embedded when converting Excel to PDF.

Spire.XLS Pack Hotfix Version:7.12.150(2018-02-02)
Bug Fixes:
Fixes the issue that the space between words was lost when converting to PDF.
Fixes the issue that the invisible comment can't be set as visible.
Fixes the issue that the horizontal axis position of bar chart was rendered incorrectly when converting to PDF.
Fixes the issue that caused spr2464 exception when converting sheet to Image.
Fixes the issue that caused NullReferenceException when saving to XML.
Fixes the issue that the formula was copied incorrectly when inserting new row.
Fixes the issue that the IgnoreErrorOptions property didn't work.
Fixes the issue that the value of ComboBox control was set incorrectly.
Fixes the issue that caused the exception that Value was either too large or too small for an Int32 when loading.
Fixes the issue that the digit in Chinese character was incorrect when saving to PDF.

Spire.XLS Pack Hotfix Version:7.12.144(2018-01-12)
Bug Fixes:
Fixes the issue that chart datalable was duplicated when converting Chart to Image.
Fixes the issue that CalculateAllValue method threw an exception.
Fixes the issue that the alignment of chart subtitle was incorrect when converting worksheet to PDF.
Fixes the issue that the font of chart subtitle was incorrect when converting worksheet to PDF.
Fixes the issue that the leader lines of chart was added when converting to PDF.
Fixes the issue that the conditional format was incorrect.
Fixes the issue that formula returned wrong value.
Fixes the issue that the returned value of the sheet counts was incorrect.
Fixes the issue that the retuned value of alternative text of shape was incorrect.
Fixes the issue that the application was hanging when loading a file.


Spire.XLS Pack Hotfix Version:7.12.140(2017-12-28)
Bug solutions:
Fixes the issue that there is extra border for chart title when converting Excel to PDF.
Fixes the issue that the alignment of chart title was changed after converting Excel worksheet to PDF.
Fixes the issue that additional leader line of data label for chart occurs after converting Excel worksheet to PDF.
Fixes the issue that caused InvalidCastException when loading the Excel.
Fixes the issue that the process was freezing when using LoadFromStream to load file.
Fixes the issue that caused exception when calling CalculateAllValue method.
Fixes the issue that the result file has extra data.

Spire.XLS Pack Hotfix Version:7.12.130(2017-12-14)
Bug solutions:
Fixes the issue that the shadow property of shape didn't work.
Fixes the issue that the border of the rectangle was lost when converting Excel to PDF.
Fixes the issue that the position of shape was incorrect when converting Excel to PDF.
Fixes the issue that the sheet protecting password was removed when manipulating locked cell.
Fixes the issue that caused the exception that it is not supported for this Vertical Axis type when loading the Excel file.
Fixes the issue that caused the exception when saving empty worksheet.

Spire.XLS Pack Hotfix Version:7.12.125
New features:
Adds Workbook.GetOleSize method to get the displayed size of an embedded Excel OLE object.
Bug Fixes:
Fixes the issue that caused ArgumentOutOfRangeException error when loading workbook XML document.
Fixes the issue that the address of conditional formatting was gotten incorrectly.
Fixes the issue that the double quote was parsed incorrectly when converting CSV to Excel.
Fixes the issue that caused the docfile has been corrupted error when loading .xls document.
Fixes the issue that caused application to hang when loading document.
Fixes the issue that caused the error that extended format record fontindex field has wrong value when loading document.
Fixes the issue that caused application to hang when saving chart as image.
Fixes the issue that ConditionalFormatWrapper.DataBar.MinPoint didn't work.
Fixes the issue that caused HideItemDetail method to throw exception when there is a blank item.
Fixes the issue that caused NullReferenceException when launching a GarbageCollector.


Spire.XLS Pack Hotfix Version:7.12.109
New features:
Supports to manipulate more conditional formatting in XlsConditionalFormat and ConditionalFormatWrapper.
Adds ConditionalFormatWrapper.StopIfTrue property to stop processing the current rule when the condition meets.
Bug Fixes:
Fixes the issue that caused the "object reference not set to an instance of an object" error when saving the Excel using custom OTF font to pdf.
Fixes the issue that caused incorrect number format when the thread culture is not invariant culture.
Fixes the issue that caused the Accounting number format pushed the $ symbol outside the cell border when converting to PDF.
Fixes the issue that change the PrimaryCategoryAxis.CategoryType property didn't work when loading an existing chart.
Fixes the issue that caused the ConditionalFormatWrapper.Priority property didn't work.
Fixes the issue that caused the AutoFitColumn method didn't work when the cell contains date time.


Spire.XLS Pack Hotfix Version:7.12.100
New Feature:
Adds TimePeriodType enum to specify the time period
Adds ConditionalFormatWrapper/XlsConditionalFormat.SetTimePeriod(TimePeriodType timePeriod) to format only cells with dates occurring in a specific time period.
Bug solutions:
Fixes the issue where accounting Number Format didn't work correctly while saving Excel to PDF.
Fixes the issue that caused the invalid column index exception while saving Excel to PDF.
Resolves the issue where the comma that is not an actual field separator was considered as delimiter while saving Excel to CSV.
Fixes the issue that caused the back color of ConditionalsFormat incorrect.
Fixes the issue that caused the OverFlowException while loading an Excel file.


Spire.XLS Pack Hotfix Version:7.12.90
New Features:
Supports to add shapes to worksheet.
Code: Select all
sheet.PrstGeomShapes.AddPrstGeomShape(int row,int column,int width,int height,PrstGeomShapeType shapeType);

Supports to select the cell range to be visible when displayed as an OLE object.
Code: Select all
Workbook.SetOleSize(firstRow,firstColumn,lastRow,lastColumn);

Bug Fixes:
Fixes the issue that the result document changed to Protected View after saving .xlsx to .xls.
Fixes the issue that caused ArgumentOutOfRangeException when converting Excel to HTML.
Fixes the issue that caused the style of the chart missing when using SaveChartAsImage method.
Fixes the issue that caused the font changed when converting Excel to PDF.
Fixes the issue that caused the data format incorrect when converting Excel to pdf.
Fixes the issue that caused the formula result wrong in French environment.
Fixes the issue that caused result incorrect when getting the validation formula value.
Resolves the issue that caused Euro (€) sign lost when using DisplayedText property.
Fixes the issue that the value in the original cell range changed along with value which was set by range.Text property in the copied range.
Fixes the issue that caused IndexOutOfRangeException when loading file.
Fixes the issue that caused the process hanging when converting Excel to PDF.
Fixes the issue that caused the value type changed from text to number when importing data from datatable to Excel.
Fixes the issue that the method AutoFitColumns didn't work.


Spire.XLS Pack Hotfix Version:7.12.76
New Feature:
Spire.XLS supports to save file to Excel2016 format.
Bug solutions:
Fixes the issue that caused XmlException when using CalculateAllValue() method.
Fixes the issue that caused wrong result of formulas while the computer sets the region as France and language as French.
Fixes the issue that caused warning message "We found a problem with some content in ... Do you want us to try recover as much as we can?" when opening the saved file.
Fixes the issue that caused wrong size of the image when scaling the inserted image.
Fixes the issue that caused FormatException when loading an .xlsm file.


Spire.XLS Pack Hotfix Version:7.12.69
Bug solutions:
Fixes the issue that caused stretched image when converting Excel to PDF while the computer sets the region as Spain and language as Chile.
Fixes the issue that caused chart missing when converting Excel to PDF.
Fixes the issue that caused black background when saving Excel worksheet to pdf.
Fixes the issue that the setting "comment.AutoSize = true" doesn't work.
Fixes the issue that caused ArgumentException when loading .xlsm file.
Fixes the issue that caused slicer missing when saving .xlsm file.


Spire.XLS Pack Hotfix Version:7.12.55
Bug solutions:
Fixes the issue that caused wrong pagination when converting Excel to PDF.
Fixes the issue that caused graph missing when converting Excel to PDF.
Fixes the issue that the images are rotated when converting Excel to PDF.
Fixes the issue where the position of the shapes are wrong when converting Excel to PDF.
Fixes the issue that caused XmlException when loading Excel file.


Spire.XLS Pack Hotfix Version:7.12.27
New feature:
Add custom properties to Excel documents.
Code: Select all
Workbook workbook = new Workbook();
workbook.CustomDocumentProperties.Add("_MarkAsFinal", true);
workbook.CustomDocumentProperties.Add("The Editor", "E-iceblue");
workbook.CustomDocumentProperties.Add("Phone number1",81705109);
workbook.CustomDocumentProperties.Add("Revision number", 7.12);
workbook.CustomDocumentProperties.Add("Revision date", DateTime.Now);
workbook.SaveToFile(outputFile, FileFormat.Version2010);

Bug fixes:
Fixes the issue that caused XmlException when SaveAsImage method was invoked.
Fixes the issue that the data in the shape isn't updated after editing.
Fixes the issue that the result PDF converted from Excel prompts message "Cannot extract the embedded font 'FAACFG+ArialMT'. Some characters may not display or print correctly.".
Fixes the issue that caused ArgumentOutOfRangeException when loading files.


Spire.XLS Pack Hotfix Version:7.12.19
Bug solutions:
Fixes the issue that caused NullReferenceException when using InsertRow method.
Fixes the issue that caused incorrect result when getting validation formula.
Fixes the issue that caused ArgumentOutOfRangeException when using CalculateAllValue mehtod.
Fixes the issue that caused wrong date format when getting the data.
Fixes the issue that caused icon missing when converting Excel to image.
Improves the conversion from Excel to PDF.


Spire.XLS Pack Hotfix Version:7.12.7
Bug solutions:
Fixes the issue that the position of the datalabel cannot be changed.
Fixes the issue that caused the process hanging when using the GetSplitPageInfo method.
Fixes the issue that caused wrong value when copying range.
Fixes the issue that caused "spr2380 was unhandled" exception when using CalculateAllValue.
Improves the function of converting Excel to PDF.
Fixes the issue that caused exception when using multi-thread to load document.


Spire.XLS Pack Version:7.12
Bug solutions:
Reduce the PDF file size when converting Excel to PDF.
Fixes the issue where the cell with the formula did not autofit although wrap text is enabled when converting Excel to PDF.
Fixes the issue that caused the "Align with page margins" property in page setup unchecked when saving Excel file.
Fixes the issue that caused the unexpected spaces exception when loading Excel file.
Fixes the issue where the first inner group was not collapsed when setting "sheet.PageSetup.IsSummaryRowBelow" property as false.
Fixes the issue where the value of INameRange was get incorrectly.
Fixes the issue that caused the data lost when set ignoreSize argument exists in the sheet.Copy method as true.
Resolves the issue where the width of columns was changed when make an AutoFitColumn on columns with merge values.


Spire.XLS Pack Version:7.11.59 hotfix
New Feature:
Spire.XLS supports to export chart when converting Excel to HTML.
Bug solutions:
Fixes the issue that caused exception when getting the first column.
Fixes the issue that the inner Group collapsed wrongly when creating multiple Groups.
Fixes the issue that caused wrong image when converting Excel to image.
Fixes the issue that caused OverflowException when loading an Excel file.
Fixes the issue that caused NullReferenceException when copying a worksheet.


Spire.XLS Pack Version:7.11.49 hotfix
New Feature:
Add AddAllowEditRange method to allow user to edit the specified range while protect sheet.
Code: Select all
sheet.AddAllowEditRange("AAA", sheet.Range["A1:D35"], "");

Bug solutions:
Fixes the issue that caused extra blank page when converting Excel to PDF.
Fixes the issue that caused wrong format when converting Excel to PDF.
Fixes the issue that caused wrong format of table when inserting a row into table.
Fixes the issue that caused process hanging when loading the Excel file.
Fixes the issue that caused ArgumentOutOfRnageException when loading the Excel file.


Spire.XLS Pack Version:7.11.34 hotfix
New Feature:
Add CustomDocumentProperties property for workbook object to get the custom properties.
Code: Select all
Workbook workbook = new Workbook ();
workbook.LoadFromFile(@"test.xlsx");
ICustomDocumentProperties properties = workbook.CustomDocumentProperties;
for (int i = 0; i < properties.Count;i++)
{
string name = properties[i].Name;
string value = properties[i].text;
}

Bug solutions:
Fixes the issue that caused the content lost when saving chart to image.
Resolves the issue that caused the "Cannot find Formula token with code: 255" exception when getting formula.
Fixes the issue that caused the formula text incorrect when saving .xlsx to PDF.
Fixes the issue that caused the checkmark text lost when saving Excel to PDF.
Resolves the issue where the spaces in the checkmark caption text was deleted when saving Excel to PDF.
Fixes the issue that caused the some texts were clipped when saving Excel to PDF.
Fixes the issue that cause table lost when saving Excel to PDF.
Fixes the issue where MSOffice07 can't open the generated document when adding a textbox to the worksheet.
Fixes the issue that caused excel file huge until OutOfMemory exception when adding image to sheet.
Resolves the issue where the checkbox ID and name can't be get.
Fixes the issue that caused "Requested value 'picture' was not found." error while loading.
Fixes the issue that caused the exception error on the CopyFrom method.


Spire.XLS Pack Version:7.11.13 hotfix
New Feature:
Support to check whether the workbook is password protected.
Code: Select all
bool havepwd = workbook.IsPasswordProtected(inputFile);

Support to extract the equation of chart trendline.
Code: Select all
IChartTrendLine trendLine = workbook.WorkSheets[0].Charts[0].Series[0].TrendLines[0];
string formula = trendLine.Formula;

Bug solutions:
Fixes the issue where Sparklines cannot be edited or deleted.
Fixes the issue that caused KeyNotFoundException when set border for cells.
Fixes the issue that caused leader line missing and overlapped content when save chart as image.
Fixes the issue that caused ApplicationException when load file.
Fixes the issue that caused XmlException when load file.
Fixes the issue that caused incorrect content when convert Excel to PDF.
Fixes the issue that caused ArgumentOutOfRangeException when convert Excel to PDF.
Fixes the issue that caused wrong page break when convert Excel to PDF.
Fixes the issue that caused chart location changed when use AutoFitColumns method.
Fixes the issue that caused InvalidCastException when extract HPageBreak in HPageBreaksCollection.
Fixes the issue that caused ArgumentOutOfRangeException when set color for DataPoint.

Spire.XLS Pack Version:7.11.1 hotfix
New Feature:
Supports to add Oval shape in chart
Code: Select all
var shape=chart.Shapes.AddOval(left,top,right,bottowm);

Bug solutions:
Fixes the issue where chart labels were not visible when chart is saved as image or when workbook is saved as pdf.
Fixes the issue that caused the extra blank page when convert to PDF.
Resolves the issue that caused the chart lost when convert to PDF.
Fixes the issue that caused AutoFitColumns/AutoFitRows method throwing ArgumentOutOfRangeException.


Spire.XLS Pack Version:7.11
New Feature:
Supports to convert Excel to SVG file format.
Code: Select all
for (int i = 0; i < workbook.Worksheets.Count; i++)
            {
                FileStream fs = new FileStream(string.Format("sheet7{0}.svg", i), FileMode.Create);
                workbook.Worksheets[i].ToSVGStream(fs, 0, 0, 0, 0);
                fs.Flush();
                fs.Close();
            }



Spire.XLS Pack Version:7.10.86 hotfix
New Feature:
Supports to set Multi-Level Category Labels property for the chart Axis.
Code: Select all
chart.PrimaryCategoryAXis.MultiLeaveLable = true;
Supports to save chart as vector image.
book.SaveChartAsEmfImage(chartSheet);

Bug solutions:
Fixes the issue that caused incorrect content when convert Excel to PDF.
Fixes the issue that caused incorrect formula value when convert Excel to PDF.
Fixes the issue that caused wrong order of chart series when convert Excel to PDF.
Fixes the issue that caused custom datalable missing when save chart to image.
Fixes the issue that caused NullReferenceException when save file.
Fixes the issue that caused AccessViolationException when load file.
Fixes the issue that caused ArgumentOutOfRangeException when load xlsm file.
Fixes the issue that caused unable to remove chart.
Fixes the issue that caused ArgumentException when insert invalid date into cell.
Fixes the issue that caused picture missing when fill picture into comment.


Spire.XLS Pack Version:7.10.79
New Feature:
Supports to assign a discontinuous range for a chart.
Code: Select all
ChartSerie.CategoryLabels = sheet.Range["E8:E9"].AddCombinedRange(sheet.Range["G8:G9"]).AddCombinedRange(sheet.Range["I8:I9"]);
ChartSerie.Values = sheet.Range["F8:F9"].AddCombinedRange(sheet.Range["H8:H9"]).AddCombinedRange(sheet.Range["J8:J9"]);

Supports to add line shape in chart.
Code: Select all
Chart.Shapes.AddLine(Point startPoint, Point endPoint, LineShapeType lineShapeType);

Supports to set header/footer on OddEven page.
Code: Select all
Worksheet.PageSetup.DifferentOddEven = 1;
Worksheet.PageSetup.OddHeaderString = "&COdd_Header1";
Worksheet.PageSetup.OddFooterString = "&COdd_Footer1";
Worksheet.PageSetup.EvenHeaderString = "&CEven_Header2";
Worksheet.PageSetup.EvenFooterString = "&CEven_Footer2";

Add new method to specify the ExcelVersion to avoid the limitation in Excel when load CSV file.
Code: Select all
public void LoadFromFile(string fileName, string separator, int row, int column, ExcelVersion version);

Bug solutions:
Fixes the issue that caused thread unsafe when convert to PDF.
Fixes the issue that caused some added controls (combo box or comment) incorrect when resave.
Resolves the issue that caused the image in the textbox disappear when convert to PDF.
Fixes the issue where formula in the image disappeared.
Fixes the issue that caused the image can't be deleted after it was inserted with ExcelPicture.


Spire.XLS Pack Version:7.10.46
Bug solutions:
Fixes the issue that caused the textbox incorrect when convert to PDF.
Fixes the issue that caused the link lost when convert excel to html.
Fixes the issue that caused the exception "The surrogate pair (0xD840, 0x5F) is invalid" when save.
Fixes the issue that caused the error "no printers are installed" when print .xls files.
adds the interface to clear the converted cache when convert to Image many times.
Code: Select all
workbook.ConverterSetting.ClearCacheOnConverted = true;



Spire.XLS Pack Version:7.10
Bug solutions:
Fixes the issue that caused different colors and styles when convert Chart to image.
Fixes the issue that the chart cannot be read when loading .xlsx document.
Fixes the issue that the got value is 0 when reading formula value is #DIV/0!.
Fixes the issue that the setting specific range doesn't work when converting .xls to Images by sheet.ToImage(firstRow, firstColumn, lastRow,lastColumn) method.
Fixes the issue that the format of other data also is changed when changing the format of the chart legend.
Fixes the issue that data range is changed when converting Excel to EMF.
Fixes the issue that the formulas change when copying a row into other row.

Spire.XLS Pack Hotfix Version:7.9.39
New Features:
Add new property to remove the macros or not when convert .xlsm to .xlsx.
Code: Select all
workbook.HasMacro=true/false;
 

Add new method to custom text for line chart series data points, which is only for Excel2013.
Code: Select all
chart.Series[0].DataPoints.DefaultDataPoint.DataLabels.ValueFromCell = sheet.Range["B5:k5"];
 

Bug solutions:
Fixes the issue that caused different colors and styles when convert Chart to image.
Fixes the issue that caused incorrect cell indents when convert sheet to image.
Fixes the issue where checkboxes had been duplicated.
Fixes the issue where the formula of conditional format displayed incorrectly when save to ExcelVersion2003.
Fixes the issue where GetFont() method identified the style incorrectly.
Resolves the issue where the Formulas were not calculating properly while exporting the PDF.
Fixes the issue where set print area as null didn't work.
Fixes the issue that caused KeyNotFoundException when use Spire.Xls.CellStyle functionality.

Spire.XLS Pack Hotfix Version:7.9.17
New Feature:
Add new feature to set the IconSetType of conditional formatting.
Code: Select all
ConditionalFormatWrapper format = sheet.AllocatedRange.ConditionalFormats.AddCondition();
format.FormatType = ConditionalFormatType.IconSet;
format.IconSet.IconSetType = IconSetType.ThreeTrafficLights1;

Bug solutions:
Fixes the issue where the extra chart sheet is included when converting to PDF.
Fixes the issue where the hidden sheet is included when converting to PDF.


Spire.XLS Pack Version:7.9
New Features:
Add new method to customize data label position.
Code: Select all
ChartDataLabels format = chart.Series[i].DataPoints.DefaultDataPoint.DataLabels;
format.IsXMode = true;
format.IsYMode = true;
format.X = 1800;
format.Y = 2000;

Add new method to set the position of the comment.
Code: Select all
ExcelComment comment = range.AddComment();
comment.SetCommentLocation(true,true);

Bug solutions:
Fixes the issue that caused the text font in the textbox bold when convert to PDF/XPS.
Fixes the issue that caused the TextRotationAngle of PrimaryCategoryAxis not working when converts to PDF.
Resolves the issue where the category label in chart is incorrect when convert to PDF.
Fixes the issue that caused the exception when combine multiple Excel files.
Resolves the issue that caused OverflowException when load Excel file.
Fixes the issue that caused shape lost when convert sheet to Image.
Fixes the issue that caused the richtext formatting lost when convert to Image.
Fixes the issues where the label colors and positions in images are not the same as in charts when save the charts from sheets as images.
Fixes the issue where the spreadsheet showed a right parenthesis on all fields when select the whole spreadsheet and click on the Comma button to format numbers with commas.
Fixes the issue that cause unusual formula calculation.
Fixes the issue where the category labels color in chart cannot changed.
Fixes the issue caused formatting Date not working in "dd/MM/yyyy" Format.
Fixes the issue caused exception when loading worksheet has password protected.
User avatar

amy.zhao
 
Posts: 2328
Joined: Wed Jun 27, 2012 8:50 am

Return to Spire.XLS

cron