Link Search Menu Expand Document

SSpread.FindCellTag Method

Explanation Searches for the tag set in the CellTag property and returns the cell position where the tag is set. If not found , returns null.

It has the following restrictions:
- CellTag can be set individually for sheet, row, column, and cell, but FingCellTag targets only cells.
- CellTag can set the same character string for multiple cells, but only the last set cell will be searched.
- If CellTag of the same character string is set in multiple cells, it will not be possible to search by that tag no matter which cell is deleted.
Added since Ver.5.0.3
Call format var rec = FindCellTag(tag)
Return value Record object with the following child objects
Type Name Description
Number Col Column index
Number Row Row number
Arguments tag Tag string to search
Exception None
Example of use
    var rec = Spread1.FindCellTag("Summary items");
    if (rec != null) {
    Spread1.Col = rec.Col;
    Spread1.Row = rec.Row;
    Spread1.Text = data;
    }
    
Related item CellTag property