Example

The following example retrieves the cell coordinates of the specified cell using screen coordinates.

C++

BOOL CAboutDlg::OnInitDialog()
{
    CDialog::OnInitDialog();
    // Set number of sheets
    m_Spread.SetSheetCount(2);
    // Set cell type
    m_Spread.SetSheet(1);
    m_Spread.SetCol(1);
    m_Spread.SetRow(1);
    m_Spread.SetCellType(CellTypeCheckBox);
    m_Spread.SetTypeCheckText("test");
}

void CAboutDlg::OnClickFpbtn1()
{
    // Reset sheet 1
    m_Spread.ResetSheet(1);
}

Visual Basic

Private Sub Form_Load()
    ' Set number of sheets
    fpSpread1.SheetCount = 2
    ' Set cell type
    fpSpread1.Sheet = 1
    fpSpread1.Col = 1
    fpSpread1.Row = 1
    fpSpread1.CellType = CellTypeCheckBox
    fpSpread1.TypeCheckText = "test"
End Sub

Private Sub Command1_Click()
    ' Reset sheet 1
    fpSpread1.ResetSheet 1
End Sub