PC SOFT

ONLINE HELP
FOR WINDEV, WEBDEV AND WINDEV MOBILE

Home | Sign in | English US

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
Allows you to specify the behavior of some Automatic Application Features (AAF). You can for example configure the option for exporting to Excel used by the automatic menu of tables.
Note: this function is equivalent to AAFConfigure.
Example
// Configures the mode for exporting the content of Table control to Excel
ConfigureAAF(aafTableToExcel, taWithLayout)

// With combination of options:
ConfigureAAF(aafTableToExcel, taColumnsTitles + taColumnDisplayedOrder + taWithLayout)
Syntax
<Result> = ConfigureAAF(<Relevant AAF> , <Parameter>)
<Result>: Variant
Former value of AAF setting.
<Relevant AAF>: Integer constant or combination of Integer constants
Constant corresponding to the AAF to configure:
Versions 23 and later
aafToastDurationRestoreFilter
New in version 23
aafToastDurationRestoreFilter
aafToastDurationRestoreFilter
Configures the display duration for the toast indicating the restoring of filters stored by the user on a Table control.
Reminder: The user can store the filters defined on a column of Table control via "Store the filter" from the popup menu.
Affected element: Table control
Versions 21 and later
aafPrintReportOnTable
New in version 21
aafPrintReportOnTable
aafPrintReportOnTable
Configures the print of report on Table control. The formatting of cells (colors, ...) defined in the Table control is stored when using TablePrint.
Affected element: Table control
Versions 19 and later
aafInternetSearch
New in version 19
aafInternetSearch
aafInternetSearch
Configures the engine used to perform the search on Internet. The search engine used by default is Google.
Affected element:
  • Edit control
  • Versions 23 and later
    Table control, TreeView Table control, Spreadsheet control and Pivot Table control
    New in version 23
    Table control, TreeView Table control, Spreadsheet control and Pivot Table control
    Table control, TreeView Table control, Spreadsheet control and Pivot Table control
Versions 15 and later
aafDirectoryTableExport
New in version 15
aafDirectoryTableExport
aafDirectoryTableExport
Configures the default directory where the export file will be created.
Versions 15 and later
aafColumnSelection
New in version 15
aafColumnSelection
aafColumnSelection
Selection of visible columns via the popup menu of Table control.
Affected element: Table control
Versions 15 and later
aafTableToExcel
New in version 15
aafTableToExcel
aafTableToExcel
Exports the content of Table control or the selection performed in the control to Excel.
Affected element: Table control
Versions 15 and later
aafTableToWord
New in version 15
aafTableToWord
aafTableToWord
Exports the content of Table control or the selection performed in the control to Word.
Affected element: Table control
aafTableToXMLExports the content of Table control or the selection performed in the control to XML.
Affected element: Table control
<Parameter>: Character string or Integer constant
Setting of AAF.
  • To configure the export to Excel, Word or XML, use the following constants:
    taWithInvisibleColumnsAlso exports the invisible columns of Table control.
    taWithLayoutExports the color and font of Table control.
    taColumnDisplayedOrderExports the columns according to the order of columns currently displayed in the Table control (and not according to the order of columns defined in the editor).
    taMergeOnly if the XLS file already exists.
    Merges the existing content with the new content:
    • The formulas, the formatting, ... of existing cells are stored.
    • The existing data is not stored. Only the data of columns found as well in the existing XLS file is stored.
    taSelectedLinesExports the selected rows only (all the rows are exported by default). Does not export the totals.
    taNoTitleOnly the data is copied into the export file.
    taNoTotalDoes not export rows with totals, average or automatic count (these rows are exported by default).
    taColumnsTitlesThe title of columns is inserted into the export file.
  • To configure the selection of visible columns, <Parameter> is an integer indicating the number of columns in the Table control from which the popup menu remains displayed after a user selection. This parameter is set to 4 by default.
  • To configure the export directory, <Parameter> is a string corresponding to the directory path.
  • Versions 19 and later
    To configure the search engine used for the Internet search, <Parameter> is a string corresponding to the command line of search engine. Some examples:
    • Google: "http://www.google.com/#q=%1"
    • Bing: "http://www.bing.com/search?q=%1"
    • Yahoo: "http://fr.search.yahoo.com/search?p=%1"
    If <Parameter> = "" (empty string), the default engine will be used (Google).
    New in version 19
    To configure the search engine used for the Internet search, <Parameter> is a string corresponding to the command line of search engine. Some examples:
    • Google: "http://www.google.com/#q=%1"
    • Bing: "http://www.bing.com/search?q=%1"
    • Yahoo: "http://fr.search.yahoo.com/search?p=%1"
    If <Parameter> = "" (empty string), the default engine will be used (Google).
    To configure the search engine used for the Internet search, <Parameter> is a string corresponding to the command line of search engine. Some examples:
    • Google: "http://www.google.com/#q=%1"
    • Bing: "http://www.bing.com/search?q=%1"
    • Yahoo: "http://fr.search.yahoo.com/search?p=%1"
    If <Parameter> = "" (empty string), the default engine will be used (Google).
  • Versions 21 and later
    To configure the report print (especially how the formatting of cells is stored), <Parameter> is an integer set to 1.
    New in version 21
    To configure the report print (especially how the formatting of cells is stored), <Parameter> is an integer set to 1.
    To configure the report print (especially how the formatting of cells is stored), <Parameter> is an integer set to 1.
  • Versions 23 and later
    To configure the display duration of stealth message (filters in Table controls), <Parameter> indicates the display time expressed in hundredths of a second. This duration is set to 7 seconds by default. This parameter can correspond to:
    • an integer corresponding to the number of hundredths of a second,
    • a Duration variable,
    • the indication of duration in clear ('1s' or '10 cs' for example).
    • -1 to use the default duration.
    New in version 23
    To configure the display duration of stealth message (filters in Table controls), <Parameter> indicates the display time expressed in hundredths of a second. This duration is set to 7 seconds by default. This parameter can correspond to:
    • an integer corresponding to the number of hundredths of a second,
    • a Duration variable,
    • the indication of duration in clear ('1s' or '10 cs' for example).
    • -1 to use the default duration.
    To configure the display duration of stealth message (filters in Table controls), <Parameter> indicates the display time expressed in hundredths of a second. This duration is set to 7 seconds by default. This parameter can correspond to:
    • an integer corresponding to the number of hundredths of a second,
    • a Duration variable,
    • the indication of duration in clear ('1s' or '10 cs' for example).
    • -1 to use the default duration.
Components
WINDEVReports and Queries wd230obj.dll
Minimum required version
  • Version 11
This page is also available for…
Comments
Click [Add] to post a comment