PC SOFT

WINDEVWEBDEV AND WINDEV MOBILE
ONLINE HELP

Home | Sign in | English UK

WINDEV
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadApple WatchUniversal Windows 10 AppWindows Mobile
Others
Stored procedures
..VisibleInExportAndPrint is used to:
  • Find out whether a column of a table or treeview table is visible for the export and for the print.
  • Modify the visibility of a column found in a table or treeview table for the export and for the print.
Note: This property corresponds to the "Export and print" option found in the "General" tab of the description window of a column found in a Table or TreeView Table control.
Example
// [Print without details] button
TABLE_CUSTOMER.Detail..VisibleInExportAndPrint = False
iPrintReport(ReportOnCustomerTable)
TABLE_CUSTOMER.Detail..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

Finding out whether a table column is visible for the export and for the print Hide the details

<Result> = <Column name>..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: During an export performed by 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 name>: Character string (with or without quotes)
Name of column to use. This column can be a column found in a Table or TreeView Table control.

Modifying the visibility of a table column for the export and for the print Hide the details

<Column name>..VisibleInExportAndPrint = <Visibility>
<Column name>: Character string (with or without quotes)
Name of column to use. 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: During an export performed by 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
..VisibleInExportAndPrint is taken into account in the following cases:
  • print performed via the print AAF (Automatic Application Feature): print via the "Print" option from the popup menu of the Table control.
  • print performed via the export AAFs found in the popup 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