Hide

SftBox/OCX 5.0 - Combo Box Control

Display
Print

SftBoxItems.FindCellData Method

Searches cell data (Cell.Data property).

Syntax

VB.NETobject.FindCellData(ByVal Value As Integer, ByVal StartIndex As Integer, ByVal EndIndex As Integer, ByVal ColNum As Short, ByRef FoundIndex As Integer, ByRef FoundColNum As Short)
VBobject.FindCellData(ByVal Value As Long, ByVal StartIndex As Long, ByVal EndIndex As Long, ByVal ColNum As Integer, FoundIndex As Long, FoundColNum As Integer)
C#.NETvoid object.FindCellData(int Value, int StartIndex, int EndIndex, short ColNum, out int FoundIndex, out short FoundColNum);
VC++HRESULT object->FindCellData(long Value, long StartIndex, long EndIndex, short ColNum, long* FoundIndex, short* FoundColNum);
CHRESULT object->raw_FindCellData(long Value, long StartIndex, long EndIndex, short ColNum, long* FoundIndex, short* 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 FindCellData method searches cell data (Cell.Data property).

The 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.

Examples

VB.NET

    If box Is SftBox2 Then
        oneCell.Image.Width = 26
    Else
        oneCell.Image.Width = 13
    End If
    oneCell.Image.SetColorSample(OLECvt.ToOleColor(color), OLECvt.ToOleColor(color.Black)) ' set the cell's color sample
    ' We'll save the color value in the cell's Data property so
    ' we can use the Items.FindCellData method if needed
    oneCell.Data = ColorTranslator.ToWin32(color)
End Sub

Private Sub AddColors(ByVal box As AxSftBoxLib50.AxSftBox)
    AddColor(box, "Black", Color.Black)
    AddColor(box, "Blue", Color.Blue)
    AddColor(box, "Cyan", Color.Cyan)
    AddColor(box, "Green", Color.Green)

VB6

    If Box Is SftBox2 Then
        OneCell.Image.Width = 26
    Else
        OneCell.Image.Width = 13
    End If
    OneCell.Image.SetColorSample color, vbBlack ' set the cell's color sample

    ' We'll save the color value in the cell's Data property so
    ' we can use the Items.FindCellData method if needed
    OneCell.Data = color

End Function

Private Sub AddColors(Box As SftBox)
    AddColor Box, "Black", vbBlack
    AddColor Box, "Blue", vbBlue

C#

    oneCell.Image.Height = 13;
    oneCell.Image.Width = 13;
    if (box == SftBox2)
        oneCell.Image.Width = 26;
    else
        oneCell.Image.Width = 13;
    oneCell.Image.SetColorSample(OLECvt.ToOleColor(color), OLECvt.ToOleColor(Color.Black)); // set the cell's color sample
    // We'll save the color value in the cell's Data property so
    // we can use the Items.FindCellData method if needed
    oneCell.Data = ColorTranslator.ToWin32(color);
}

private void AddColors(AxSftBoxLib50.AxSftBox box)
{
    AddColor(box, "Black", Color.Black);
    AddColor(box, "Blue", Color.Blue);

C++

        OneCell->Image->Height = 13;
        OneCell->Image->Width = 26;
    } else {
        OneCell->Image->Height = 13;
        OneCell->Image->Width = 13;
    }
    OneCell->Image->SetColorSample(color, RGB(0,0,0)); // set the cell's color sample
    // We'll save the color value in the cell's Data property so
    // we can use the Items.FindCellData method if needed
    OneCell->Data = color;
}

void CColorsDlg::AddColors(ISftBoxPtr vCombo, BOOL fSmallSample)
{
    AddColor(vCombo, fSmallSample, "Black", RGB(0,0,0));
    AddColor(vCombo, fSmallSample, "Blue", RGB(0,0,255));

See Also SftBoxItems Object | Object Hierarchy


Last Updated 08/13/2020 - (email)
© 2024 Softel vdm, Inc.