Example
The following example hides the row headers, prevents the user from resizing the nonscrollable column, provides custom text for the column headers, and specifies a maximum number of rows and columns.
C++
// Hide the row headers
m_Spread.SetRowHeadersShow(FALSE);
// Set the number of nonscrolling columns
m_Spread.SetColsFrozen(1);
// Prevent the user from resizing the specified column
m_Spread.SetCol(1);
m_Spread.SetUserResizeCol(UserResizeOff);
// Provide text for the column headers
// Specify clipping block
m_Spread.SetCol(1);
m_Spread.SetCol2(4);
m_Spread.SetRow(0);
m_Spread.SetRow2(0);
// Clip data into the sheet
m_Spread.SetClip("Territory\tTotal Leads\tTotal Quotes\tTotal Sales");
// Set the maximum number of columns
m_Spread.SetMaxCols(4);
// Set the maximum number of rows
m_Spread.SetMaxRows(5);
// Set the column width for all columns
m_Spread.SetColWidth(-1,10);
// Provide text for the rows in the first column
// Specify clipping block
m_Spread.SetCol(1);
m_Spread.SetCol2(1);
m_Spread.SetRow(1);
m_Spread.SetRow2(5);
// Clip data into the sheet
m_Spread.SetClip("Northeast\nSoutheast\nMidwest\nNorthwest\nSouthwest");
// Align the text to the right in the first column
m_Spread.SetCol(1);
m_Spread.SetRow(-1);
m_Spread.SetTypeHAlign(TypeHAlignRight);
Visual Basic
' Hide the row headers
fpSpread1.RowHeadersShow = False
' Set the number of nonscrolling columns
fpSpread1.ColsFrozen = 1
' Prevent the user from resizing the specified column
fpSpread1.Col = 1
fpSpread1.UserResizeCol = UserResizeOff
' Provide text for the column headers
' Specify clipping block
fpSpread1.Col = 1
fpSpread1.Col2 = 4
fpSpread1.Row = 0
fpSpread1.Row2 = 0
' Clip data into the sheet
fpSpread1.Clip = "Territory" + Chr$(9) + "Total Leads" + Chr$(9) + "Total Quotes" + Chr$(9) + "Total Sales"
' Set the maximum number of columns
fpSpread1.MaxCols = 4
' Set the maximum number of rows
fpSpread1.MaxRows = 5
' Set the column width for all columns
fpSpread1.ColWidth(-1) = 10
' Provide text for the rows in the first column
' Specify clipping block
fpSpread1.Col = 1
fpSpread1.Col2 = 1
fpSpread1.Row = 1
fpSpread1.Row2 = 5
' Clip data into the sheet
fpSpread1.Clip = "Northeast" + Chr$(13) + "Southeast" + Chr$(13) + "Midwest" + Chr$(13) + "Northwest" + Chr$(13) + "Southwest"
' Align the text to the right in the first column
fpSpread1.Col = 1
fpSpread1.Row = -1
fpSpread1.TypeHAlign = TypeHAlignRight