Example

The following example sets a maximum number of columns and rows, provides text for the column and row headers, and sets the width of the row header. In addition, the sheet displays scroll bars only when the maximum number of rows or columns exceed the current view. The example provides a command button. When the user clicks the button, it inserts a column and row, and provides text for the new column and row headers.

C++

void CTestDlg::OnShowWindow(BOOL bShow, UINT nStatus)
{
    CDialog::OnShowWindow(bShow, nStatus);

    // Set the maximum number of columns
    m_Spread1.SetMaxCols(3);
    // Provide text for the column headers
    // Specify clipping block
    m_Spread1.SetCol(1);
    m_Spread1.SetCol2(4);
    m_Spread1.SetRow(0);
    m_Spread1.SetRow2(0);
    // Clip data into the sheet
    m_Spread1.SetClip("Anne\tLinda\tSteve");
    // Set the maximum number of rows
    m_Spread1.SetMaxRows(5);
    // Provide text for the row headers
    // Specify clipping block
    m_Spread1.SetCol(0);
    m_Spread1.SetCol2(0);
    m_Spread1.SetRow(1);
    m_Spread1.SetRow2(5);
    // Clip data into the spreads
    m_Spread1.SetClip("North\n\rNorth West\n\rWest\n\rSouth\n\rEast");
    // Set the width of the row header
    m_Spread1.SetColWidth(0,10);
    // Display scroll bars only if needed
    m_Spread1.SetScrollBarExtMode(TRUE);
}

void CTestDlg::OnButton1()
{
    // Insert one column before a specified column
    // Increase the maximum number of columns by 1
    m_Spread1.SetMaxCols(m_Spread1.GetMaxCols() + 1);
    // Insert a column
    m_Spread1.InsertCols(m_Spread1.GetMaxCols() - 2, 1);

    // Provide text for the new column header
    // Specify the column header
    m_Spread1.SetCol(m_Spread1.GetMaxCols() - 2);
    m_Spread1.SetRow(0);
    // Specify new text
    m_Spread1.SetText("Joe");

    // Insert one row before the specified row
    // Increase the maximum number of rows by 1
    m_Spread1.SetMaxRows(m_Spread1.GetMaxRows() + 1);
    // Insert a row
    m_Spread1.InsertRows(m_Spread1.GetMaxRows() - 1, 1);

    // Provide text for the new row header
    // Specify the row header
    m_Spread1.SetCol(0);
    m_Spread1.SetRow(m_Spread1.GetMaxRows() - 1);
    // Specify new text
    m_Spread1.SetText("South East");
}

Visual Basic

Sub Form_Load()

    ' Set the maximum number of columns
    fpSpread1.MaxCols = 3

    ' 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 = "Anne" + Chr$(9) + "Linda" + Chr$(9) + "Steve"

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

    ' Provide text for the row headers
    ' Specify clipping block
    fpSpread1.Col = 0
    fpSpread1.Col2 = 0
    fpSpread1.Row = 1
    fpSpread1.Row2 = 5
    ' Clip data into the sheet
    fpSpread1.Clip = "North" + Chr$(13) + "North West" + Chr$(13) + "West" + Chr$(13) + "South" + Chr$(13) + "East"

    ' Set the width of the row header
    fpSpread1.ColWidth(0) = 10
    ' Display scroll bars only if needed
    fpSpread1.ScrollBarExtMode = True
End Sub


Sub Command1_Click()

    ' Insert one column before a specified column
    ' Increase the maximum number of columns by 1
    fpSpread1.MaxCols = 4
    ' Insert a column
    fpSpread1.InsertCols 2, 1

    ' Provide text for the new column header
    ' Specify the column header
    fpSpread1.Col = 2
    fpSpread1.Row = 0
    ' Specify new text
    fpSpread1.Text = "Joe"
    ' Insert one row before the specified row
    ' Increase the maximum number of rows by 1
    fpSpread1.MaxRows = 6
    ' Insert a row
    fpSpread1.InsertRows 5, 1

    ' Provide text for the new row header
    ' Specify the row header
    fpSpread1.Col = 0
    fpSpread1.Row = 5
    ' Specify new text
    fpSpread1.Text = "South East"

End Sub