IPrxReportExporter.ExportFormulas

Fore Syntax

ExportFormulas: Boolean;

Fore.NET Syntax

ExportFormulas: boolean

Description

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.

Fore Example

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.

Fore.NET Example

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

Imports Prognoz.Platform.Interop.Tab;
Imports Prognoz.Platform.Interop.Report;

Public Shared Sub Main(Params : StartParams);
Var
    MB: IMetabase;
    MObj: IMetabaseObject;
    Report: IPrxReport;
    Tab: TabSheet;
    Exp: ITabSheetExporter;
Begin
    MB:= Params.Metabase;
    MObj:= MB.ItemById["OBJ42781"].Edit();
    Report:= MObj As IPrxReport;
    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;

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