|
|
|
|
|
|
|
|
|
|
ConfigureAAF (Function) In french: ParamètreFAA
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 memorize filters defined on a Table control column via the "Memorize filter" option in the context menu.
Affected element: Table control | | 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 | | 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.
Affected element: Table control | | aafTableToExcel | Exports the content of Table control or the selection performed in the control to Excel.
Affected element: Table control | | aafTableToWord | Exports the content of Table control or the selection performed in the control to Word.
Affected element: Table control | | aafTableToXML | Exports 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:
| | | 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…
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|