FormatConditionsSetup Command

Purpose

Opens a standard dialog box that is used to set up conditional format parameters.

Parameters of Use

Command parameters are passed in the Data property. Executing the command requires to specify an array of the Variant type in this property, the elements of this array contain the following values:

Value type	Description
Element 1: ITabSheet	The page containing the cell range.
Element 2: ITabRange	The cell range, for which the dialog box for setting up conditional data formatting parameters is to be opened. If the parameter is not specified, the system opens a dialog box to set up conditional formatting parameters for the currently selected cell range.

Application Features

The command is used only for regular reports.

Example

Executing the example requires a form with the Button1 button, the ReportBox component and the UiReport component named UiReport1, which is used as a data source for the ReportBox component.

    Sub Button1OnClick(Sender: Object; Args: IMouseEventArgs);
    Var
        Sheet: ITabSheet;
        Target: IUiCommandTarget;
        Context: IUiCommandExecutionContext;
        Data: Array;
    Begin
        Sheet := (UiReport1.Instance As IPrxReport).ActiveSheet As ITabSheet;
        Target := WinApplication.Instance.GetPluginTarget("Report");
        Context := Target.CreateExecutionContext;
        Data := New Variant[2];
        Data[0] := Sheet;
        Data[1] := Sheet.ParseRange("A0:C10");
        Context.Data := Data;
        Target.Execute("FormatConditionsSetup", Context);
    End Sub Button1OnClick;

Clicking the button opens a standard dialog box that is used to set up conditional data formatting parameters for the A0:C10 cell range on the current sheet of the regular report connected in the UiReport1 component.