Aspose.Cells for .NET 23.9 Release Notes

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 CustomFunctionDefinition class

The abstract class to support user to specify some special settings for custom functions by implementing it.

Adds Workbook.UpdateCustomFunctionDefinition(CustomFunctionDefinition definition) method

Supports to update all formulas which reference to custom functions according to user’s custom definition for them.

Adds FormulaParseOptions.CustomFunctionDefinition property

Supports to parse formula with user’s custom definition for custom functions.

Adds overloaded Worksheet.CalculateFormula(…) method

Supports to parse and calculate given formula with custom options and other conditions.

Adds overloaded Worksheet.CalculateArrayFormula(…) method

Supports to parse and calculate given formula as array formula with custom options and other conditions.

Adds Worksheet.ConvertFormulaReferenceStyle(string formula, bool toR1C1, int baseCellRow, int baseCellColumn) method

Converts the reference style between R1C1 and A1 for the given formula.

Adds CellValue class

Represents the cell value and corresponding type.

Adds virtual method ExportTableOptions.PreprocessExportedValue(int cellRow, int cellColumn, CellValue value)

Provides user the ability of checking and replacing some special cell types and values when exporting.

Adds Dispose() method for SheetRender and WorkbookRender

Provides user the ability to explicitly release resources created during rendering.

Adds EbookLoadOptions and EbookSaveOptions class

Represents options when importing/exporting an ebook file.

Adds GridDesktop.SetCustomResourceManager(ResourceManager customResourceManager) method

Sets custom resource manager to implement user defined localization.

Adds GridWeb.DPI property

Gets and Sets the DPI of the machine.

Adds FileFormatType.Epub, LoadFormat.Epub, SaveFormat.Epub enum

Represents an EPUB file.

Adds Chart.FilteredNSeries property

Represents the data series collection that are not selected in the chart.

Adds Series.IsFiltered  property

Supports to filter the series in the chart. True represents this series is filtered, and it will not be displayed on the chart.

Adds CommentTitleType.Note and Reply enum type

Represents comment title note and reply.

Obsolete CellsHelper.ConvertR1C1FormulaToA1()/ConvertA1FormulaToR1C1() methods

Please use Worksheet.ConvertFormulaReferenceStyle() method instead.

Obsolete PdfSecurityOptions.ExtractContentPermissionObsolete property

Please use PdfSecurityOptions.ExtractContentPermission property instead.

Adds TableStyleCollection.DefaultTableStyleName and TableStyleCollection.DefaultPivotStyleName properties.

Gets and sets the default style name of the table and pivot.

Adds WorksheetCollection.RefreshAll() method.

Refreshes all Pivottables and Pivot Charts.

Adds Validation.GetValue() mthod.

Gets the result of validation in the cell.