Browse our Products

Aspose.Cells for .NET 24.3 Release Notes

KeySummaryCategory
CELLSNET-55244Support to calculate EVALUATE functionNew Feature
CELLSNET-55089Support top10 filter for GridDesktopNew Feature
CELLSNET-55090Support date filter for datetime for GridDesktopNew Feature
CELLSNET-55212Support text filter for GridDesktopNew Feature
CELLSNET-55130Array formula and shared formula should not be allowed when setting them changes part of existing array formulaEnhancement
CELLSNET-55077Improve richtext edit for GridWebEnhancement
CELLSNET-55163Support richtext edit at formula editor boxEnhancement
CELLSNET-54288Support Excel Add-In (JavaScript) - Investigation requiredEnhancement
CELLSNET-55207Process the navigation link when converting AZW3 to xlsxEnhancement
CELLSNET-55137How to align x-axis values/labels to the leftEnhancement
CELLSNET-55143Convert Excel spreadsheet to ods with odf 1.3 standardEnhancement
CELLSGRIDJS-1013Add more formulas in insert menu and help tipsEnhancement
CELLSGRIDJS-1026Formula menus list shall display in orderEnhancement
CELLSGRIDJS-1028Add categorization feature to formula menu in gridjsEnhancement
CELLSGRIDJS-1029Automatically set cells to date format when creating formulas related to creation datesEnhancement
CELLSNET-55215The ratios of width and height do not change simultaneously when Picture.IsLockAspectRatio is set to trueBug
CELLSNET-55122Data shift failed after calling InsertRange methodBug
CELLSNET-55151Save doubles with different precision between net5.0+ and net48 target frameworksBug
CELLSNET-55210ISERROR function returns false for NPER #NUM! errorBug
CELLSNET-55223Calling recalculation on the workbook produces “#VALUE!” errorBug
CELLSNET-55243Formula not calculated correctlyBug
CELLSNET-55120Chart data errors after calling Chart.Calculate()Bug
CELLSNET-55117Raise exception when switch to the first sheet for the customer’s file in GridWeb .NET CoreBug
CELLSNET-55118Page size does not work as expected in GridWeb .net coreBug
CELLSNET-55134GridWeb is throwing invalid cast exception when switching the sheets with one of Excel workbooksBug
CELLSNET-55142Text disappears if the cell is having multi line text in GridWebBug
CELLSNET-55179The blank space contained in the cell content becomes shorter after click on the cell in GridWebBug
CELLSNET-55237GridDesktop crashes when selecting a rangeBug
CELLSGRIDJS-1023Exception when loading fileBug
CELLSNET-55140The vertical text spacing in PDF B does not match the spacing in Excel.Bug
CELLSNET-55164Page layout error when converting files to imagesBug
CELLSNET-55186Importing Xml with line breaks into a table does not format correctlyBug
CELLSNET-55201The bold and italic style has been passed to the next paragraph of text when saving file to pdfBug
CELLSNET-55203The position of the line break in the ‘Request section’ is different with ExcelBug
CELLSNET-55205Paging error occurred when saving to PdfBug
CELLSNET-55059Fail to import html file with svg imageBug
CELLSNET-55111Line break is incorrect in the output xlsx after set html string into cellBug
CELLSNET-55138Issue with MergeEmptyTdForcely Option in HtmlSaveOptionsBug
CELLSNET-55149HTML line break is not being respectedBug
CELLSNET-55160Exporting XLSX file to HTML is corrupted and has a gibberish prefixBug
CELLSNET-55217The underline contained in the text is lost when converting the file to HTMLBug
CELLSNET-55115While pivoting the Excel sheet, some of the rows in the date column are showing as numberBug
CELLSNET-55121External DDE link data source is not replaced after setting new valueBug
CELLSNET-55136Venture License: CellsException - You are using an evaluation copy and have opened files exceeding limitation.Bug
CELLSNET-55144Detect a simple text file as json file.Bug
CELLSNET-55150Cell references change failed after copying WorksheetBug
CELLSNET-55156Randomly corrupting Excel files on saveBug
CELLSNET-55157Invalid shared formulas returns when loading Excel5 fileBug
CELLSNET-55172M4a file is detected as CSV when passing it as streamBug
CELLSNET-55184Unable to replace date formatted textBug
CELLSNET-55185Some Coditional formatting lost when converting to odsBug
CELLSNET-55193Mp4 file is detected as CSV when passing it as streamBug
CELLSNET-55200Picture in cell is missing after resaving the sample fileBug
CELLSNET-55218The result file crashes when resaving xlsm and using SaveFormat.AutoBug
CELLSGRIDJS-1009The height of the insert formula menu is out of the boundary of the menuBug
CELLSNET-55132Insert/Delete operations cause exception when the updated range intersects with existing dynamic array formulaException
CELLSNET-55188CalculateFormula throws NullReferenceException after copying into a cell rangeException
CELLSNET-54923Loading XSLX file raises NullReferenceExceptionException
CELLSNET-55180Invalid end column index exception on CreateRange functionException
CELLSNET-55255Exception “Index was outside the bounds of the array” when loading XLS files via streamException

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.

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.