ITabFormatGrowth.Direction

Fore Syntax

Direction: TabFormatGrowthDirection;

Fore.NET Syntax

Direction: Prognoz.Platform.Interop.Tab.TabFormatGrowthDirection;

Description

The Direction property determines the direction of grows indicator construction.

Comments

By default the growth indicator is constructed according to the rows values.

Fore Example

To execute the example a form with the button on it named Button1, the TabSheetBox component named TabSheetBox1 name and a data source for TabSheetBox1 are required.

Sub Button1OnClick(Sender: Object; Args: IMouseEventArgs);
Var
    Tab: ITabSheet;
    Range: ITabRange;
    FormCond: ITabFormatCondition;
    Growth: ITabFormatGrowth;
Begin
    Tab := TabSheetBox1.Source.GetTabSheet;
    Range := Tab.View.Selection.Range;
    FormCond := Range.FormatConditions.Add;
    FormCond.Type := TabConditionType.Growth;
    Growth := FormCond.Details As ITabFormatGrowth;
    Growth.Direction := TabFormatGrowthDirection.Columns;
    Growth.IconType := TabConditionIconType.Arrows2;
End Sub Button1OnClick;

Clicking the buttons adds the conditional format for the selected cell range. Conditional formatting is performed as the grows indicator with values by columns.

Fore.NET Example

To execute the example a form with the button named Button1 on it, the TabSheetBoxNet component named TabSheetBoxNet1 name and a data source for TabSheetBoxNet1 are required.

Imports Prognoz.Platform.Forms.Net;
Imports Prognoz.Platform.Interop.Tab;

Private Sub button1_Click(sender: System.Object; e: System.EventArgs);
Var
    Tab: ITabSheet;
    Range: ITabRange;
    FormCond: ITabFormatCondition;
    Growth: ITabFormatGrowth;
Begin
    Tab := TabSheetBoxNet1.Source.GetTabSheet();
    Range := Tab.View.Selection.Range;
    FormCond := Range.FormatConditions.Add();
    FormCond.Type := TabConditionType.tctGrowth;
    Growth := FormCond.Details As ITabFormatGrowth;
    Growth.Direction := TabFormatGrowthDirection.tfgdColumns;
    Growth.IconType := TabConditionIconType.tcitArrows2;
End Sub;

Clicking the buttons adds the conditional format for the selected cell range. Conditional formatting is performed as the grows indicator with values by columns.