Format : IPrxTableIslandFormat;
The Format property determines relational area formatting parameters.
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: