Browse our Products

Aspose.Cells for .NET 25.1.1 Release Notes

KeySummaryCategory
CELLSNET-57607Support to ignore the calculation of custom functions to keep the original spilled range and values of dynamic array formulasNew Feature
CELLSGRIDJS-1366Support row/column insert/delete event for client apiNew Feature
CELLSGRIDJS-1368Support pre-check event for row/column delete/insert operationNew Feature
CELLSGRIDJS-1393Support js event for updating cellNew Feature
CELLSGRIDJS-1395Support api to show html node and interact with html node at specified cell positionNew Feature
CELLSGRIDJS-1337Support diffrent decimal separator for diffrent locale settingNew Feature
CELLSNET-54281Support saving autoshapes and free shapes to ods fileEnhancement
CELLSNET-57494Support to get expression of external table reference while calculating formulas with user’s custom engineEnhancement
CELLSNET-57503Support to calculate external table reference when external workbook source has been setEnhancement
CELLSNET-57254Aspose.Cells for .NET uses vulnerable dependencyEnhancement
CELLSNET-57440Improvements for trimming in Blazor WebAssembly publishingEnhancement
CELLSNET-57456Upgrade referenced SkiaSharp library to v3.116.1 for Blazor WebAssembly with net9.0 target frameworkEnhancement
CELLSNET-57492Support Format 2 subtable in cmap table of fontEnhancement
CELLSNET-57485Support CSS custom properties when conveting file to htmlEnhancement
CELLSNET-57429Reimplement API of pivot conditional fomatttingEnhancement
CELLSNET-57541Support reading and writing Forms setting in the TableEnhancement
CELLSNET-57550Simplify importing of list of rows data into cellsEnhancement
CELLSGRIDJS-1396Support searching for filter listEnhancement
CELLSGRIDJS-1397Add an option to display formula tips and modify the default behavior to not display them by defaultEnhancement
CELLSGRIDJS-1409Support multiple instances in one pageEnhancement
CELLSGRIDJS-1432Support show total count for filter itemsEnhancement
CELLSGRIDJS-1410Optimize the logic of the validation failure popup button to be consistent with Excel.Enhancement
CELLSNET-57486Shape to image error when saving file to pdfBug
CELLSNET-57407Issue of Equal filtering in non English environmentsBug
CELLSNET-5741130 2310469658 was trimed and parsed as numeric value 30Bug
CELLSNET-57608TEXTSPLIT function was not calculated correctly when there is row separator onlyBug
CELLSNET-57609The result of HYPERLINK function is incorrect for value types other than stringBug
CELLSNET-57418Solve the problem of text clipped and line breaks in bar chartBug
CELLSNET-57460Strikethrough style lost when converting chart to xpsBug
CELLSNET-57461Double strikethrough style lost when converting chart to xpsBug
CELLSNET-57469Certain values in the chart not rendered fine in the chart to image conversionBug
CELLSNET-57501Extra text is printed in chartBug
CELLSNET-57565Fix Area background color error in chartBug
CELLSNET-55926Published Blazor WASM App unable to load WorkbookBug
CELLSNET-55946Error setting license in AOT Blazor AppBug
CELLSNET-56800XLSX to PDF: Chinese fonts are not applied in PDF fileBug
CELLSNET-57462The position of the text strikethrough line becomes lower when converting file to xpsBug
CELLSNET-57463Text italics and bold styles are lost when converting file to xpsBug
CELLSNET-57573Font name in the generated pdf is garbled while converting workbook to pdfBug
CELLSNET-57405The result file is corrupted after calling workbook.CalculateFormula()Bug
CELLSNET-57408Invalid refreshed result of filtering by Date EqualBug
CELLSNET-57427Pivot table conditional formatting not workingBug
CELLSNET-57432After pivot replacement wrong data source was shownBug
CELLSNET-57471Conditional format is not same as in MS excelBug
CELLSNET-57472PivotFilter is not being applied when adding filter to pivot table to filter “(blank)” valueBug
CELLSNET-57487Charts overlap with the tables when saving file bytes to xlsxBug
CELLSNET-57516INDIRECT function failed due to case sensitivity in table column namesBug
CELLSNET-57540Data misalignment when exporting data to DataTableBug
CELLSNET-57548Font size and font style getting changed after saving Excel fileBug
CELLSNET-57549The generated xlsx file is corrupted after converting an ods fileBug
CELLSNET-57583Invalid pivot formatBug
CELLSNET-57613The smart tags in the template file are still retained after calling WorkbookDesigner.Process(false)Bug
CELLSGRIDJS-1335Issues with percentage formatting and decimal separatorBug
CELLSGRIDJS-1373Issue with Text InputBug
CELLSGRIDJS-1374Unnecessary Border Lines Between ColumnsBug
CELLSGRIDJS-1405Vertical alignment settings are appliedBug
CELLSGRIDJS-1408Data validation issueBug
CELLSGRIDJS-1411Fix the error in the decimal validation check.Bug
CELLSGRIDJS-1375Render conditional style issueBug
CELLSGRIDJS-1388HTML page input text box get affected by GridJsBug
CELLSGRIDJS-1406Formulas are not removed when deleting cells with formulasBug
CELLSGRIDJS-1412Fail to importExcelFileFromJson in GridJs java version for json string with merge areaBug
CELLSNET-57446NullReferenceException occurs when importing json as data source of smartmarkerException

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.

