Aspose.Cells for .NET 19.1 Release Notes

KeySummaryCategory
CELLSNET-46429Add PivotTable with Show Report Filter Pages optionNew Feature
CELLSNET-46014Support handling overflowing cell content while saving as PDF and imageNew Feature
CELLSNET-46490Support Excel95/5.0 XLS filesNew Feature
CELLSNET-46500Sort by cell background colorNew Feature
CELLSNET-46544Detect if generated MHT file is a worksheet or notNew Feature
CELLSNET-46538When XLSX is saved as PDF or TIFF, the bottom of the text is missingBug
CELLSNET-46509R1C1 formulas are read incorrectly for certain cellsBug
CELLSNET-46513Aspose.Cells formula calculation engine calculates a formula for the cell as “0” instead of “#REF!” errorBug
CELLSNET-46535“#NAME?” for formulas saved in XLSB formatBug
CELLSNET-46539Formula case sensitive issueBug
CELLSNET-46531Renaming ListColumns corrupts workbook (when there is a PivotTable)Bug
CELLSNET-46511TIFF created with extra blank pagesBug
CELLSNET-46522Applying regional settings to print setup headersBug
CELLSNET-46529Image missing after XLSX to PDF conversionBug
CELLSNET-46451Issue when rendering the template file to PDF file formatBug
CELLSNET-46518Layout issue (some axis labels are in two lines) when rendering the template file to PDF file formatBug
CELLSNET-46113File format is not supported exception for XLS documentBug
CELLSNET-46504Links Path issueBug
CELLSNET-46506Difference with ImportObjectArray methodBug
CELLSNET-46541Combo chart not working with v18.12.x but works with v18.4 and earlier versionsBug
CELLSNET-46543Exception while calling Cells.DeleteBlankRowsException
CELLSNET-46459An exception raises while converting to the Open Strict XML formatException
CELLSNET-46485Exception when loading an XLSB file formatException
CELLSNET-46508Exception when loading an XLSM file formatException

Public API and Backwards Incompatible Changes

The following is a list of any changes made to the public API such as added, renamed, removed or deprecated members as well as any non-backward compatible change made to Aspose.Cells for .NET. If you have concerns about any change listed, please raise it on the Aspose.Cells support forum.

Adds PivotTable.ShowReportFilterPageByName(string fieldName) method

Shows all the report filter pages according to PivotField’s name, the PivotField must be located in the PageFields.

Adds PivotTable.ShowReportFilterPageByIndex(int posIndex) method

Shows all the report filter pages according to the position index in the PageFields.

Adds PivotTable.ShowReportFilterPage(PivotField pageField) method

Shows all the report filter pages according to PivotField, the PivotField must be located in the PageFields.

Adds DataSorterKey and DataSorterKeyCollection class

Represents the key of the data sorter.

Adds DataSorter.AddKey(Int32,SortOnType,SortOrder,Object) method

Adds the sort key such as cell’s background color, font color.

Adds Aspose.Cells.DataSorter.Keys property

Gets all keys of the data sorter.

Adds SortOnType enum

Represents the type of sorted data.

Adds ODSLoadOptions class

Represents the options of loading ODS file.

Adds HTMLLoadOptions.ProgId property

Gets the program id of creating the file. used only for MHT files.

Adds PdfSaveOptions.TextCrossType property

Gets or sets displaying text type when the text width is larger than cell width.

Adds TextCrossType enum class

Enumerates displaying text type when the text width is larger than cell width.

Adds WorksheetCollection.RegisterAddInFunction() methods

Replacement of Cell.SetAddInFormula(), a more convenient and efficient way for users to add and use addin functions.

Obsoletes Cell.SetAddInFormula() method

Please register the addin functions firstly by WorksheetCollection.RegisterAddInFunction() and then setting the formula for Cell by Cell.Formula/Cell.SetFormula() instead.