Aspose.Cells for PHP via Java 25.10 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 Java. If you have concerns about any change listed, please raise it on the Aspose.Cells support forum.

Adds enum ShapePathPointValueType.

Specifies the value type of ShapePathPoint object.

Adds ShapePathPoint.Type property.

Specifies the value type (position coordinate or angle marker) of the current object.

Adds ShapePathPoint.XPixel/YPixel properties.

When the object is a position coordinate, get or set the x/y coordinate in pixels.

Adds ShapePathPoint.XAngle/YAngle properties.

When the object is an angle marker, get or set the first/second angle in degrees.

Obsoletes ShapePathPoint.X/Y property.

Please use ShapePathPoint.XPixel/YPixel or XAngle/YAngle instead in units of pixels/degrees accordingly.

Obsoletes ShapePathPointCollection.Add method.

Please use the MoveTo, LineTo, CubicBezierTo and ArcTo methods of ShapePath instead.

Obsoletes WorkbookDesigner.Process(Range,Boolean) method and WorkbookDesigner.LineByLine property.

Please use range smart marker instead. In order to process all smart markers of a range before the version 25.8, the range must be named as _CellsSmartMarkers and WorkbookDesigner.LineByLine must be false.

For example: if we need to process all smart markers in the range A1:D4, in the old versions, we have to name the range A1:D4 as _CellsSmartMarkers and LineByLine as false, then we can process them together; Starting from 25.8, we only need to set the first smart marker in the range as &=table.column1(range:A1:D4).

Adds WorkbookDesigner.SortDataSource property.

Indicates whether to sort data source. Only works for JSON data source now.

Adds WorkbookSettings.SmartTagOptions property.

Gets the default settings for smart tags.

Adds PasteOptions.KeepOldTables property.

Indicates whether to keep tables in the destination range.

Adds MarkdownLoadOptions class.

Represents the options for loading markdown document.

Adds enum ChartColorPaletteType.

Enumerates all Monochromatic Palettes used in Excel chart.

Adds method SeriesCollection.ChangeColors(ChartColorPaletteType type).

Sets Monochromatic Palette for chart series.

Changes default date format for the Japan locale.

For default date format(built-in number 14 for the number formatting), old versions of Microsoft Exce use the pattern of “yyyy/MM/dd” to format date value. But in Office 365, Excel uses the pattern of “yyyy/M/d” instead. Since some users require the same result as in Office 365, starting from 25.9 we use “yyyy/M/d” to format date by default.

Adds FileFormatType.FlatOpc enum.

Represents Microsoft Flat Opc Document file format.

Adds OoxmlSaveOptions.AsFlatOpc, PptxSaveOptions.AsFlatOpc and DocxSaveOptions.AsFlatOpc properties.

Indicates whether to save as Flat Opc file.

Obsoletes WorkbookDesigner.ContainsVariables property and adds WorkbookDesigner.VariablesWorksheetName property.

Use WorkbookDesigner.VariablesWorksheetName property to set which worksheet contains Variables.

Adds SaveElementType enum and DocxSaveOptions.SaveElementType property.

Represents what should be saved to docx file.

Adds DocxSaveOptions.EmbedXlsxAsChartDataSource and PptxSaveOptions.EmbedXlsxAsChartDataSource properties.

Indicates whether to embed an xlsx file as data source of the chart.

Adds PptxSaveOptions.SaveAsEditableShapes property.

Indicates whether to save editable shapes or images to pptx.

Adds HtmlEmbeddedFontType enum and HtmlSaveOptions.EmbeddedFontType property.

Represents the embedded font type in html.

Adds MarkdownSaveOptions.ExportHyperlinkAsReference property.

Indicates whether to export hyperlink using reference definitions instead of inline format.

Adds MarkdownSaveOptions.AlignColumnPadding property.

Gets or sets the character used to pad cell content for aligning columns.

Changes behavior of Workbook.CalculateFormula(…) methods for refreshing dynamic array formulas.

Dynamic array formulas are becoming more and more popular in more and more users’ cases. Old versions of Aspose.Cells required users to call Workbook.RefreshDynamicArrayFormulas(…) explicitly before calling Workbook.CalculateFormula() if there are dynamic array formulas that need to be refreshed. Starting from 25.10, we include this step into Workbook.CalculateFormula(…) automatically. So users do not need to explicitly call Workbook.RefreshDynamicArrayFormulas(…) anymore before calculating formulas for the workbook.

Adds property RefreshDynamicArrayFormula for CalculationOptions.

Indicates whether dynamic array formulas in a workbook should be refreshed automatically when using this CalculationOptions to calculate formulas.

Adds property UserSpecifiedRefreshDynamicArrayFormula for CalculationOptions.

Indicates whether user has specified CalculationOptions.RefreshDynamicArrayFormula property explicitly. If true, then use the specified value to determine whether to refresh dynamic array formulas. If false, whether refresh dynamic array formulas depends on what kind of formulas need to be calculated with this CalculationOptions. If it is to calculate formulas for the whole workbook, then dynamic array formulas will be refreshed automatically. If it is to calculate formulas for one cell or worksheet, then dynamic array formulas will not be refreshed.

Adds SignificantDigitsType enum.

Represents the type of significant digits for outputting numeric values.

Adds SignificantDigitsType property for WorkbookSettings and CellsHelper.

Indicates how to control the significant digits when outputing numeric values.

Obsoletes SignificantDigits property of WorkbookSettings and CellsHelper.

Uses SignificantDigitsType instead.

Adds property SplitTablesByBlankRow for MarkdownSaveOptions.

Indicates whether blank rows in the worksheet should be treated as table separators when exporting to Markdown.

Adds property WorkbookSettings.MaxUniqueItemsPerField.

Represents the limitation of unique items per pivot field.