Aspose.Cells for .NET 20.3 Release Notes

Key Summary Category
CELLSNET-47130 Support for FLOOR.MATH(-555,5,1) New Feature
CELLSNET-47168 Support for FILTER function New Feature
CELLSNET-47204 Get worksheet unique id New Feature
CELLSNET-47229 Support for setting chart.series.dataLables.TextDirection to vertical New Feature
CELLSNET-47092 Make icons available for IStreamProvider like usual images while saving the document to HTML Enhancement
CELLSNET-47094 Reduce flickering in GridDesktop for smooth resizing Enhancement
CELLSNET-47173 Distinguish hidden/very hidden sheets in Aspose.Cells.GridDesktop Enhancement
CELLSNET-47101 Improve the performance of saving conditional formatting and validation with whole rows. Enhancement
CELLSNET-47178 Indentation lost while creating a table and converting to HTML Bug
CELLSNET-47199 The difference in the calculation for named range while setting CreateCalcChain to true and false Bug
CELLSNET-47077 Could not apply borders to the cells (having data) when importing an Excel file into GridDesktop Bug
CELLSNET-47172 Problem applying Conditional Formatting Bug
CELLSNET-47177 ParetoLine chart series name and line not rendered to the image Bug
CELLSNET-47191 The chart to image difference Bug
CELLSNET-47202 Legend entries are overlapped in the output image of the chart Bug
CELLSNET-47167 Wrong number of visible links Bug
CELLSNET-47184 BIFF5 with Cyrillic content is incorrectly converted to XLSX Bug
CELLSNET-47205 Range.ApplyStyle() on column range massively increased the workbook file size Bug
CELLSNET-47210 The rich formatted string value of a cell is empty in Apple Numbers'09 Bug
CELLSNET-47213 Copying Sheet to another workbook - hidden cells (rows) disappear Bug
CELLSNETCORE-53 Datapoint on Excel chart line is removed after convert to PDF Bug
CELLSNET-47212 NullReferenceException when saving particular XLSM to XLS Exception
CELLSNET-47222 Aspose.Cells 20.2: Exception when converting particular XLSB file to Excel97To2003 Exception
CELLSNET-47226 Aspose.Cells 20.2: Exception when trying to delete blank columns 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.

Change behavior of formatting features for some user-specified CultureInfos.(.NET ONLY)

In old versions, our formatting engine may modify some properties of some special cultures to get the general formatted result. For example, for most situations, JapaneseCalendar should be used to format date-time values, so in old versions we always make CultureInfo of “ja-JP” use JapaneseCalendar for formatting. However, it is not always intended for users when they specify their custom CultureInfo by APIs, such as WorkbookSettings.CultureInfo or CustomImplementationFactory.CreateCultureInfo(). So, from 20.3, we use CultureInfo.UseUserOverride property to decide whether change properties automatically for formatting. For the specified CultureInfo, if this property is true, then we take it as that user has overridden all needed properties, so we will not change it anymore for formatting. If this property is false, then we may modify other properties of it automatically if needed.

Add property LoadFilter.SheetsInLoadingOrder.

Users may override this property to specify the sheets and order to be loaded while importing workbooks from the template file.

Deletes obsolete TickLabels.Background property

Use TickLabels.BackgroundMode property instead.

Obsoletes TickLabels.TextDirection property and adds TickLabels.ReadingOrder property

Use TickLabels.ReadingOrder property instead.

Obsoletes TickLabels.DirectionTypeproperty and adds enum ChartTextDirectionType

Represents the direction of text.

Adds Shape.RemoveActiveXControl() method.

Removes ActiveX data from the shape.

Adds ThreadedComment.CreatedTime property.

Gets and sets the created time of threaded comments.

Adds Worksheet.UniqueId property.

Gets and sets the unique id of the worksheet.

Adds enum IconSetType.ColorSmilies3 and IconSetType.Smilies3.

Represents the 3smiles icon set conditional formattings. Only for .ods file.s

Adds enum TimePeriodType.LastYear,TimePeriodType.NextYear and ThisYear.

Represents the last year, next year and this year conditional formattings. Only for .ods files.

Adds WorksheetCollection.RefreshPivotTables() method.

Refreshing all pivottables in the file.