Aspose.Cells for .NET 24.7 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 behavior of Cells.ExportDataTable() methods

In old versions, when one cell’s value is numeric and needs to be exported as string, we output it as raw literal of its value without formatting(so it is locale-independent).

Since 24.7, such kind of value will be exported as formatted string which is locale-dependent by default.

To get the raw value, please use ExportTableOptions with CellValueFormatStrategy.None to export data. For example, with old version the exporting code:

            cells.ExportDataTable(0, 0, 10, 3);

with the new versions please change it to:

            ExportTableOptions opts = new ExportTableOptions();
            opts.FormatStrategy = CellValueFormatStrategy.None;
            cells.ExportDataTable(0, 0, 10, 3, opts);

Adds AbstractCalculationEngine.ForceRecalculate(string functionName) method

Forces the custom function be recalculated always when calculating shared formulas, even if its parameters do not change for different cells of the same shared formula. By default this method returns false.

Adds Picture.PlaceInCell() method

Place picture which is over cell in cell.

Adds Shape.IsDecorative property

Indicates whether the shape is decorative.

Adds JsonLoadOptions.KeptSchema property

Inicates whether keeping JSON shcema when loading JSON file.

Adds PivotTableCalculateOption class

Rerepsents the options of calcuating the pivot table.

Adds PivotTable.CalculateData(Pivot.PivotTableCalculateOption) method

Calcuating pivot table with options.

Adds SlicerCacheItemSortType.Natural enum

No sorting.

Adds SaveFormat.Azw3 enum

Represents Azw3 file.

Adds EbookSaveOptions(SaveFormat saveFormat) constructor

Creates options for saving ebook file with SaveFormat.Epub or SaveFormat.Azw3.

Obsolete AxisBins.ResetOverflow() and AxisBins.ResetUnderflow() method

This is an internal method that does not need to be called externally to avoid causing problems.

Obsolete properties of ChartDataTable: HasBorderHorizontal, HasBorderVertical and HasBorderOutline

Please use properties HasHorizontalBorder, HasVerticalBorder and HasOutlineBorder instead.

Adds ChartDataTable.HasHorizontalBorder property

True if the chart data table has horizontal cell borders.

Adds ChartDataTable.HasVerticalBorder property

True if the chart data table has vertical cell borders.

Adds ChartDataTable.HasOutlineBorder property

True if the chart data table has outline borders.

Obsolete ChartPoint.InnerRadiusPx property

Please use ChartPoint.DoughnutInnerRadius property instead.

Adds ChartPoint.DoughnutInnerRadius property

Gets the inner radius of doughnut slice in units of pixels after calls Chart.Calculate() method. Applies to Doughnut chart.

Adds DataLabels.ApplyFont() method

Apply the font of the datalabels to all child nodes.

Adds Series.XValuesFormatCode property

Represents format code of X Values’s NumberList.

Obsolete SeriesCollection.ChangeSeriesOrder(Int32,Int32) method

Please use SeriesCollection.SwapSeries(Int32,Int32) method instead.

Adds SeriesCollection.SwapSeries(Int32,Int32) method

Directly changes the orders of the two series.

Adds SparklineGroupCollection.Add(Charts.SparklineType) method

Adds a SparklineGroup with a Sparkline to the collection.

Removes obsolete ChartDataTable.Background property

Please use ChartDataTable.BackgroundMode property instead.

Adds Cells.GetCellsWithPlaceInCellPicture() method.

Gets all cells that contain embedded picture.

Adds ConversionUtility class.

Represents utility to convert files to other formats.

Adds Cell.PutValue(DateOnly) and Cell.PutValue(TimeOnly) methods.

Enters DateOnly and TimeOnly values to the cell. Only applies to since NET 6.

Adds GridJsWorkbook.JsonToStream(Stream stream, string filename) .

Write JSON of the file to the stream.

Adds GridJsWorkbook.JsonToStreamByUid(Stream stream, string uid, string filename).

Write JSON of the file from the cache by the specified unique id to the stream.