Format: IPrxTableIslandFormat;
The Format property determines formatting parameters for a relational data area group.
The following example assumes that there is the Report object with the IPrxReport type.
Sub User;
Var
Report : IPrxReport;
TabIs : IPrxTableIslands;
TI : IPrxTableIsland;
Grs : IPrxTableIslandGroupings;
Gr : IPrxTableIslandGrouping;
LayFormat : IPrxTableIslandFormat;
Format : IPrxFormatConditions;
TabFormat : ITabFormatCondition;
ValFormat : ITabFormatValues;
Begin
TabIs := Report.TableIslands;
TI := TabIs.Item(0);
TI := TI.Edit;
Grs := TI.Groupings;
Gr := Grs.Item(0);
LayFormat := Gr.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 group: style - two color gradient.
See also: