Spire.XLS 7.6.21

This package has no dependencies.

Spire.XLS 7.6.21
Add new feature to set the shapeFillType as No Fill.
Add new feature to hide chart title.
Spire.XLS 7.6.1
Fix the issue that row height turned smaller when converting .xlsx to pdf.
Fix the error "Invalid PrintOrderType string val" caused when converting xlsx to pdf.
Fix the issue that borders were added when converting .xlsx to pdf.
Fix the issue that page size was changed when converting .xlsx to pdf.
Fix the error "Object reference not set to an instance of an object." caused when converting .xlsx to pdf.
Fix the error "Unknown version" caused when setting excel version to Version2013.
Fix the issue that it was very slow on merging cells, when setting Row.Style.WrapText = true.

Spire.XLS 7.5.19
Convert .xls to .xlsm and keep macros starts to support.
Fix the issue that Excel 2013 does not recognize the file when saving as stream with Excel2013 format and giving the file .xlsx extension.
Fix the error"Value was either too large or too small for UIni16" when loading an .xlsx file.
Fix the error"An XML error has occurred" when loading an .xlsx file.

Spire.XLS 7.5.17
Fix the issue that the location of image was changed when converting excel to Html.
Fix the error "Value cannot be null" when saving excel to html stream.
Fix the issue that the size of image was changed when adding image into .xls.
Fix the color didn't work when setting Color.FromArgb(69, 107, 61) for textbox.

Spire.XLS 7.5.16
Converting Excel to XPS starts to support by Spire.XLS.
Fix the issue that borders of merged cells were missing when converting excel to pdf.
Fix the issue that file was protected when converting .xls to .xlsx.

Spire.XLS 7.5.12
Fix the error "Invalid Data Source" when converting Excel to PDF.
Fix the issue that the format of a cell cannot be assigned to other cells.

Spire.XLS 7.5.7
Add new feature to embed image into HTML when converting Excel to HTML by setting HTMLOptions.Default.ImageEmbedded = true;
Add new feature to set size of plotArea and legend of chart.
Fix the issue that the printout came out somewhat blurry when printing excel file.
Fix the error "NullReferenceException" when loading excel file.
Fix the issue that the position of image was incorrect when converting Excel to HTML.
Fix the issue that got rows count of sheet was incorrect using int count=sheet.Rows.Length;


Spire.XLS 7.5.5

New features:
Add new feature to read value in cell of pivot table.
Add new feature to fold and unfold the fields of pivot table.
Add new feature to insert few blank rows as a header rows in the sheet in which pivot table is created.

Bug solutions:

Fix the issue that the shape is lost when loading and saving .xlsx file.
Fix the error "Specified argument was out of the range of valid values" occurred when converting excel to pdf.
Fix the error "Arithmetic operation resulted in an overflow." occurred when saving .xls file.
Fix the issue that it took a long time to calculation all value of excel file.
Fix the error "unknown formula IFERROR" occurred when getting the value of ACCRINT formula using FormulaStringValue method.

Spire.XLS 7.5.3
Add a new feature to auto fit all columns of pivot table.
Add a new feature to set "Enable show details", "Refresh data when opening the file" for data of Pivot table.
Add a new feature to print Excel file.
Fix the issue that all icons of conditional formatting were lost when opening and saving .xlsx file.
Fix the issue that auto fit function didn't work in converting Excel to PDF.

Spire.XLS 7.5
Fix the error "Arithmetic operation resulted in an overflow" occurred when copying data from a sheet to another sheet of the same workbook.

Spire.XLS 7.4.16
Fixed the bug that the position of some icons in the html file converted from excel file is incorrect.
Fixed the issue that CheckState property of CheckBox doesn't work.
Fixed the issue that secondary axis for a line chart object is not able to be initialized.

Spire.XLS 7.4.13
Add new feature to add report filter in pivot table.

Fixed the error that "A disk error occurred during a write operation." when loading an .xls file from memory stream into the pdfConverter.
Fixed the error that "Unable to read beyond the end of the stream." when loading an .xls file.


Spire.XLS 7.4.9
New Features:
Add new feature to convert PivotTable to PDF.
Add new feature to insert row with the style of previous row to excel, sheet.InsertRow(rowIndex,rowCount, InsertOptionType);.
Bug Solutions:
Fix the issue that Worksheet.AutoFitRow() method doesn't work.
Resolved wrong index issue in DeleteRow(index, count) method.
Fix the issue that dynamic (formula calculated) data was not correctly after added to the chart.
Fix the issue that the PivotTable data was not refreshed.
Fix the borders missing issue after protecting the excel file with a password.
Fix the issue that workbook.DataSorter.Sort() method doesn't work.
Fix wrong page number in Image converted from excel file.
Fix the error "Requested value 'vertical' was not found" caused while loading excel file.
Fix the wrong format of date in HTML converted from excel files.
Fix that data bar missing issue in PDF converted from excel files.
Fix the superscript and subscript missing issue in Html converted from excel files.
Fix the error "Object reference not set to an instance of an object" when executing the line workbook.CreatePivotStyle();
Fix the issue that the data of cell is truncated in Html file converted from excel file.
Fix the issue AutoFitColumns() method doesn't work for the merged cells.
Fix the issue that Worksheet.SaveAsHtml() method is not calculating formulas in output html file.
Fix the error "Requested value 'vertical' was not found" caused when deleting row from excel file.


Spire.XLS 7.4
Add a new feature to show totals in a pivot table as percentage of totals.

Spire.XLS 7.3.12 New feature and bug solutions.

Add a new feature to get the page count of excel file and the row and column number of page break.
• Fix the format is missing issue when filling data into cell range.
• Fix the sheet still can be edited when set the property SheetProtectionType.Objects
• Fix some content is missing issue in converted Image from Excel.


In this new version, we updated the feature of converting Excel to PDF. With this enhancement, more elements in Excel file can be converted to PDF successfully, such as chart, shape, smart art and etc.

And the .xlsb, ods formats starts to support by Spire.XLS.