|
|
|
|
|
|
|
|
VisibleInExportAndPrint (Property) In french: VisibleEnExportEtImpression
The VisibleInExportAndPrint property is used to: - Determine if a column of a Table or TreeView Table control is visible for export and printing.
- Modify the visibility of a column in a Table or TreeView Table control for export and printing.
Remark: This property corresponds to the "Export and print" option in the "General" tab of the description window of a column in a Table or TreeView Table control. // [Print without details] button
TABLE_CUSTOMER.COL_Details.VisibleInExportAndPrint = False
iPrintReport(RPT_ReportOnCustomerTable)
TABLE_CUSTOMER.COL_Details.VisibleInExportAndPrint = Default
// Export to Excel:
// 1. The COL_Details column is exported
TABLE_MyTable.COL_Details.VisibleInExportAndPrint = False
TableToExcel(TABLE_MyTable, sFile, taNoTitle + taWithInvisibleColumns)
// 2. The COL_Details column is not exported
TABLE_MyTable.COL_Details.VisibleInExportAndPrint = False
TableToExcel(TABLE_MyTable, sFile, taNoTitle)
Syntax
Find out whether a column of a Table or TreeView Table control is visible for export and printing Hide the details
<Result> = <Column>.VisibleInExportAndPrint
<Result>: Integer constant Management mode of column:
| | | Default | The column is exported or printed only if it is visible at display. | | False | The column can never be exported or printed.
Caution: When exporting with one of the export functions (TableToExcel, TableToText, TableToWord, TableToXML, TableToClipboard), if the taWithInvisibleColumns constant is used, the column will still be exported. | | True | The column can be exported or printed (even if it is invisible at display). |
<Column>: Control name Name of the column to be used. This column can be a column found in a Table or TreeView Table control.
Modify the visibility of a column in a Table or TreeView Table control for export and printing Hide the details
<Column>.VisibleInExportAndPrint = <Visibility>
<Column>: Control name Name of the column to be used. This column can be a column found in a Table or TreeView Table control. <Visibility>: Integer constant Management mode of column:
| | | Default | The column is exported or printed only if it is visible at display. | | False | The column can never be exported or printed.
Caution: When exporting with one of the export functions (TableToExcel, TableToText, TableToWord, TableToXML, TableToClipboard), if the taWithInvisibleColumns constant is used, the column will still be exported. | | True | The column can be exported or printed (even if it is invisible at display). |
Remarks The VisibleInExportAndPrint property is taken into account in the following cases: - print performed via the print AAF (Automatic Application Feature): print via the "Print" option in the context menu of the Table control.
- print performed via the export AAFs in the context menu of the Table control.
- export via the export functions (TableToExcel, TableToText, TableToWord, TableToXML, TableToClipboard).
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|