Aspose.Cells for .NET 20.1 Release Notes

CELLSNET-47026Support “Rank Smallest to Largest” and “Rank Largest to Smallest” display format optionNew Feature
CELLSNET-47030Display headings when saving into HTMLNew Feature
CELLSNET-47089Support all the data display formats of DataFieldNew Feature
CELLSNET-47062Support for STDEV.P and STDEV.SNew Feature
CELLSNET-47070Support for Regex in Replace function similar to Find() using optionsNew Feature
CELLSNET-46998Support for XAdES signaturesNew Feature
CELLSNET-40174Inserting CheckBox in chart type sheetNew Feature
CELLSNET-43089Support for Conditional Formatting while converting ODS to XLSXNew Feature
CELLSNET-43090Support for Data Validation while converting ODS to XLSX formatNew Feature
CELLSNET-47064Support the shapes in the chart for .xlsx file.Enhancement
CELLSNET-47065Get PowerQuery from DataConnectionsEnhancement
CELLSNET-47066Fetch formatted PowerQuery MCode  similar to MS ExcelEnhancement
CELLSNET-47008Issue while rendering an image of a chart at a specific angleBug
CELLSNET-47063Render Excel to printer issue when fonts are not installedBug
CELLSNET-44237Descend ordering of the PivotTable’s DataFieldBug
CELLSNET-47002The calculated value is shown as “#REF!” in resultant PDFBug
CELLSNET-47050Some fields on the first page do not appear in the output PDFBug
CELLSNET-40733Open Office .ods file - the conditional formatting doesn’t stayBug
CELLSNET-47039XY Scatter charts in ODS file are not rendered fineBug
CELLSNET-47040Net charts in ODS file are not rendered fineBug
CELLSNET-47060Support custom XY of title in ods fileBug
CELLSNET-47072The difference in the Link path fetched by Aspose.Cells when compared with ExcelBug
CELLSNET-47087Have a problem when printing the excel file that saved by Aspose.Cells for .NETBug
CELLSNET-47082Calculation of formula hangsBug

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 ReplaceOptions.RegexKey property.

Indicates whether the searched key is regex. If true then the searched key(to be replaced part) will be taken as a user-specified regex.

Adds CustomImplementationFactory.CreateCultureInfo method.

Some cultures may not be supported by the user’s environment. To avoid the exception for such situations, user may override this method to provide a valid CultureInfo instance instead.

Deletes obsolete ValidationCollection.Add(Aspose.Cells.Validation) method.

Use ValidationCollection.Add(CellArea) method instead.

Adds PowerQueryFormula.FormulaDefinition property.

Gets the definition of the power query formula.

Adds DBConnection.PowerQueryFormula property.

Gets the definition of power query formula.

Adds HtmlSaveOptions.ExportHeadings property.

Indicates whether exporting headings when saving the file to HTML. The default value is false. If you want to import the HTML file to excel, please keep the default value.

Adds XAdESType class

Type of XML Advanced Electronic Signature (XAdES).

Adds DigitalSignature.XAdESType property

Gets and sets the type of XML Advanced Electronic Signature (XAdES). The default value is None(XAdES is off).