IPivotTable

Assembly: Pivot;

Namespace: Prognoz.Platform.Interop.Pivot;

Description

The IPivotTable interface contains properties and methods that are used to work with table data.

Inheritance Hierarchy

IPivotTable

Comments

To work with the collection of data table variants, use the IPivotTables interface.

Properties

  Property name Brief description
The Cell property determines a table cell value.
The ColumnCount property returns the number of columns with data in the table.
The Coord property returns coordinate in the data matrix by table row or column index.
The DataRights property returns access permissions for data of the given cell.
The DataType property returns cell type.
The Highlight property returns whether data in a cell, which value corresponds to the specified condition, is highlighted.
The IsChanged property returns whether changed data is present in the table.
The IsChangedCell property returns whether changed data exists in the specified table cell.
The IsDataChanged property returns whether there is changed data by elements included into the specified selection.
The IsEditing property returns whether the table is in the edit mode.
The IsEvaluatedCell property returns whether this cell is calculated one.
The IsHighlighted property returns whether the data in a cell, which value corresponds to any set condition, is highlighted.
The IsStairCell property returns whether stepped hierarchy is used in a cell.
The LeftHeader property returns parameters of table row headers.
The RowCount property returns the number of rows with data in the table.
The Selection property returns table selection taking into account filtering.
The TopHeader property returns parameters of table column headers.

Methods

  Method name Brief description
The Cancel method exits the editing mode without saving made changes.
The Edit method switches the table into the data edit mode.
The GetSourceCoord method returns coordinate in the data matrix by table row and column index.
The Post method cancels the edit mode and saves changed table data.
The PostEx method exits the edit mode and saves changed table data with the ability to specify the data that will be excluded.

See also:

Pivot Assembly Interfaces