IPrxFormulaIsland.Edit

Syntax

Edit: IPrxFormulaIsland;

Description

The Edit method opens a formula area for edit.

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 := Formula.Edit;

Formula.Origin := Formula.Sheet.Table.Cell(0,0);

Formula.Save;

End Sub Main;

After executing the example the base cell of the first formula area of the regular report is changed. The changes are saved without saving the regular report. The identifier of the regular report - Report.