Example

The following example moves sheet 1.

C++

BOOL CAboutDlg::OnInitDialog()
{
    CDialog::OnInitDialog();
    // Set number of sheets
    m_Spread.SetSheetCount(4);
}

void CAboutDlg::OnClickFpbtn1()
{
    // Move sheet 1 to sheet 4
    // The other sheets (2 and 3) move left one sheet
    m_Spread.MoveSheets(1, 1, 4);
}

Visual Basic

Private Sub Form_Load()
    ' Set number of sheets
    fpSpread1.SheetCount = 4
End Sub

Private Sub Command1_Click()
    ' Move sheet 1 to sheet 4
    ' The other sheets (2 and 3) move left one sheet
    fpSpread1.MoveSheets 1, 1, 4
End Sub