|
|
|
|
|
|
|
|
|
|
ConfigureAAF (Function) In french: ParamètreFAA
 Warning
From version 22, It is recommended to use AAFConfigure. In fact, all AIF management functions functions are now grouped together in the same family of functions beginning with FAA.
ConfigureAAF(aafTableToExcel, taWithLayout)
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:
| | | aafToastDurationRestoreFilter | Configures the display duration for the toast indicating the restoring of filters stored by the user on a Table control.
Reminder: Users can save filters defined on a Table Column control via the "Save filter" option in the context menu..
Item concerned: Table field | | aafPrintReportOnTable | Configures the print of report on Table control. The formatting of cells (colors, ...) defined in the Table control is stored when using TablePrint.
Item concerned: Table field | | aafFind | Sets the search window style used when searching within a window..
Component concerned: Window | | aafInternetSearch | Configures the engine used to perform the search on Internet. The search engine used by default is Google.
Applies to: - Edit control
- Table control, TreeView Table control, Spreadsheet control and Pivot Table control
| | aafDirectoryTableExport | Configures the default directory where the export file will be created. | | aafColumnSelection | Selection of visible columns via the context menu of Table control.
Item concerned: Table field | | aafTableToExcel | Exports the content of Table control or the selection performed in the control to Excel.
Item concerned: Table field | | aafTableToWord | Exports the content of Table control or the selection performed in the control to Word.
Item concerned: Table field | | aafTableToXML | Exports the content of Table control or the selection performed in the control to XML.
Item concerned: Table field |
<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:- Formulas, formatting, etc. in existing cells are retained.
- 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 the rows containing totals, mean 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 context 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.
- To configure the search engine used for the Internet search, <Parameter> is a string corresponding to the command line of search engine. For example:
- 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 set up thesearch window, the following constants can be used:
| | | aafFindBarAppearance | The window is searched using a mini toolbar (default mode for applications compiled from version 2024).. | | aafFindDialogAppearance | Window search is performed via a dialog box (default mode for applications compiled with versions prior to 2024).. |
- To configure the report print (especially how the formatting of cells is stored), <Parameter> is an integer set to 1.
- To define how long a temporary message is displayed (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 duration in a readable format (e.g., '1 s' or '10 cs').
- -1 to use the default duration.
This page is also available for…
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|