VisibleInExportAndPrint (Property)

ONLINE HELP
WINDEV, WEBDEV AND WINDEV MOBILE

Version:

Home | Sign in | English

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

WEBDEV

WINDEV Mobile

Others

See also

VisibleInExportAndPrint (Property)

In french: VisibleEnExportEtImpression

The property VisibleEnExportEtImpression property property allows you 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

// Bouton [Imprimer sans détail]
TABLE_CLIENT.COL_Détail.VisibleEnExportEtImpression = False
iPrintReport(ETAT_EtatSurTableClient)
TABLE_CLIENT.COL_Détail.VisibleEnExportEtImpression = Default

// Export vers Excel :
// 1. La colonne COL_Détail est exportée
TABLE_MaTable.COL_Détail.VisibleEnExportEtImpression = False
TableToExcel(TABLE_MaTable, sFic, taNoTitle + taWithInvisibleColumns)
// 2. La colonne COL_Détail n'est pas exportée
TABLE_MaTable.COL_Détail.VisibleEnExportEtImpression = False
TableToExcel(TABLE_MaTable, sFic, 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.
Attention When exporting with one of the export functions (TableToExcel, TableToText, TableToWord, TableToXML, TableToClipboard), if the constant taAvecColonnesInvisibles 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.
Attention When exporting with one of the export functions (TableToExcel, TableToText, TableToWord, TableToXML, TableToClipboard), if the constant taAvecColonnesInvisibles 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 property VisibleInExportAndPrint property is taken into account in the following cases:

printing via the printing AAF (Automatic Application Functionality): printing, for example, via the "Print" option in the Table control 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).