Automatic menu of tables (AAF)

WINDEV, WEBDEV AND WINDEV MOBILE
ONLINE HELP

Version:

Home | Sign in | English

Overview
Setting
Configuring the automatic menu in a Table control
Configuring the "Select the columns..." option
Configuring the default behavior of the option named "Export to Excel"

WINDEV

WEBDEV

WINDEV Mobile

Others

See also

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 requested 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 can also be used to delete the popup menu specific to the AAFs and to go back to the standard Windows menu for a specific control.

Configuring the "Select the columns..." option

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

Open the description window of Table control.
Select the "Details" tab.
Check or uncheck "Menu 'Select the columns...'".

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).