ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Help / WLanguage / WLanguage properties / Properties associated with windows, pages and controls
WINDEV
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadIOS WidgetApple WatchMac CatalystUniversal Windows 10 App
Others
Stored procedures
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.
Example
// [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:
DefaultThe column is exported or printed only if it is visible at display.
FalseThe 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.
TrueThe 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:
DefaultThe column is exported or printed only if it is visible at display.
FalseThe 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.
TrueThe 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).
Minimum version required
  • Version 22
This page is also available for…
Comments
Click [Add] to post a comment

Last update: 03/08/2024

Send a report | Local help