ITabSheetExporter.ExportFormulas

Syntax

ExportFormulas: Boolean;

Description

The ExportFormulas property determines whether table formulas need to be exported. If the property is set to True, the table is exported with formulas, if it is False, only values are exported.

By default the property is set to set to True.

Example

This example is supposed to have the Report object of the IPrxReport type.

Sub UserProc;
Var
    Report: IPrxReport;
    Tab: ITabSheet;
    Exp: ITabSheetExporter;
Begin
    Tab:= (Report.Sheets.Item(0) As IPrxTable).TabSheet;
    Exp:= New TabSheetExporter.Create;
    Exp.TabSheet:= Tab;
    Exp.ExportFormulas:= True;
    Exp.ExportToFile("c:\Report1.xls", "XLS");
End Sub UserProc;

After executing the example a sheet of regular report is exported to the XLS file. Table formulas are also exported.