SftBoxItems.FindCellDataV Method
Searches cell data (Cell.Data property).
Syntax
| VB.NET | object.FindCellDataV(ByVal Value As Integer, ByVal StartIndex As Integer, ByVal EndIndex As Integer, ByVal ColNum As Short, ByRef FoundIndex As Object, ByRef FoundColNum As Object) |
| VB | object.FindCellDataV(ByVal Value As Long, ByVal StartIndex As Long, ByVal EndIndex As Long, ByVal ColNum As Integer, FoundIndex As Variant, FoundColNum As Variant) |
| C#.NET | void object.FindCellDataV(int Value, int StartIndex, int EndIndex, short ColNum, out object FoundIndex, out object FoundColNum); |
| VC++ | HRESULT object->FindCellDataV(long Value, long StartIndex, long EndIndex, short ColNum, const _variant_t&* FoundIndex, const _variant_t&* FoundColNum); |
| C | HRESULT object->raw_FindCellDataV(long Value, long StartIndex, long EndIndex, short ColNum, VARIANT* FoundIndex, VARIANT* FoundColNum); |
object
A SftBoxItems object.
Value
The value to be searched.
StartIndex
The zero-based index of the item where the search is to begin (including the item at StartIndex). Specify StartIndex as -1 and EndIndex as -1 to search all items.
EndIndex
The zero-based index of the item where the search is to begin (including the item at StartIndex). Specify StartIndex as -1 and EndIndex as -1 to search all items.
ColNum
The zero-based index of the column to be searched. Only cells in this column will be searched. Specify -1 to search all columns of the items defined by StartIndex and EndIndex.
FoundIndex
Returns the zero-based index of the item found. -1 is returned if no match was found.
FoundColNum
Returns the zero-based column number of the cell found. -1 is returned if no match was found.
Comments
The FindCellDataV method searches cell data (Cell.Data property).
The Items.FindCellData and FindCellDataV methods are synonyms. The FindCellDataV method is used with .
The value described by Value is compared to the Cell.Data property of all cells involved in the search. The search starts at the item described by StartIndex and is restricted to the column specified by ColNum. If an item with a matching Cell.Data property is found, its zero-based index and column number is returned, otherwise -1 is returned.
See Also SftBoxItems Object | Object Hierarchy
On
Off