Example

---

The following example displays a different picture for each button state for a two-state button.

To access the file used in this sample, change the path in the code to the path for your product installation's \SAMPLES\FILES directory.

C++

void CmyWnd::MyFunc()
{
    CPictureHolder pic;
        // Specify a cell
        m_Spread1.SetCol(2);
        m_Spread1.SetRow(3);
        // Define cell type as button
        m_Spread1.SetCellType(7);
        // Make button a two-state button
        m_Spread1.SetTypeButtonType(1);
        // Increase shadow size to accentuate the two-state
        // button
        m_Spread1.SetTypeButtonShadowSize(3);
        // Provide picture for when button is up
        // Convert hBitmap
        pic.CreateFromBitmap(IDB_HAPPY);
        m_Spread1.SetTypeButtonPicture(pic.GetPictureDispatch());
        // Provide picture for when button is down
        // Convert hBitmap
        pic.CreateFromBitmap(IDB_SAD);
        m_Spread1.SetTypeButtonPictureDown(pic.GetPictureDispatch());
        // Change height of row to display the picture
        m_Spread1.SetRowHeight(3,20);
}

Visual Basic

' Specify a cell
fpSpread1.Col = 2
fpSpread1.Row = 3
' Define cell type as button
fpSpread1.CellType = CellTypeButton
' Make button a two-state button
fpSpread1.TypeButtonType = TypeButtonTypeTwoState
' Increase shadow size to accentuate the two-state button
fpSpread1.TypeButtonShadowSize = 3
' Provide picture for when button is up
fpSpread1.TypeButtonPicture = LoadPicture("C:\Samples\Files\HAPPY.BMP")
' Provide picture for when button is down
fpSpread1.TypeButtonPictureDown = LoadPicture("C:\Samples\Files\SAD.BMP")
' Change height of row to display the picture
fpSpread1.RowHeight(3) = 20