Example

The following example creates a Spread with multiple sheets and sets the color for a cell in a specific sheet.

C++

// Set number of sheets

spr->SetSheetCount(8);

// Set sheet

spr->SetSheet(1);

// Set color for cell on sheet 1

spr->SetColor(1,1,RGB(255,255,0),SPREAD_COLOR_NONE);

// Get the number of sheets

short s;

char buf[10];

s = spr->GetSheet();

itoa(s, (LPSTR)buf, 10);

AfxMessageBox(buf);