Aspose.Cells for .NET 20.2 Release Notes

CELLSNET-47113Pipe-delimited / CSV to JSON conversionNew Feature
CELLSNET-47141The link between the Pivot Table and the external connectionNew Feature
CELLSNET-47135Aspose.Cells does not consider TEXTJOIN() advanced formula/function as FormulaEnhancement
CELLSNET-47126Aspose.Cells deletes “volatileDependencies.xml” from file with RTD formulas while updating XLSX fileEnhancement
CELLSNET-47159Too much time cost for PivotTable.CalculateStylePerformance
CELLSNET-42065Previously calculated Pivot Percentage breaks after the pivot.CalculateData()Bug
CELLSNET-47102“#” displayed after converting Excel to PDF on Negative Time custom format(h:mm)Bug
CELLSNET-47118Incorrect value ‘TRUE’ retrieved from Cell instead of value ‘FALSE’Bug
CELLSNET-47125Spaces are lost from the formula when fetched using Aspose.Cells for .NETBug
CELLSNET-47149Formula calculation is different in Aspose.Cells and MS ExcelBug
CELLSNET-47108Conditional Formatting not displayed in GridDesktopBug
CELLSNET-47134Inserting column takes too much time in Aspose.Cells.GridDesktopBug
CELLSNET-47138GridDesktop takes a long time to load large size filesBug
CELLSNET-47043Unable to select a cell for protected sheet into GridDesktopBug
CELLSNET-47117Aspose.Cells 20.1 XAdES type is not defined when reading previously signed files with XAdES signaturesBug
CELLSNET-47081Rendering Chart to PDFBug
CELLSNET-47085The chart is not rendered properly when axis labels’ text direction is ‘Stack’Bug
CELLSNET-47112The chart to image conversion failsBug
CELLSNET-47133Inconsistency when exporting to PDFBug
CELLSNET-47107Conditional formatting object gives wrong results for IsAboveAverage attributeBug
CELLSNET-47114Workbook RemoveExternalLinks results in a broken documentBug
CELLSNET-47139ODS file with external link formula shows extra worksheetsBug
CELLSNET-47145Named range disappears after opening and saving ODS fileBug
CELLSNET-47146File not getting openedBug
CELLSNET-47147Sheet Code name issueBug
CELLSNET-47153ODS graphs are changing after saveBug
CELLSNET-47157Wrong number of external linksBug
CELLSNET-47164IsItalic property detected differently than MS ExcelBug
CELLSNET-47169CategoryType.CategoryScale not set in ParetoLine chartBug
CELLSNET-47122“Index out of range” exception when refreshing Pivot TablesException
CELLSNET-47156IndexOutOfRangeException while accessing ExternalLink.IsReferred or IsVisibleException
CELLSNET-47140Exception while loading ODS into GridDesktopException
CELLSNET-47105Exception while importing XML data where a column in the table not mappedException
CELLSNET-47170Exception “Invalid cast from ‘DateTime’ to ‘Double’” when saving an Excel file to PDFException
CELLSNET-47152Worksheet.Cells.EndCellInRow giving error for the fileException

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 Workbook.ParseFormulas(bool ignoreError) method.

Parses all formulas which have not been parsed when they were loaded or set to a cell.

Adds PivotTable.ExternalConnectionDataSource property.

Gets the external connection data source.

Adds FileFormatType.Numbers35 enum.

Represents the Number 3.5 files since office 2014. Only for throwing the file format when reading.

Adds LoadOptions.CheckDataValid property.

Indicates whether the data is valid when loading the files.

Adds GridDesktop.GridMemorySetting property.

Gets or sets memory option for loading worksheets.