ReportEvents.OnCellChange

Syntax

OnCellChange (Sheet: IPrxSheet; Column: Integer; Row: Integer; Value: Variant);

OnCellChange (Sheet: Prognoz.Platform.Interop.Report.IPrxSheet; Column: integer; Row: integer; Value: object);

Parameters

Sheet. Report sheet generated event.

Column. Column generated event.

Row. Row generated event.

Value. Value of the cell generated event.

Description

The OnCellsChange method implements the event occurring on changing regular report cell value.

Comments

On calling the method, the IPrxReportUserEvents.EventOnCellChange event, that can be redefined, if required, is processed in parallel in core.

Example

Executing the example requires a regular report. Connect a unit to the regular report, select the connected unit an the EventsClass class as an event handler. Add links to the Report, Ui system assemblies in the unit.

Class EventsClass: ReportEvents
// Change cell value
Public Sub OnCellChange(Sheet: IPrxSheet; Column: Integer; Row: Integer; Value: Variant);
Begin
    WinApplication.InformationBox("Cell value is changed in column " + Column.ToString + " in row " + Row.ToString + " on sheet " + Sheet.Name + ". New value " + Value);
End Sub OnCellChange;
End Class EventsClass;

Imports Prognoz.Platform.Interop.Report;
Imports Prognoz.Platform.Interop.Ui;

Public Class EventsClass: PrxForeNetReportUserEventsClass
// Change cell value
    Public Override Sub OnCellChange(Sheet: Prognoz.Platform.Interop.Report.IPrxSheet; Column: integer; Row: integer; Value: object);
    Var
        WinAppCls: WinApplicationClass = New WinApplicationClassClass();
    Begin
        WinAppCls.InformationBox("Cell value is changed in column " + Column.ToString() + " in row " + Row.ToString() + " on sheet " + Sheet.Name + ". New value " + Value, Null);
    End Sub OnCellChange;
End Class EventsClass;

After changing the cell value in the regular report an information message is displayed.

See also:

ReportEvents