Example

The following example starts the column headers at a specified number, provides text for the row headers, and sets the row height and the maximum number of rows.

C++

// Set column headers to display numbers
m_Spread1.SetColHeadersAutoText(DispNumbers);

// Set the starting column number
m_Spread1.SetStartingColNumber(1990);

// Set the maximum number of rows
m_Spread1.SetMaxRows(4);

// Provide text for the row header
// Specify clipping block
m_Spread1.SetCol(0);
m_Spread1.SetCol2(0);
m_Spread1.SetRow(1);
m_Spread1.SetRow2(4);
// Clip data into the sheet
m_Spread1.SetClip("Sales Revenue\nCost of Goods\nOperating Expenses\nNet Income");

// Align the text to the right in the row headers
m_Spread1.SetCol(0);
m_Spread1.SetRow(-1);
m_Spread1.SetTypeHAlign(TypeHAlignRight);


// Set the height of all the rows
m_Spread1.SetRowHeight(-1,14);

// Set the width of the row header
m_Spread1.SetColWidth(0,15);

Visual Basic

' Set column headers to display numbers
fpSpread1.ColHeadersAutoText = DispNumbers

' Set the starting column number
fpSpread1.StartingColNumber = 1990

' Set the maximum number of rows
fpSpread1.MaxRows = 4

' Provide text for the row header
' Specify clipping block
fpSpread1.Col = 0
fpSpread1.Col2 = 0
fpSpread1.Row = 1
fpSpread1.Row2 = 4
' Clip data into the sheet
fpSpread1.Clip = "Sales Revenue" + Chr$(13) + "Cost of Goods" + Chr$(13) + "Operating Expenses" + Chr$(13) + "Net Income"

' Align the text to the right in the row headers
fpSpread1.Col = 0
fpSpread1.Row = -1
fpSpread1.TypeHAlign = TypeHAlignRight

' Set the height of all the rows
fpSpread1.RowHeight(-1) = 14

' Set the width of the row header
fpSpread1.ColWidth(0) = 15