IPrxFormulaIsland.Origin

Syntax

Origin: ITabRange;

Description

The Origin property determines a base cell of the formula area.

Example

Sub Main;

Var

MB: IMetabase;

Report: IPrxReport;

FormulaIs: IPrxFormulaIslands;

Formula: IPrxFormulaIsland;

Cell: ITabRange;

s: String;

Begin

MB := MetabaseClass.Active;

Report := MB.ItemById("Report").Bind As IPrxReport;

FormulaIs := Report.FormulaIslands;

Formula := FormulaIs.Item(0);

Cell := Formula.Origin;

s := Cell.Address;

End Sub Main;

After executing the example the "s" variable contains address of the base cell of the first formula area. The identifier of the regular report - Report.

See also:

IPrxFormulaIsland