ITabCellSearch.InFormulas

Syntax

InFormulas: Boolean;

Description

The InFormulas property determines whether search is performed within formulas.

Comment. This is an Outdated property. It is recommended to use the Target property instead.

Example

To execute the example a form with a button named Button1 on it, a TabSheetBox component and a UiTabSheet component named UiTabSheet1 which is used as a data source for the TabSheetBox component are required.

Sub Button1OnClick(Sender: Object; Args: IMouseEventArgs);
Var
    TSheet: ITabSheet;
    CellSearch: ITabCellSearch;
    Result: ITabSearchResult;
    i, j: Integer;
Begin
    TSheet := UiTabSheet1.TabSheet;
    CellSearch := TSheet.CreateCellSearch;
    CellSearch.Text := "A1+B1";
    CellSearch.InFormulas:=True;
    Result := CellSearch.Execute;
    If Result <> Null Then
        i := Result.CurrentRow;
        j := Result.CurrentColumn;
    End If;
End Sub Button1OnClick;

On clicking the button the A1+B1 value is searched for in the cells. Search is performed in formulas. If the search is successful, the "i" variable will contain the number of the row and the "j" variable will contain the number of the column of the found cell.