UiReport.OnBeforeRecalcSheet

Syntax

Sub OnBeforeRecalcSheet(Sender: Object; Args: IUiPrxSheetCancelEventArgs);

Begin

//set of operators;

End Sub OnBeforeRecalcSheet;

Parameters

Sender. The parameter that returns the component that generated the event.

Args. The parameter that enables the user to determine event parameters.

Description

The OnBeforeRecalcSheet event occurs before calculating the report sheet.

Example

Executing the example requires that unit is connected as event handler.

Public Sub OnBeforeRecalcSheet(Sheet: IPrxSheet; Var Cancel: Boolean);
Var
    Sheets : IPrxSheets;
Begin
    If Sheet.Name = "Sheet2" Then
        Sheets := Sheet.Sheets;
        Sheets.FindByName("Sheet3").Recalc;
    End If;
End Sub OnBeforeRecalcSheet;

After executing the example on updating the sheet named Sheet2, the sheet named Sheet3 will be updated.