Example
The following example creates a sheet with multiple column header rows and row header columns. The auto text for the headers appears in the top row and left column, as shown in the following figure.
C++
void CmyWnd::MyFunc()
{
long SPREADHEADER = -1000;
// Set the maximum number of columns and rows
m_Spread1.SetMaxCols(4);
m_Spread1.SetMaxRows(12);
// Create two rows of column and row headers
// Display auto text in left and top column and row
m_Spread1.SetColHeaderRows(2);
m_Spread1.SetColHeadersAutoTextIndex(0);
m_Spread1.SetRowHeaderCols(2);
m_Spread1.SetRowHeadersAutoTextIndex(0);
// Set up special column header
m_Spread1.SetRow(SPREADHEADER + 1);
m_Spread1.SetCol(1);
m_Spread1.SetRow2(SPREADHEADER + 1);
m_Spread1.SetCol2(4);
m_Spread1.SetClip("North\tSouth\tEast\tWest");
// Set up special row header
m_Spread1.SetColWidth(SPREADHEADER + 1, 10);
m_Spread1.SetCol(SPREADHEADER + 1);
m_Spread1.SetRow(1);
m_Spread1.SetCol(SPREADHEADER + 1);
m_Spread1.SetRow2(12);
m_Spread1.SetClip("January\rFebruary\rMarch\rApril\rMay\rJune\rJuly\rAugust\rSeptember\rOctober\rNovember\rDecember");
}
Visual Basic
Private Sub Form_Load()
' Set the maximum number of columns and rows
fpSpread1.MaxCols = 4
fpSpread1.MaxRows = 12
' Create two rows of column and row headers
' Display auto text in left and top column and row
fpSpread1.ColHeaderRows = 2
fpSpread1.ColHeadersAutoTextIndex = 0
fpSpread1.RowHeaderCols = 2
fpSpread1.RowHeadersAutoTextIndex = 0
' Set up special column header
fpSpread1.Row = SpreadHeader + 1
fpSpread1.Col = 1
fpSpread1.Row2 = SpreadHeader + 1
fpSpread1.Col2 = 4
fpSpread1.Clip = "North" + Chr(9) + "South" + Chr(9) + "East" + Chr(9) + "West"
' Set up special row header
fpSpread1.ColWidth(SpreadHeader + 1) = 10
fpSpread1.Col = SpreadHeader + 1
fpSpread1.Row = 1
fpSpread1.Col = SpreadHeader + 1
fpSpread1.Row2 = 12
fpSpread1.Clip = "January" + Chr(13) + "February" + Chr(13) + "March" + Chr(13) + "April" + Chr(13) + "May" + Chr(13) + "June" + Chr(13) + "July" + Chr(13) + "August" + Chr(13) + "September" + Chr(13) + "October" + Chr(13) + "November" + Chr(13) + "December"
End Sub