Aspose.Cells for .NET 20.4 Release Notes

Key Summary Category
CELLSNET-47276 XLSX to CSV, commas required for blank cells also similar to MS Excel New Feature
CELLSNET-47054 Support union of multiple cells as a range New Feature
CELLSNET-47091 Option to update source field of PowerQueryFormulaItems New Feature
CELLSNET-47273 Set Latin text font and Asian text font for the chart category axis Enhancement
CELLSNET-47217 Support databar, color scale and iconset conditional formattings of ODS. Enhancement
CELLSNET-47201 Open the password-protected file using Aspose.Cells.GridDesktop Enhancement
CELLSNET-47254 Support enter new line as in MS-EXCEL in the formula bar Enhancement
CELLSNET-47224 Improve the performance of refreshing pivotables. Performance
CELLSNET-47243 Hang on GetDisplayStyle for a worksheet with rows 65536 Performance
CELLSNET-47289 CalculateFormula() never returns Performance
CELLSNET-47263 Hanging while trying to open ODP document in Workbook constructor Performance
CELLSNET-42556 Sorting of PivotField does not seem to work Bug
CELLSNET-47046 Unopened quote delimiters in IMG HTML attributes in generated HTML markup Bug
CELLSNET-47208 Pivot table not keeping the format with the latest version Bug
CELLSNET-47219 Wrong formula in the table column after insertion of a row and refreshing it Bug
CELLSNET-47261 Excel to HTML rendering - wrong font size in a table exported Bug
CELLSNET-47279 The first column text in all rows is not sub-scripted when exporting the file to HTML Bug
CELLSNET-47163 Issue with inserting Column and Update Reference Bug
CELLSNET-47244 Formulas (MROUND, MIN) not calculated correctly Bug
CELLSNET-47250 Remove duplicates works for the first column only when specifying columnOffsets parameter Bug
CELLSNET-47267 Formulas are not calculated in the template file Bug
CELLSNET-47268 TrimLeadingBlankRowAndColumn inconsistency Bug
CELLSNET-47269 XLSX to CSV conversion - missing comma in the output Bug
CELLSNET-47200 Overlapping on navigation buttons issue when setting hidden sheet as the active sheet Bug
CELLSNET-47274 Background image not set in GridWeb Bug
CELLSNET-47179 VBA signature with Bouncy Castle lib Bug
CELLSNET-47258 Issue with barcode images in Sheet to TIFF rendering Bug
CELLSNET-47216 PowerQueries gone after Source replacement Bug
CELLSNET-47241 ODS file is breaking while setting the font style and saving Bug
CELLSNET-47252 Numeric Smart Marker inserting cell value as text Bug
CELLSNET-47262 Issue with 100% Stacked Bar and the major unit and minor unit Bug
CELLSNET-47271 Saving XLSX with embedded visio corrupts the file Bug
CELLSNET-47282 Aspose.Cells 20.3: XLSB to XLS Conversion Issue Bug
CELLSNET-47291 Wrong bullet character read from Excel file Bug
CELLSNET-47096 Issue with GridDesktop formula bar with SplitterPane Bug
CELLSNET-47247 Exception raised when Cell.R1C1Formula is called Exception
CELLSNET-47235 NullPointerException when refreshPivotData Exception
CELLSNET-47246 Exception “Cannot access a closed Stream” when saving an Excel file to PDF Exception
CELLSNET-47086 An exception is thrown when rendering a chart Exception
CELLSNET-47242 FormatException on the file loading Exception
CELLSNET-47266 Exception “Argument index is out of array range” while loading all the attached files 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 ChartTextFrame.DirectionType property.

Gets and sets the direction of text in the chart.

Adds ChartTextFrame.ReadingOrder and obsoletes ChartTextFrame.TextDirection property.

Use ChartTextFrame.ReadingOrder property instead.

Adds classes for the enhanced feature of Revisions.

Gets the information of the revision.

Changes default value of TxtSaveOptions.TrimLeadingBlankRowAndColumn property.

To make the default behavior of saving CSV the same with ms excel, we changed the default value and behavior of this property. For old versions, its default value was “false”. From 20.4, its default value becomes “true”.

Changes the behavior for detecting blank rows/columns for saving CSV.

For old versions, we took those rows/columns which have no data but have custom settings(visibility, formatting, …etc.) as blank. From 20.4, we do not take them as blank anymore, the new behavior is the same with ms excel.

Adds TxtSaveOptions.ExportArea property.

Specifies the range of cells data to be exported. Users may use this option to get the same result with old versions for the changed behavior of TxtSaveOptions.TrimLeadingBlankRowAndColumn and blank rows/columns.

Adds UnionRange class.

Represents union range.

Deletes obsoleted DrawObject.Image property.

Use DrawObject.ImageBytes property instead.

Adds Bullet.FontName property

Gets and sets the font name of the bullet.

Adds WorksheetCollection.CreateUnionRange() method.

Creates a union range. 

Deletes obsoleted SaveType enum.

It’s unused.

Deletes obsoleted OleObject.ImageFormat and Picture.ImageFormat properties.

Use OleObject.ImageType and Picture.ImageType properties instead.