Aspose.Cells for .NET 19.1 Release Notes
|Add PivotTable with Show Report Filter Pages option
|Support handling overflowing cell content while saving as PDF and image
|Support Excel95/5.0 XLS files
|Sort by cell background color
|Detect if generated MHT file is a worksheet or not
|When XLSX is saved as PDF or TIFF, the bottom of the text is missing
|R1C1 formulas are read incorrectly for certain cells
|Aspose.Cells formula calculation engine calculates a formula for the cell as “0” instead of “#REF!” error
|“#NAME?” for formulas saved in XLSB format
|Formula case sensitive issue
|Renaming ListColumns corrupts workbook (when there is a PivotTable)
|TIFF created with extra blank pages
|Applying regional settings to print setup headers
|Image missing after XLSX to PDF conversion
|Issue when rendering the template file to PDF file format
|Layout issue (some axis labels are in two lines) when rendering the template file to PDF file format
|File format is not supported exception for XLS document
|Links Path issue
|Difference with ImportObjectArray method
|Combo chart not working with v18.12.x but works with v18.4 and earlier versions
|Exception while calling Cells.DeleteBlankRows
|An exception raises while converting to the Open Strict XML format
|Exception when loading an XLSB file format
|Exception when loading an XLSM file format
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.