Aspose.Cells for .NET 20.1 Release Notes
| Key | Summary | Category |
|---|---|---|
| CELLSNET-47026 | Support “Rank Smallest to Largest” and “Rank Largest to Smallest” display format option | New Feature |
| CELLSNET-47030 | Display headings when saving into HTML | New Feature |
| CELLSNET-47089 | Support all the data display formats of DataField | New Feature |
| CELLSNET-47062 | Support for STDEV.P and STDEV.S | New Feature |
| CELLSNET-47070 | Support for Regex in Replace function similar to Find() using options | New Feature |
| CELLSNET-46998 | Support for XAdES signatures | New Feature |
| CELLSNET-40174 | Inserting CheckBox in chart type sheet | New Feature |
| CELLSNET-43089 | Support for Conditional Formatting while converting ODS to XLSX | New Feature |
| CELLSNET-43090 | Support for Data Validation while converting ODS to XLSX format | New Feature |
| CELLSNET-47064 | Support the shapes in the chart for .xlsx file. | Enhancement |
| CELLSNET-47065 | Get PowerQuery from DataConnections | Enhancement |
| CELLSNET-47066 | Fetch formatted PowerQuery MCode similar to MS Excel | Enhancement |
| CELLSNET-47008 | Issue while rendering an image of a chart at a specific angle | Bug |
| CELLSNET-47063 | Render Excel to printer issue when fonts are not installed | Bug |
| CELLSNET-44237 | Descend ordering of the PivotTable’s DataField | Bug |
| CELLSNET-47002 | The calculated value is shown as “#REF!” in resultant PDF | Bug |
| CELLSNET-47050 | Some fields on the first page do not appear in the output PDF | Bug |
| CELLSNET-40733 | Open Office .ods file - the conditional formatting doesn’t stay | Bug |
| CELLSNET-47039 | XY Scatter charts in ODS file are not rendered fine | Bug |
| CELLSNET-47040 | Net charts in ODS file are not rendered fine | Bug |
| CELLSNET-47060 | Support custom XY of title in ods file | Bug |
| CELLSNET-47072 | The difference in the Link path fetched by Aspose.Cells when compared with Excel | Bug |
| CELLSNET-47087 | Have a problem when printing the excel file that saved by Aspose.Cells for .NET | Bug |
| CELLSNET-47082 | Calculation of formula hangs | Bug |
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).