Aspose.Cells for .NET 23.1 Release Notes

KeySummaryCategory
CELLSNET-50111Support interruption while calculating formulasNew Feature
CELLSNET-52496Support to change the default style of row/column without changing the style settings of existing cellsNew Feature
CELLSNET-52505Support new functions HSTACK/VSTACKNew Feature
CELLSNET-52429Support to get the author and date time of revisionsNew Feature
CELLSNET-52337Support CHOOSECOLS and CHOOSEROWS Excel 365 formulasEnhancement
CELLSNET-52498Enhance SaveOptions.HasHeaderRow when convert xlsx to jsonEnhancement
CELLSNET-52499JSON value is missing when a sheet is emptyEnhancement
CELLSNET-52500JsonSaveOptions.SkipEmptyRows is not working properlyEnhancement
CELLSNET-52502Always export excel as JObject when converting excel to jsonEnhancement
CELLSNET-52418Shape fill is not right while converting to pdfBug
CELLSNET-52420Shapes and pictures are deformed in Excel to PDF rendering after copying sheetBug
CELLSNET-52437Incorrect shadow when converting image to pdfBug
CELLSNET-52494Arrow sign shift error when converting Excel file to PDFBug
CELLSNET-52442SUMIF returns 4 instead of 0 by Aspose.Cells formula calculation engineBug
CELLSNET-52441Image converted by chart is not same as MS excelBug
CELLSNET-52486Security Vulnerability - CVE-2021-24112Bug
CELLSNET-52410Image to SVG - Text is overlapped for the horizontal bar for Date labels of the chart imageBug
CELLSNET-52366Thicker lines and missing border when saving XLSB to an ImageBug
CELLSNET-52395Excel file (XLS) is corrupted upon re-saving via Aspose.CellsBug
CELLSNET-52435Support filter criteria when opening and saving htmlBug
CELLSNET-52440The range of the pivottable is not same as MS Excel when converting pivittable to pdfBug
CELLSNET-52458The contents and formatting of the sheets are changed while copyingBug
CELLSNET-52493Exception “Item has already been added. " on saving XLS to XLSXBug
CELLSNET-48991Object reference not set to an instance of an object. exception when open ODS fileException
CELLSNET-52419Index out of range exception occurs after copying sheet and converting to pdfException
CELLSNET-52433Exception “File is corrupted” when loading an XLSX file having a hyperlinkException

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 PivotGlobalizationSettings class.

The class manages all globalization settings about pivot table.

Removes GlobalizationSettings.GetOtherName() method.

This method has not been referenced any more, it takes no effect even user implements it in GlobalizationSettings. So we remove it now. User should use ChartGlobalizationSettings.GetOtherName() method instead.

Removes GlobalizationSettings.GetColumnLablesName()/GetRowLablesName() methods.

Please use PivotGlobalizationSettings.GetTextOfColumnLabels()/GetTextOfRowLabels().

Obsoletes all methods about pivot table in GlobalizationSettings.

Please use corresponding methods in PivotGlobalizationSettings.

Adds GetStyle()/SetStyle() methods for Row and Column class.

Supports to get/set custom style for the whole Row/Column. For setting custom style, the difference between SetStyle() and ApplyStyle() is that SetStyle() does not change the style settings for existing cells.

Adds HasCustomStyle property for Cell, Row and Column classes.

Indicates whether the cell, row or column has been set with custom style settings(different from the default one it inherits).

Obsoletes Row.Style and Column.Style properties

Please use Row.GetStyle() and Column.GetStyle() instead.

Adds JsonSaveOptions.AlwaysExportAsJsonObject property.

Indicates whether always export Excel files as Json object even if there is only one worksheet.

Adds RevisionHeader class and RevisionLog.MetadataTable property.

Supports getting and setting properties of revision log.

Adds Style.GetTwoColorGradientSetting() method and obsoletes Style.GetTwoColorGradient() method.

Use Style.GetTwoColorGradientSetting() method instead.

Obsoletes JsonUtility.ExportRangeToJson(Range,ExportRangeToJsonOptions) and adds JsonUtility.ExportRangeToJson(Range, JsonSaveOptions)

Use ExportRangeToJson(Range, JsonSaveOptions) method instead.

Adds Charts.Axis.CustomUnit property.

Specifies a custom value for the display unit.

Obsoletes Charts.Axis.CustUnit property.

Please use Charts.Axis.CustomUnit instead.

Adds Charts.Chart.PlotVisibleCellsOnly property.

Indicates whether plot visible cells only.

Obsoletes Charts.Chart.PlotVisibleCells property.

Please use Charts.Chart.PlotVisibleCellsOnly instead.

Removes ShapeFormat.FillFormat property.

Please use ShapeFormat.Fill property instead.

Removes ShapeFormat.Outline property.

Please use ShapeFormat.Line property instead.