Aspose.Cells for .NET 24.3 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.

Removes obsolete indexer Cells[int].

Please use Cells.GetEnumerator() method to iterate all cells.

Removes obsolete method Cells.FindFormula(string formula, Cell previousCell).

Please use Cells.Find(object,Cell,FindOptions) method instead, with LookInType.OnlyFormulas and LookAtType.EntireContent.

Removes obsolete method Cells.FindFormulaContains(string formula, Cell previousCell).

Please use Cells.Find(object,Cell,FindOptions) method instead, with LookInType.OnlyFormulas and LookAtType.Contains.

Removes obsolete property Range.CellCount.

Please use Range.RowCount and Range.ColumnCount to get total cells count instead.

Removes obsolete property Row.Style.

Please use Row.GetStyle() method instead.

Removes obsolete property WorkbookSettings.ParsingFormulaOnOpen.

Please use LoadOptions.ParsingFormulaOnOpen property instead.

Removes obsolete properties of WorkbookSettings about formula.

Please use properties of FormulaSettings instead.

Removes obsolete property of FilterColumn.Visibledropdown.

Please use FilterColumn.IsDropdownVisible property instead.

Removes obsolete class ICustomFunction and related apis referencing to it.

Please use AbstractCalculationEngine and CalculationOptions.CustomEngine instead for:

CalculationOptions.CustomFunction
Workbook.CalculateFormula(bool, ICustomFunction)
Worksheet.CalculateFormula(bool, bool, ICustomFunction)
Cell.Calculate(bool, ICustomFunction)

Obsolete method Cells.GetCell(int row, int column).

Please use Cells.CheckCell(int row, int column) instead.

Obsolete method Cells.GetRow(int rowIndex).

Please use Cells.CheckRow(int rowIndex) instead.

Removes obsolete methods of importing data for Cells.

Please use ImportData(IDataReader, int, int, ImportTableOptions) instead of below methods:

Import(IDataReader, int, int, ImportTableOptions)
ImportFromDataReader(SqlDataReader, int, int, bool)
ImportDataReader(SqlDataReader, int, int, bool)
ImportFromDataReader(SqlDataReader, bool, int, int, bool)
ImportDataReader(SqlDataReader, bool, int, int, bool)
ImportFromDataReader(SqlDataReader, bool, int, int, bool, string, bool)
ImportDataReader(SqlDataReader, bool, int, int, bool, string, bool)
ImportFromDataReader(OleDbDataReader, bool, int, int, bool, string, bool)
ImportDataReader(OleDbDataReader, bool, int, int, bool, string, bool)
ImportFromDataReader(OleDbDataReader, bool, int, int, bool)
ImportDataReader(OleDbDataReader, bool, int, int, bool)
ImportFromDataReader(OleDbDataReader, int, int, bool)
ImportDataReader(OleDbDataReader, int, int, bool)
ImportDataReader(IDataReader, bool, int, int, bool, string, bool)

Please use ImportData(DataTable, int, int, ImportTableOptions) instead of below methods:

ImportDataTable(DataTable, bool, string)
ImportDataTable(DataTable, bool, int, int, bool, bool)
ImportDataTable(DataTable, bool, int, int)
ImportDataTable(DataTable, bool, int, int, bool)
ImportDataTable(DataTable, bool, int, int, int, int)
ImportDataTable(DataTable, bool, int, int, int, int, bool, string)
ImportDataTable(DataTable, bool, int, int, int, int, bool, string, bool)
ImportDataTable(DataTable, bool, int, int, int, int, bool)

Please use ImportData(DataView, int, int, ImportTableOptions) instead of below methods(If IsFieldNameShown parameter has not been specified in the old methods, please specify it as false for ImportTableOptions for the new method):

ImportDataView(DataView, int, int, bool)
ImportDataView(DataView, int, int, int, int)
ImportDataView(DataView, bool, int, int, bool)
ImportDataView(DataView, int, int, int, int, bool)
ImportDataView(DataView, bool, int, int, int, int, bool)
ImportDataView(DataView, bool, int, int, int, int, bool, string)

Removes obsolete properties about formula for WorkbookSettings.

ParsingFormulaOnOpen
PrecisionAsDisplayed
ReCalculateOnOpen
CreateCalcChain
ForceFullCalculate
Iteration
MaxIteration
MaxChange
CalcMode
CalculationId
CalcStackSize
RecalculateBeforeSave

Please use corresponding properties of FormulaSettings instead.

Removes obsolete property DataLabels.Separator and corresponding enum DataLablesSeparatorType.

Please use DataLabels.SeparatorType and corresponding enum DataLabelsSeparatorType instead.

Obsoleted OdsSaveOptions.IsStrictSchema11 property.

Use OdsSaveOptions.OdfStrictVersion property instead.

Adds OdsSaveOptions.OdfStrictVersion property.

The generated ods files complie with the strict of ODF.

Adds MergeEmptyTdType enum.

Represents the merge type for empty TD element when exporting file to html.

Adds HtmlSaveOptions.MergeEmptyTdType property.

The option to merge contiguous empty cells(empty td elements).

Obsoleted HtmlSaveOptions.MergeEmptyTdForcely property.

Use HtmlSaveOptions.MergeEmptyTdType property instead.

Adds TickLabelAlignmentType enum.

Represents the text alignment type for the tick labels on the axis.

Adds TickLabels.AlignmentType property.

Gets and sets how to align the tick labels of the axis.

Adds FileFormatType.Azw3, LoadFormat.Azw3 enum.

AZW3 format.

Adds PivotItem.IsMissing property.

Indicates whether this item does not exist in the data source of pivot table.