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 popup 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 have the ability to add choices to this menu by programming. To do so, use ..PopupMenu.
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.

Setting

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). See Configuring the menu of AAFs for more details.
- "Add a popup menu": If this option is checked, you will have the ability to select the custom popup menu to display.

Remarks:

If both options are checked, the custom popup menu can be added before or after the menu of AAFs.
If no option is selected, no popup menu will be selected. The <Disabled> option will be displayed in the description window.
..PopupMenu is also used to delete the popup menu specific to AAFs and to restore the standard Windows menu for a specific 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 option named "Export to Excel"

The default operating mode of the export to Excel can be configured by AAFConfigure (or ConfigureAAF).