Aspose.Cells for Go via CPP 26.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 Go via C++. If you have concerns about any change listed, please raise it on the Aspose.Cells support forum.

Changes the behavior of updating formulas in other sheets when deleting row(s)/column(s).

In old versions, when deleting row(s)/column(s) in one worksheet(for apis such as Cells.DeleteRow(int)/DeleteColumn(int), DeleteRows(int, int)/DeleteColumns(int, int, DeleteOptions), InsertRow(int)/InsertColumn(int)…), those formulas in other sheets will not be updated automatically by default, unless users explicitly specify the “updateReference” parameter or property as true. This default behavior was designed for performance consideration, but it did not match the operations in ms excel and had caused trouble and confusion for users. Staring from 26.7, by default we will update all formulas in all worksheets for operations of inserting/deleting row(s)/column(s). That is, we set the default value of “updateReference”(including the properties of DeleteOptions.UpdateReference and InsertOptions.UpdateReference) to true. This change will provide convenience to users and deliver expected result with no need of extra settings.

Obsoletes and adds some methods in FilterColumn class.

Obsoletes:

For filter of MultipleFilters type, the returned object in old versions is MultipleFilterCollection. Starting from 26.7, use FilterColumn.GetFilterValues(), and FilterValueCollection is returned. Please note, this property has been obsoleted for a long time and will be removed soon, so please use the new apis accordingly(using corresponding property according to the filter type).

Adds:

Provides access to the collection of filter values used in the filter criteria.

Selects all filter values for the filter column.

Adds new enum SaveFormat.Ofd.

OFD (Open Fixed-layout Document)

Adds new class OfdSaveOptions.

Supports saving to Open Fixed-layout Document(OFD).

Adds new enum HyperlinkLoadMode.

Specifies how hyperlinks are handled when loading HTML.

Adds two methods in HtmlLoadOptions class.

Specifies how hyperlinks are handled when loading HTML.

Adds four methods in Style class.

Gets the border setting of the style.

Obsoletes one method in WorksheetCollection class.

Please use (instance *Workbook) RefreshAll() instead.

Adds one method in Workbook class.

Refresh linked shapes, all pivot tables and charts with pivot source.

Adds eight methods in SparklineGroup class.

Set the max and min value of vertical axis with type.

Adds one method in PivotAreaFilter class.

Gets the index of the field which this filter refers to.

Adds and obsoletes some methods in PivotTable class

Add:

Gets all PivotTables which are in the source of this pivot table.

Clears all pivot filters of pivot table.

Remove all fields from regions.

Obsoletes:

Use (*PivotTable) GetDependentPivotTables() method instead.

Adds two members in FileFormatType.

Represents an OTG file.

Represents an Odb file.

Adds two methods in PowerQueryFormulaItem.

Gets the text value of the item.

Gets the type of this item (Function, Parameter, List, Literal, or Unknown).

Adds new enum PowerQueryFormulaItemType.

Represents the type of a Power Query formula item.

Adds two methods in Slicer.

Selects the specified items of slicer.

Removes all filters applied to the slicer.

Adds one method in ListColumnCollection.

Removes the ListColumn at the specified index.

Adds two methods in Worksheet.

Indicates whether to show data type icons.

Adds enum ShapeDisplayType.

Represents how the application displays shapes in this workbook. Shapes might include charts, images, and other object data that the application supports.

Adds one method in CustomFilterCollection class.

Supports defining a custom filter with two criteria and a logical relationship.

Adds one method in ShapeCollection class.

Allows copying a shape with additional copy options.

Adds new enum member FileFormatType::Ofd.

Represents the OFD (Open Fixed Layout Document) file format. Only for detecting.

Adds new class FilterValue.

Encapsulates a single filter value, including its type, string value, and date time group item.

Adds new class FilterValueCollection.

Collection that stores multiple FilterValue objects.

Adds one method in MultipleFilterCollection class.

Gets the number of filter values in the collection.

Adds two methods in HtmlSaveOptions class.

Specifies how whitespace is rendered in HTML output (character entities or CSS).

Adds new enum HtmlSpaceMode.

Defines the possible whitespace rendering modes for HTML.

Adds four methods in PdfSaveOptions class.

Control the initial view mode and zoom percentage when opening the generated PDF document.

Adds new abstract class PivotCache.

Provides a memory cache for PivotTable reports, exposing the source type and refresh functionality.

Adds new class PivotCacheCollection.

Represents the collection of PivotCache objects in a workbook.

Adds three methods in PivotTable class.

Gets the PivotCache associated with the pivot table.

Calculates pivot data using the specified calculation options and returns the affected pivot tables.

Retrieves all pivot tables that share the same pivot cache.

Adds two methods in PivotTableCalculateOption class.

Indicates whether to refresh the data source to the pivot cache.

Adds one method in Slicer class.

Unselects the specified items in the slicer.

Adds two methods in Timeline class.

Retrieves the selected date time range of the timeline.

Selects a date time range on the timeline with an optional calculation flag.

Adds one method in WorksheetCollection class.

Provides access to the collection of PivotCache objects in the worksheet collection.