ReportBox.OnBeforeDeleteRange

Syntax

Sub OnBeforeDeleteRange(Sender: Object; Args: IReportRangeDeleteEventArgs);

Begin

//set of operators;

End Sub OnBeforeDeleteRange;

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 OnBeforeDeleteRange event occurs before removing ranges/rows/columns.

Comments

After removing ranges/rows/columns the ReportBox.OnAfterDeleteRange event occurs.

Example

Executing the example requires a form that contains the ReportBox component with the ReportBox1 identifier and the UiReport component with the UiReport1 identifier. Specify the UiReport1 component as a data source for the ReportBox1 component. In the OperationMode property of the UiReport1 specify Edit.

Sub ReportBox1OnBeforeDeleteRange(Sender: Object; Args: IReportRangeDeleteEventArgs);
Begin
Debug.WriteLine("Range will be removed: " + Args.Range.Address +
" by means of: " + Args.ShiftDirection.ToString + " from sheet: " + Args.Sheet.Name);
End Sub ReportBox1OnBeforeDeleteRange;

After executing the example on each adding range/rows/columns to table, the console window displays a message with the information:

Execution result.
Removed range address.
Type of ranges/rows/columns removal.
A sheet, from which ranges/rows/columns must be removed.