ExportFormulas: Boolean;
The ExportFormulas property determines whether the formulas stored in the table should be exported. If the property is set to True, the table is exported together with formulas; if the property is set to False, only values are exported.
The default property value is True.
The following example assumes that there is the Report object with 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 the regular report sheet is exported to an XLS file. Table formulas are also exported.
See also: