Example

The following example sets the sheet to display different colors for odd and even rows. It also specifies the background and foreground colors to display for a row or column when the row or column is selected.

C++

void CMyWnd::MyFunc()
{
    bool x;
    // Set odd/even row colors as follows
    // Odd background: cyan, RGB(0, 255, 255)
    // Odd foreground: dark cyan, RGB(0, 128, 128)
    // Even background: blue, RGB(0, 0, 255)
    // Even foreground: dark blue, RGB(0, 0, 128)
    x = fpSpread1.SetOddEvenRowColor(0x00FFFF00, 0x00808000, 0x00FF0000, 0x00800000);
    // Set selection background color magenta, RGB(192, 0, 192)
    fpSpread1.SetSelBackColor(0x00C000C0);
    // Set selection foreground color dark magenta, RGB(128, 0, 128)
    fpSpread1.SetSelForeColor(0x00800080);
}

Visual Basic

Sub Form_Load()
    Dim x As Boolean
    ' Set odd/even row colors as follows
    ' Odd background: cyan, RGB(0, 255, 255)
    ' Odd foreground: dark cyan, RGB(0, 128, 128)
    ' Even background: blue, RGB(0, 0, 255)
    ' Even foreground: dark blue, RGB(0, 0, 128)
    x = fpSpread1.SetOddEvenRowColor(&H00FFFF00,&H00808000, &H00FF0000, &H00800000)
    ' Set selection background color magenta, RGB(192, 0, 192)
    fpSpread1.SelBackColor = &H00C000C0
    ' Set selection foreground color dark magenta, RGB(128, 0, 128)
    fpSpread1.SelForeColor = &H00800080
End Sub