ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

This content has been translated automatically.  Click here  to view the French version.
Help / Developing an application or website / Controls, windows and pages / Controls: Available types / Pivot Table control
  • Events managed by default in a window
  • Events managed by default in a report
  • Optional events (window control)
WINDEV
WindowsLinuxJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadIOS WidgetApple WatchMac Catalyst
Others
Stored procedures
Events managed by default in a window
The following events appear by default in the WINDEV code editor:
EventRuntime condition
InitializingExecuted when the window is opened. *
EntryExecuted when the control gains focus.
ExitExecuted when a field is changed (TAB key, changing a field with the mouse, etc.).
Displaying a cellExecuted when the result is displayed in a cell.
Select a cellExecuted when selecting a cell (with the mouse for example)

(*) 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:
  1. On the "Window" tab, in the "Order" group, click "Initialization".
  2. In the window that appears, use the arrows on the right to change the order in which the controls are initialized.
Events managed by default in a report
The following events appear by default in the WINDEV code editor:
EventRuntime condition
InitializingExecuted when initializing the report.
Before printingExecuted before the control is printed.
Before printing the cellsRun before printing a cell found in the Pivot Table control. This event is used to handle the value of the cell of the Pivot Table control before printing.
When creating a Pivot Table report, a control representing the cell is created. The name of this control starts with "VAL_".
You have the ability to modify the properties of this control (color, background color, ...) according to its value:
IF VAL_TCD > 400 THEN
	VAL_TCD.Couleur = LightGreen
	VAL_TCD.CouleurFond = LightRed
END
Optional events (window control)
Several optional events can be managed by a Pivot Table control in a window. To add an optional event:
  1. Select the desired control.
  2. Display the code window of this control (F2 key).
  3. Click the link "Add other events to xxx" at the bottom of the window code, after the last event.
  4. All the optional events available for the control are displayed.
  5. Check the optional event to add and validate.
    Note: Several optional events can be selected.
  6. 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.
Minimum version required
  • Version 18
Comments
Click [Add] to post a comment

Last update: 09/21/2024

Send a report | Local help