IPrxFormulaIslands.FindByKey

Syntax

FindByKey(Key: Integer): IPrxFormulaIsland;

Parameters

Key - key of a formula area.

Description

The FindByKey method searches for a formula area based on the specified key.

Example

The following example assumes that there is the Report object with the IPrxReport type and the ComboBox component containing the list of keys of the formula areas located on the report sheet.

Sub ComboBox1OnChange(Sender: Object; Args: IEventArgs);

Var

Report : IPrxReport;

TableSheet : IPrxTable;

isl: IPrxFormulaIslands;

Begin

TableSheet := Report.ActiveSheet As IPrxTable;

isl := Report.FormulaIslands;

TableSheet.TabSheet.View.Selection.Range := isl.FindByKey(Integer.Parse(ComboBox1.Text)).Range;

End Sub ComboBox1OnChange;

When a key is selected in the list of the ComboBox component, the corresponding formula area on the report sheet is selected.