Automatic menu of tables (AAF)

ONLINE HELP
WINDEV, WEBDEV AND WINDEV MOBILE

Version:

WINDEV

WEBDEV

WINDEV Mobile

Others

Automatic menu of tables (AAF)

Overview

Each Table control found in a window proposes a menu to the user.

This menu, available without programming, proposes several actions:

Export to Word or to OpenOffice (depending on the software installed on the user computer).
Export to Excel or to OpenOffice Calc (depending on the software installed on the user computer).
Export to XML.
Copy the row or the table.
Create a chart for representing data.
Print the table (see AAF for printing a table).
Select several table columns:

To simplify the menu, only the first 32 columns are visible in the menu. Furthermore, only the columns with a title are proposed.

Example of chart automatically generated by the context menu of a Table control:

This menu allows the user to easily perform several processes not necessarily planned in the application:

Export to an external Excel, Word or XML file.
Ability to display or hide the columns (to limit the size of the menu, only the first 32 columns are displayed).
Automatically generate a chart from the data found in a table.
Remark: you cannot select the columns that will be included in the chart. To choose some specific table columns, we advise you to create a new chart from the Table control displayed in a window.

Remarks:

You can add options to this menu from the code. To do so, use the PopupMenu property.
When exporting a table via the popup menu, the merge of columns is ignored.
Horizontal table: The menu of AAFs does not contain the options used to perform an export to an external Excel, Word or XML file.

Settings

Configuring the automatic menu in a Table control

The popup menu of a Table control can be disabled. To configure the display of the Table control popup menu, you must:

Open the Table control description window.
Select the "UI" tab.
Choose the desired menu in the "Popup Menu" combo box. You can:
- "Display the menu of AAF (System)": In this case, the popup menu displayed will be Table control automatic menu (Menu of AAFs). For more details on how to configure this menu, see Configuring the AAF menu.
- "Add a popup menu": If this option is checked, you can select the custom context menu to be displayed.

Remarks:

If both options are checked, the custom context menu can be added before or after the AAF menu.
If no option is selected, no context menu will be selected. The <Disabled> option will be displayed in the description window.
The PopupMenu property is also used to remove the AAF-specific context menu and restore the standard Windows menu for a given control.

Configuring the "Select columns..." option

In some case, you may not want to give the user the ability to hide the columns. To do so, the "Select columns..." option can be enabled or disabled:

Configuring the default behavior of the "Export to Excel" option

You can configure the default behavior of the "Export to Excel" option using AAFConfigure.