SftBoxItems.FindCellValue Method

SftBoxItems.FindCellValue Method

Softel vdm, Inc.

Searches cell data (Cell.Value property).

Deprecated - Provided for compatibility with earlier versions only - Use Items.FindCellData instead

Syntax

VB.NET

object.FindCellValue(ByVal Value As Integer, ByVal StartIndex As Integer, ByVal EndIndex As Integer, ByVal ColNum As Short, ByRef FoundIndex As Integer, ByRef FoundColNum As Short)

VB

object.FindCellValue(ByVal Value As Long, ByVal StartIndex As Long, ByVal EndIndex As Long, ByVal ColNum As Integer, FoundIndex As Long, FoundColNum As Integer)

C#.NET

void object.FindCellValue(int Value, int StartIndex, int EndIndex, short ColNum, out int FoundIndex, out short FoundColNum);

VC++

HRESULT object->FindCellValue(long Value, long StartIndex, long EndIndex, short ColNum, long* FoundIndex, short* FoundColNum);

C

HRESULT object->raw_FindCellValue(long Value, long StartIndex, long EndIndex, short ColNum, long* FoundIndex, short* FoundColNum);

Delphi

procedure object.FindCellValue(Value : Integer, StartIndex : Integer, EndIndex : Integer, ColNum : Smallint, out FoundIndex : Integer, out FoundColNum : Smallint);

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

Deprecated - Provided for compatibility with earlier versions only - Use Items.FindCellData instead

The FindCellValue method searches cell data (Cell.Value property).

The Items.FindCellData and Items.FindCellDataV methods are synonyms. The Items.FindCellDataV method is used with Internet Explorer/VBScript.

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.

		VB.NET	object.FindCellValue(ByVal Value As Integer, ByVal StartIndex As Integer, ByVal EndIndex As Integer, ByVal ColNum As Short, ByRef FoundIndex As Integer, ByRef FoundColNum As Short)
		VB	object.FindCellValue(ByVal Value As Long, ByVal StartIndex As Long, ByVal EndIndex As Long, ByVal ColNum As Integer, FoundIndex As Long, FoundColNum As Integer)
		C#.NET	void object.FindCellValue(int Value, int StartIndex, int EndIndex, short ColNum, out int FoundIndex, out short FoundColNum);
		VC++	HRESULT object->FindCellValue(long Value, long StartIndex, long EndIndex, short ColNum, long* FoundIndex, short* FoundColNum);
		C	HRESULT object->raw_FindCellValue(long Value, long StartIndex, long EndIndex, short ColNum, long* FoundIndex, short* FoundColNum);
		Delphi	procedure object.FindCellValue(Value : Integer, StartIndex : Integer, EndIndex : Integer, ColNum : Smallint, out FoundIndex : Integer, out FoundColNum : Smallint);