Express > Express Assembly Interfaces > IEaxGrid > IEaxGrid.Transposed

IEaxGrid.Transposed

Syntax

Transposed: Boolean;

Description

The Transposed property determines whether the table is transposed.

Comments

Available values:

True. The table is transposed, that is, rows were turned to columns and columns were turned to rows.
False. The tale is not transposed.

Selected table elements and collections of dimensions located by rows (IPivot.LeftHeader) and by columns (IPivot.TopHeader) will also be transposed.

NOTE. Transposition of dimension collections arranged in rows and columns is unavailable in the row mode of the time series database represented in the Analytical Queries (OLAP) tool.

Example

Executing the example requires a form with a button on it named Button1, the TabSheetBox component and the UiErAnalyzer component named UiErAnalyzer1, which is used as a data source.

Sub Button1OnClick(Sender:Object; Args: IMouseEventArgs);
Var
    Analyzer: IEaxAnalyzer;
    Grid: IEaxGrid;
Begin
    Analyzer := UiErAnalyzer1.ErAnalyzer;
    Grid := Analyzer.Grid;
    Grid.AdjustMode := EaxAdjustMode.ColumnsThenRows;
    Grid.Transposed := True;
End Sub Button1OnClick;

After executing the example the table and element selection in the table are transposed. See below example of a table before (upper image) and after (lower image) transposition: