IPrxTableIslandLayout.Format

Syntax

Format : IPrxTableIslandFormat;

Description

The Format property determines relational area formatting parameters.

Example

The following example assumes that there is the Report object with the IPrxReport type.

Sub Main;
Var
    Report : IPrxReport;
    TabIs : IPrxTableIslands;
    TI : IPrxTableIsland;
    Layout : IPrxTableIslandLayout;
    LayFormat : IPrxTableIslandFormat;
    Format : IPrxFormatConditions;
    TabFormat : ITabFormatCondition;
    ValFormat : ITabFormatValues;
Begin
    TabIs := Report.TableIslands;
    TI := TabIs.Item(
0);
    TI := TI.Edit;
    Layout := TI.Layout;
    LayFormat := Layout.Format;
    Format := LayFormat.Conditions;
    TabFormat := Format.Add;
    TabFormat.Type := TabConditionType.Values;
    ValFormat := TabFormat.Details 
As ITabFormatValues;
    
//two color gradient for cell formatting
    ValFormat.Style := TabFormatValuesStyle.TwoColorScale;
    
//minimum value configuration
    ValFormat.MinValueType := TabFormatValueType.Lowest;
    ValFormat.MinValueColor := GxColor.FromName(
"Red");
    
//maximum value configuration
    ValFormat.MaxValueType := TabFormatValueType.Highest;
    ValFormat.MaxValueColor := GxColor.FromName(
"Blue");
    TI.Save;
End Sub Main;

After executing the example the following conditional formatting is set for the relational area: style - two color gradient.

See also:

IPrxTableIslandLayout