ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

This content has been translated automatically.  Click here  to view the French version.
Help / WLanguage / WLanguage properties / Properties associated with windows, pages and controls
WINDEV
WindowsLinuxJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadIOS WidgetApple WatchMac Catalyst
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.
Note: This property corresponds to the "Export and print" option available in the "General" tab of the Table or TreeView Table control column description window..
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.
Attention: When exporting with one of the export functions (TableToExcel, TableToText, TableToWord, TableToXML, TableToClipboard), if the constant taAvecolonnesInvisibles 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 of a Table or Hierarchical Table field..

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 of a Table or Hierarchical Table field..
<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.
Attention: When exporting with one of the export functions (TableToExcel, TableToText, TableToWord, TableToXML, TableToClipboard), if the constant taAvecolonnesInvisibles 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:
  • printing via the print AIF (Automatic Functionality of your Applications): printing, for example, via the "Print" option in the Table field context menu.
  • 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: 10/04/2024

Send a report | Local help