Spreadsheet control events

AYUDA EN LÍNEA
WINDEV, WEBDEV Y WINDEV MOBILE

Versión:

Inicio | Iniciar sesión | Español

Este contenido se ha traducido automáticamente. Haga clic aquí para ver la versión en inglés.

Ayuda / Desarrollar una aplicación o un sitio web / Controles, ventanas y páginas / Controles: tipos disponibles / Control Hoja de cálculo

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

WINDEV

WEBDEV

WINDEV Mobile

Otros

Ver también

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 include processing that is too slow or allows the field 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 modify this runtime order:

On the "Ventana" tab, in the "Orden" group, click "Inicialización".
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.
Note: Several optional events can be selected.
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.
Note: If the deactivated 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.

Ver también

The Spreadsheet control

Versión mínima requerida

Versión 20

Esta página también está disponible para…

Comentarios

Haga clic en [Agregar] para publicar un comentario

Última modificación: 30/09/2024

Señalar un error o enviar una sugerencia | Ayuda local