ConfigureAAF (Function) In french: ParamètreFAA 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.
// 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:
<Parameter>: Character string or Integer constant Setting of AAF. - To configure the export to Excel, Word or XML, use the following constants:
| | taWithInvisibleColumns | Also exports the invisible columns of Table control. | taWithLayout | Exports the color and font of Table control. | taColumnDisplayedOrder | Exports 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). | taMerge | Only 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.
| taSelectedLines | Exports the selected rows only (all the rows are exported by default). Does not export the totals. | taNoTitle | Only the data is copied into the export file. | taNoTotal | Does not export rows with totals, average or automatic count (these rows are exported by default). | taColumnsTitles | The 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 laterTo 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 19To 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 laterTo configure the report print (especially how the formatting of cells is stored), <Parameter> is an integer set to 1. New in version 21To 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 laterTo set the display time of the stealth message (filters in the Table fields), <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,
- a duration in text format (e.g., '1 s' or '10 cs').
- -1 to use the default duration.
New in version 23To set the display time of the stealth message (filters in the Table fields), <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,
- a duration in text format (e.g., '1 s' or '10 cs').
- -1 to use the default duration.
To set the display time of the stealth message (filters in the Table fields), <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,
- a duration in text format (e.g., '1 s' or '10 cs').
- -1 to use the default duration.
This page is also available for…
|
|
|