|
|
|
|
AAFConfigure (Function) In french: FAAParamètre // Configures the mode for exporting the content of Table control to Excel AAFConfigure(aafTableToExcel, taWithLayout)  // With combination of options: AAFConfigure(aafTableToExcel, taColumnsTitles + taColumnDisplayedOrder + taWithLayout)
Syntax
<Result> = AAFConfigure(<Relevant AAF> , <Parameter>)
<Result>: Variant Former value of AAF setting. <Relevant AAF>: Integer constant 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: The user can store the filters defined on a column of Table control via "Store the filter" 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 | aafInternetSearch | Configures the engine used to perform the search on Internet. The search engine used by default is Google.
Affected element: - 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 or combination of Integer constants 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.
- 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 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.
Business / UI classification: UI Code
This page is also available for…
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|