ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Help / Automatic Application Features (AAF) / AAF on Tables/TreeView Tables
  • Overview
  • Settings
  • Configuring the automatic menu in a Table control
  • Configuring the "Select columns..." option
  • Configuring the default behavior of the "Export to Excel" option
WINDEV
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadIOS WidgetApple WatchMac CatalystUniversal Windows 10 App
Others
Stored procedures
Overview
Each Table control found in a window proposes a menu to the user.
This menu, available without programming, includes 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.
    Example of chart automatically generated by the context menu of a Table control:
  • 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.
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 ContextMenu property.
  • When exporting a table via the context 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 context menu of a Table control can be disabled. To configure the display of the Table control context menu, you must:
  1. Open the Table control description window.
  2. Select the "UI" tab.
  3. Choose the desired menu in the "Context menu" combo box. You can:
    • "Display the AAF menu (System)": In this case, the context 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 context 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 ContextMenu property is also used to remove the AAF-specific context menu and restore the standard Windows menu for a given control.
WINDEVWindows

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:
  1. Open the Table control description window.
  2. Select the "Details" tab.
  3. Check or uncheck "'Select columns...' menu".
WINDEVWindows

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

You can configure the default behavior of the "Export to Excel" option using AAFConfigure.
Minimum version required
  • Version 11
Comments
Click [Add] to post a comment

Last update: 01/16/2024

Send a report | Local help