Gets a cell with a specific tag on the sheet.
Syntax
| Visual Basic (Usage) |  Copy Code |
|---|
Dim instance As SheetView
Dim cellToStart As Cell
Dim tagToFind As Object
Dim value As Cell
value = instance.GetCellFromTag(cellToStart, tagToFind) |
Parameters
- cellToStart
- Cell object in Cells collection from which to start (pass null to start from beginning)
- tagToFind
- Tag object to identify the Cell you are looking for
Return Value
Cell object containing the cell with the specified tag, or null if no cell is found
Example
This example gets a cell with a specific tag on the sheet.
| C# | Copy Code |
|---|
FarPoint.Win.Spread.SheetView sv;
FarPoint.Win.Spread.Cell acell;
sv = fpSpread1.ActiveSheet;
sv.Cells[2, 2].Tag = "MyTag";
acell = sv.GetCellFromTag(null, "MyTag");
MessageBox.Show("The tag is in cell " + acell.Row.ToString() + " ," + acell.Column.ToString());
|
| Visual Basic | Copy Code |
|---|
Dim sv As FarPoint.Win.Spread.SheetView
Dim acell As FarPoint.Win.Spread.Cell
sv = FpSpread1.ActiveSheet
sv.Cells(2, 2).Tag = "MyTag"
acell = sv.GetCellFromTag(Nothing, "MyTag")
MessageBox.Show("The tag is in cell " & acell.Row.ToString() & " ," & acell.Column.ToString()) |
Requirements
Target Platforms: Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2
See Also
