Aspose.Cells for .NET 20.2 Release Notes

Key Summary Category
CELLSNET-47113 Pipe-delimited / CSV to JSON conversion New Feature
CELLSNET-47141 The link between the Pivot Table and the external connection New Feature
CELLSNET-47135 Aspose.Cells does not consider TEXTJOIN() advanced formula/function as Formula Enhancement
CELLSNET-47126 Aspose.Cells deletes “volatileDependencies.xml” from file with RTD formulas while updating XLSX file Enhancement
CELLSNET-47159 Too much time cost for PivotTable.CalculateStyle Performance
CELLSNET-42065 Previously 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-47118 Incorrect value ‘TRUE’ retrieved from Cell instead of value ‘FALSE’ Bug
CELLSNET-47125 Spaces are lost from the formula when fetched using Aspose.Cells for .NET Bug
CELLSNET-47149 Formula calculation is different in Aspose.Cells and MS Excel Bug
CELLSNET-47108 Conditional Formatting not displayed in GridDesktop Bug
CELLSNET-47134 Inserting column takes too much time in Aspose.Cells.GridDesktop Bug
CELLSNET-47138 GridDesktop takes a long time to load large size files Bug
CELLSNET-47043 Unable to select a cell for protected sheet into GridDesktop Bug
CELLSNET-47117 Aspose.Cells 20.1 XAdES type is not defined when reading previously signed files with XAdES signatures Bug
CELLSNET-47081 Rendering Chart to PDF Bug
CELLSNET-47085 The chart is not rendered properly when axis labels' text direction is ‘Stack’ Bug
CELLSNET-47112 The chart to image conversion fails Bug
CELLSNET-47133 Inconsistency when exporting to PDF Bug
CELLSNET-47107 Conditional formatting object gives wrong results for IsAboveAverage attribute Bug
CELLSNET-47114 Workbook RemoveExternalLinks results in a broken document Bug
CELLSNET-47139 ODS file with external link formula shows extra worksheets Bug
CELLSNET-47145 Named range disappears after opening and saving ODS file Bug
CELLSNET-47146 File not getting opened Bug
CELLSNET-47147 Sheet Code name issue Bug
CELLSNET-47153 ODS graphs are changing after save Bug
CELLSNET-47157 Wrong number of external links Bug
CELLSNET-47164 IsItalic property detected differently than MS Excel Bug
CELLSNET-47169 CategoryType.CategoryScale not set in ParetoLine chart Bug
CELLSNET-47122 “Index out of range” exception when refreshing Pivot Tables Exception
CELLSNET-47156 IndexOutOfRangeException while accessing ExternalLink.IsReferred or IsVisible Exception
CELLSNET-47140 Exception while loading ODS into GridDesktop Exception
CELLSNET-47105 Exception while importing XML data where a column in the table not mapped Exception
CELLSNET-47170 Exception “Invalid cast from ‘DateTime’ to ‘Double’” when saving an Excel file to PDF Exception
CELLSNET-47152 Worksheet.Cells.EndCellInRow giving error for the file Exception

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.