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

Changes the constant values for FormatConditionType

Constants defined for FormatConditionType have been changed. User’s applications need to be re-compiled with the new version of Aspose.Cells.

Adds HtmlSaveOptions.CalculateFormula property

If formulas in workbook need to be re-calculated to get correct result for generated html files, user may call Workbook.CalculateFormula() manually before Workbook.Save(), or specify this property as true to force formulas to be re-calculated automatically while saving HTML files.

Adds HtmlSaveOptions.FormatDataIgnoreColumnWidth property

Indicating whether show the whole formatted data of cell when overflowing the column.

Adds CellsHelper.NeedQuoteInFormula() method

Check whether the name of the sheet should be enclosed in single quotes when adding reference to the sheet.

Adds and obsoletes some ErrorCheckType enum

Use new enums instead.

Adds methods: GetShortTextOf12Months(),GetTextOf4Quaters(),GetTextOfYears(),GetTextOfQuarters(),GetTextOfMonths(), GetTextOfDays(),GetTextOfHours(),GetTextOfMinutes(),GetTextOfSeconds() and GetTextOfRange() of PivotGlobalizationSettings

Gets the local text of date time for pivot table.

Adds PivotFieldGroupSettings class and PivotField.GroupSettings property; obsoletes SxRng class and PivotField.SxRng property

Used PivotField.GroupSettings property instead.

Obsoletes PivotTable.SetUngroup() method and adds PivotField.Ungroup() method

Please use PivotField.Ungroup() method instead to ungroup the pivot field.

Obsoletes PivotTable.SetAutoGroupField() and SetManualGroupField() methods

Please use PivotField.GroupBy() method.

Adds PivotField.GroupBy() methods

Group the pivot field.

Adds Range.AddHyperlink() method

Add a hyperlink for the range.

Adds PivotFieldGroupType enum

Represents the group type of pivot field.

Adds CustomPiovtFieldGroupItem and PivotDiscreteGroupSettings classes

Represents the discrete group of the pivot field.

Adds PivotGroupByType.Numbers and obsoletes PivotGroupByType.RangeOfValues enum

Use PivotGroupByType.Numbers enum instead to group the pivot field by numberic values.

Adds PivotNumbericRangeGroupSettings class

Represents the settings of numberic groups for the pivot field.

Adds PivotDateTimeRangeGroupSettings class

Represents the settings of date time groups for the pivot field.

Adds ImageOrPrintOptions.EmfRenderSetting property

Setting for rendering Emf metafile while rendering to image.

Adds XpsSaveOptions.EmfRenderSetting property

Setting for rendering Emf metafile while rendering to XPS.

Adds PdfCompliance.Pdf14, Pdf15, Pdf16, Pdf17 enum

Supports to render to Pdf format compatible with PDF 1.4, 1.5, 1.6, 1.7.

Obsoletes PdfCompliance.None enum

Please use PdfCompliance.Pdf14 instead.

Obsoletes Legend.LegendEntriesLabels property and adds Legend.GetLegendLabels() method

Please use Legend.GetLegendLabels() method instead.

Adds GridPivotTableCollection.RemoveAt() method

Remove the PivotTable at the specified index in GridDesktop.

Adds GridSheetRender class

Represents a worksheet render which can render worksheet to various images such as (BMP, PNG, JPEG, TIFF..) in GridDesktop.

Adds GridImageOrPrintOptions class

Allows to specify options when rendering worksheet to images, printing worksheet or rendering chart to image in GridDesktop.

Adds GridSheetPrintingPreview class

Represents worksheet printing preview in GridDesktop.

Adds GridPdfSaveOptions class

Represents the options for saving pdf file in GridDesktop.

Adds  UnhideColumns()/UnhideRows() methods for GridCells

Unhides the hidden columns/rows in GridDesktop.