Spreadsheet control events

ONLINE HELP
WINDEV, WEBDEV AND WINDEV MOBILE

Version:

Home | Sign in | English

Help / Developing an application or website / Controls, windows and pages / Controls: Available types / Spreadsheet control

Default events
Spreadsheet control events in a window
Spreadsheet control events in a report
Optional events (in a window only)

WINDEV

WEBDEV

WINDEV Mobile

Others

See also

The Spreadsheet control

Spreadsheet control events

Default events

Spreadsheet control events in a window

The following events appear by default in the WINDEV code editor:

Event	Runtime condition

Initialization	Executed when the window is opened. *
Select a cell	Executed when the user selects a cell.
Modify a cell	Executed when the content of a cell is modified: when validating the cell content. when deleting the cell content. when copying the cell content via the "+" sign at the bottom right of the cell.
After loading a workbook	Executed after loading a workbook in the Spreadsheet control.
Before closing the workbook	Executed before closing the workbook in the Spreadsheet control.
Click on a link	Executed when a link in a Spreadsheet control cell is clicked. This event accepts parameters: `PROCEDURE ClickLink(sURL is string, bInNewWindow is boolean, sDestination is string)` where <sURL> is an optional string that contains the URL of the link clicked in the Spreadsheet control. If this event returns False, the action associated with the link will not be performed. Caution: the code must not contain slow processes or processes that allow the control to regain focus. In this case, the default action will still be performed.

(*) By default, the "Initialization" event of each control is executed according to the order in which the controls were created in the window. To change this order of execution:

On the "Window" tab, in the "Order" group, click "Initialization".
In the window that appears, use the arrows on the right to change the order in which the controls are initialized.

Spreadsheet control events in a report

The following events appear by default in the code editor of WINDEV and WEBDEV:

Event	Runtime condition

Initialization	Executed when the report is opened.
Before printing	Executed before the control is printed.
Before printing the cells	Executed before each cell of the Spreadsheet control is printed. This event is used to modify the cells of the Spreadsheet control. For more details, see Manipulating Spreadsheet controls programmatically (in a report).

For more details, see Events associated with the controls of a report.

Optional events (in a window only)

Several optional events can be added. To add an optional event:

Select the desired control.
Display the code window of this control (F2 key).
Click the link "Add other events to xxx" at the bottom of the window code, after the last event.
All the optional events available for the control are displayed.
Check the optional event to add and validate.
Remark: You can select several optional events.
The selected optional event is automatically added to the events managed by the control.

To disable an optional event, simply perform the same operations to display the list of optional events. Then simply uncheck the optional events to delete.
Remark: If the disabled code contains WLanguage code, this code is automatically deleted.

For example, you can use the following events:

the mouse hover over the control,
left mouse button down, up, double click,
right mouse button down, up, double click,
mouse wheel, etc.

For more details, see the Optional events.