Report > Report Assembly Classes > ReportBox > ReportBox.OnBeforeDeleteRange

ReportBox.OnBeforeDeleteRange

Syntax

OnBeforeDeleteRange(Sender: Object; Args: IReportRangeDeleteEventArgs);

Parameters

Sender. Parameter that returns the component that has 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.