IPrxFormulaIsland.Copy

Syntax

Copy([Sheet: IPrxSheet = Null;] [Range: ITabRange = Null]): IPrxFormulaIsland;

Parameters

Sheet - sheet of the regular report where a copy of the formula area is to be located.

Range - cell range where a copy of the formula area is to be located.

Description

The Copy method creates a copy of the formula area.

Example

Sub Main;

Var

MB: IMetabase;

MObj: IMetabaseObject;

Report: IPrxReport;

FormulaIs: IPrxFormulaIslands;

Formula: IPrxFormulaIsland;

Begin

MB := MetabaseClass.Active;

MObj := MB.ItemById("Report").Edit;

Report := MObj As IPrxReport;

FormulaIs := Report.FormulaIslands;

Formula := FormulaIs.Item(0);

Formula.Copy(Report.Sheets.Item(Report.Sheets.Count- 1),Formula.Range);

MObj.Save;

End Sub Main;

After executing the example a copy of the first formula area is created on the last sheet of the regular report. The identifier of the regular report - Report.