Transposed: Boolean;
The Transposed property determines whether the table is transposed. It is True when the table is transposed, that is, rows were turned to columns and columns were turned to rows; it is False when the table is not transposed.
When a table is transposed, element selection in the table and element collection in rows (IPivot.LeftHeader) and columns (IPivot.TopHeader) is also transposed.
NOTE. Transposition of dimension collections arranged in rows and columns is not available for the row mode of the time series database, represented in the Analytical Queries (OLAP) tool.
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 this 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:
See also: