ITabCellSearch.Target

Syntax

Description

The Target property determines, by which cell properties the search is performed.

Comments

The property may take multiple values, so the search is performed based on all properties specified in the Target field. Default value of the Target property is set as Value.

Example

To execute the example a form with a button on it named Button1, the TabSheetBox component and the UiTabSheet component with the name 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.Target := TabCellSearchTarget.Formula Or TabCellSearchTarget.Text;
        Result := CellSearch.Execute;
        If Result <> Null Then
            i := Result.CurrentRow;
            j := Result.CurrentColumn;
        End If;
        End Sub Button1OnClick;

Clicking this button starts search in the cells containing formulas and text. 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.