The referenced SkiaSharp version for net6.0, net8.0 and net9.0.

In Aspose.Cells for.NET 25.1.1, we have upgraded the referenced SkiaSharp for net6.0, net8.0, and net9.0 to version 3.116.1. This upgrade aims to enhance rendering output and improve compatibility with net9.0. However, the SkiaSharp 3.116.1 requires GLIBC_2.29, which may not be available on certain systems. So, in Aspose.Cells for.NET 25.1.2, we revert the referenced SkiaSharp to version 2.88.9 for net6.0 and net8.0. For net9.0, the referenced SkiaSharp remains unchanged at version 3.116.1.

Adds new method AutoFilter.GetCellArea(bool refreshAppliedRange).

Supports getting the refreshed/re-calculated range of auto filter according to current cells data.

Adds new method AbstractCalculationEngine.SkipCalculation().

Supports skipping the calculation for the entire formula that references to the function currently under evaluation.

Adds HtmlSaveOptions.EnableCssCustomProperties Property.

Optimizes the output of html by using CSS custom properties. For example, in scenarios where there are multiple occurences for a base64 image(IconSets or Pattern style), using custom properties allows the image data to be saved only once, improving the performance of the resultant HTML.

Adds Workbook.CreateStyle(Boolean) method.

Creates a style with an option to clone the default style.

Adds PivotArea.SelectField() method.

Selects a pivot area that contains a field.

Adds PivotArea.GetCellAreas() method.

Converts a pivot area to cell areas.

Adds PivotAreaCollection class.

Represents a list of pivot areas.

Adds PivotConditionalFormat and PivotConditionalFormatCollection classes, obsoletes PivotFormatCondition and PivotFormatConditionCollection classes.

Use PivotConditionalFormat and PivotConditionalFormatCollection instead.

Obsoletes PivotTable.RefreshDataFlag property.

It’s no longer used. Please remove any calls to it.

Obsoletes PivotTable.Move() method and adds PivotTable.MoveTo() method.

Use PivotTable.MoveTo() instead.

Obsoletes PivotTable.GetHorizontalBreaks() and adds PivotTable.GetHorizontalPageBreaks() method.

Use PivotTable.GetHorizontalPageBreaks() instead.

Obsoletes PivotTable.ColumnGrand and adds PivotTable.ShowColumnGrandTotals property.

Use PivotTable.ShowColumnGrandTotals instead.

Obsoletes PivotTable.RowGrand and adds PivotTable.ShowRowGrandTotals property.

Use PivotTable.ShowRowGrandTotals instead.

Obsoletes PivotTable.IsMultipleFieldFilters and adds PivotTable.AllowMultipleFiltersPerField property.

Use PivotTable.AllowMultipleFiltersPerField instead.

Obsoletes PivotTable.PivotFormatConditions and adds PivotTable.ConditionalFormats property.

Use PivotTable.ConditionalFormats instead.

Removes obsolete properties of Protection.

IsDeletingColumnsAllowed -> AllowDeletingColumn
IsDeletingRowsAllowed -> AllowDeletingRow
IsFilteringAllowed -> AllowFiltering
IsFormattingCellsAllowed -> AllowFormattingCell
IsFormattingColumnsAllowed -> AllowFormattingColumn
IsFormattingRowsAllowed -> AllowFormattingRow
IsInsertingColumnsAllowed -> AllowInsertingColumn
IsInsertingHyperlinksAllowed -> AllowInsertingHyperlink
IsInsertingRowsAllowed -> AllowInsertingRow
IsSortingAllowed -> AllowSorting
IsUsingPivotTablesAllowed -> AllowUsingPivotTable
IsEditingContentsAllowed -> AllowEditingContent
IsEditingObjectsAllowed -> AllowEditingObject
IsEditingScenariosAllowed -> AllowEditingScenario
IsSelectingLockedCellsAllowed -> AllowSelectingLockedCell
IsSelectingUnlockedCellsAllowed -> AllowSelectingUnlockedCell