IPrxReportExporter.ExportHiddenCells

Syntax

ExportHiddenCells: Boolean;

Description

The ExportHiddenCells property determines whether hidden rows/columns need to be exported when exporting to the XLS (*.xls) format and the ODS (*.ods) format. If this property is set to True, hidden columns/rows (if any) are exported and the user can work with them using Microsoft Excel tools; if this property is set to False, the hidden areas are not exported.

The default property value is True.

Example

The following example assumes that there is the Report object with the IPrxReport type.

Sub UserProc;

Var

Report: IPrxReport;

Exp: IPrxReportExporter;

Begin

Exp := New PrxReportExporter.Create;

Exp.Report := Report;

Exp.ExportHiddenCells := False;

Exp.ExportToFile("C:\Report.xls","xls");

End Sub UserProc;

After executing the example the output file displays no hidden rows or columns.