IPrxTableIslandFormat.Conditions

Syntax

Conditions : IPrxFormatConditions;

Description

The Conditions property determines parameters of conditional data formatting.

Example

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

Sub User;

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;

//setting minimum value

ValFormat.MinValueType := TabFormatValueType.Lowest;

ValFormat.MinValueColor := GxColor.FromName("Red");

//setting maximum value

ValFormat.MaxValueType := TabFormatValueType.Highest;

ValFormat.MaxValueColor := GxColor.FromName("Blue");

TI.Save;

End Sub User;

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

See also:

IPrxTableIslandFormat