IPrxFormulaIsland.Revert

Syntax

Revert;

Description

The Revert method cancels changes made in 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 := Formula.Edit;

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

Formula.Revert;

End Sub Main;

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