You can determine the cell type of a cell. You can use the GetCellType method of the SheetView class.
Return to the overview at Understanding How Cell Types Work.
Using Code
You can use the GetCellType method to get the cell type.
Example
The following code uses the GetCellType method.
| C# |  Copy Code |
|---|---|
FarPoint.Web.Spread.SheetViewsv=FpSpread1.ActiveSheetView; sv.Cells[0,0].CellType=newFarPoint.Web.Spread.ButtonCellType(); ListBox1.Items.Add(Convert.ToString(sv.GetCellType(0,0))); |
|
| VB | Copy Code |
|---|---|
Dim sv As FarPoint.Web.Spread.SheetView sv = FpSpread1.ActiveSheetView sv.Cells(0,0).CellType=NewFarPoint.Web.Spread.ButtonCellType() ListBox1.Items.Add(Convert.ToString(sv.GetCellType(0,0))) |
|