Aspose.Cells for .NET 22.3 Release Notes

CELLSNET-50375Support sorting PivotField via values in selected row/columnNew Feature
CELLSNET-50559Support to get cell’s leafs recursivelyNew Feature
CELLSNET-50512Support to re-calculate cells which reference to defined name when the defined name is changed and calculation chain is enabledEnhancement
CELLSNET-50403Add SaveFormat.Ots and SaveFormat.XltEnhancement
CELLSNET-50422Support setting inside bodersEnhancement
CELLSNET-50342Pivot table not sorting on refreshBug
CELLSNET-50451Deleting worksheet deletes SlicersBug
CELLSNET-50462Regression: After copying range of cells formulas are lostBug
CELLSNET-50545Conditionally formatted fields are not colored in the right colorBug
CELLSNET-50565Formulas were not calculated correctlyBug
CELLSNET-50309Range to PNG: output not as expectedBug
CELLSNET-50334Regression: XLS to PDF: header not rendered correctlyBug
CELLSNET-50367Converting .XLSX to PDF takes long time and produces extra pagesBug
CELLSNET-50401Numeric values or numbers followed by line items are not visible in the resultant pdfBug
CELLSNET-50478Workbook.ExportXml returns only first row of Table dataBug
CELLSNET-50507Xml Import unhides previously hidden columns in templateBug
CELLSNET-50554Content is not rendered properly in Excel to PDF conversionBug
CELLSNET-50316Wrapped Texts do not work on Charts when generating PDFBug
CELLSNET-50411Horizontal axis labels of chart are not rendered properly in the output PDFBug
CELLSNET-50341Issue with Collapse and Expand multi level groupsBug
CELLSNET-50368ODS to PDF conversion incorrectBug
CELLSNET-50377Custom “Text” formatting is not applied in the XLS fileBug
CELLSNET-50380ImportTableOptions.IsHtmlString property is not outputting links correctlyBug
CELLSNET-50418Load HTML in workbook not workingBug
CELLSNET-50494Issue with color for conditionally formatted cells in the output XLSX fileBug
CELLSNET-50563Issue when setting embedded license to Produce Single file in .NET 6.0 applicationBug
CELLSNET-50585No forward slashes but backward slashes for external links with URLBug
CELLSNET-50390System.ArgumentException: Row number or column number cannot be zero when importing JSON data as tableException
CELLSNET-50555ArgumentOutOfRangeException while trying to get Formula of a cellException

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.

Changes the default value of HtmlSaveOptions.ExcludeUnusedStyles.

When saving html files, for old versions sometimes we remove the unused styles automatically when there are many style objects in the pool, no matter what’s the value of this property. For the generated html files, excluding unused styles can make the file size smaller without affecting the visual effects. So from this version we make the default value of this property as true to make it consistent with the saving behavior. If user needs to keep all styles in the workbook for the generated html(such as the scenario that user needs to restore the workbook from the generated html later), please set this property as false while saving html.

Adds Cell.GetLeafs(bool recursive) method.

Support user to get all leafs of one cell recursively.

Adds Range.SetInsideBorders(BorderType, CellBorderType, CellsColor) method.

Support to set inside borders for the range.

Adds SaveFormat.Ots,SaveFormat.Xlt and LoadFormat.Ots enum.

Enhancement for loading and saving ots and xlt files.

Adds FormulaSettings class.

Separate all formula-related settings from WorkbookSettings and group them as FormulaSettings.

Adds WorkbookSettings.FormulaSettings property.

Gets the grouped settings for formulas.

Adds PivotItem.IsHideDetail property.

Gets and Sets whether the pivot item hides detail.

Obsoletes WorkbookSettings.ReCalculateOnOpen property.

Please use WorkbookSettings.FormulaSettings.CalculateOnOpen instead.

Obsoletes WorkbookSettings.RecalculateBeforeSave property.

Please use WorkbookSettings.FormulaSettings.CalculateOnSave instead.

Obsoletes WorkbookSettings.ForceFullCalculate property.

Please use WorkbookSettings.FormulaSettings.ForceFullCalculation instead.

Obsoletes WorkbookSettings.PrecisionAsDisplayed property.

Please use WorkbookSettings.FormulaSettings.PrecisionAsDisplayed instead.

Obsoletes WorkbookSettings.CalcMode property.

Please use WorkbookSettings.FormulaSettings.CalculationMode instead.

Obsoletes WorkbookSettings.Iteration property.

Please use WorkbookSettings.FormulaSettings.EnableIterativeCalculation instead.

Obsoletes WorkbookSettings.MaxIteration property.

Please use WorkbookSettings.FormulaSettings.MaxIteration instead.

Obsoletes WorkbookSettings.MaxChange property.

Please use WorkbookSettings.FormulaSettings.MaxChange instead.

Obsoletes WorkbookSettings.CalculationId property.

Please use WorkbookSettings.FormulaSettings.CalculationId instead.

Obsoletes WorkbookSettings.CreateCalcChain property.

Please use WorkbookSettings.FormulaSettings.EnableCalculationChain instead.

Obsoletes WorkbookSettings.CalcStackSize property.

Please use CalculationOptions with the specified stack size instead when calculating formulas.