PC SOFT

WINDEVWEBDEV AND WINDEV MOBILE
ONLINE HELP

Home | Sign in | English UK
This content comes from an automatic translation.
  • Overview
  • Setting
  • Setting 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
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadApple WatchUniversal Windows 10 AppWindows Mobile
Others
Stored procedures
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:
G Thanks to this menu, the user gains in autonomy and can carry out treatments that were 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

Setting the automatic menu in a Table control

The context menu of a Table control can of course be disabled.. To set 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 requested menu in the "Popup Menu" combo box. You can:
    • "Display the menu of AAF (System)": In this case, the context menu displayed will be the Table control automatic menu (ASF Menu). 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.
  • The ..PopupMenu property also allows you to delete the context menu specific to FAA and to find the classic Windows menu for a specific field.
WINDEVWindows

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

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).
Minimum version required
  • Version 11
This page is also available for…
Comments
Click [Add] to post a comment