You can determine the cell type of a cell. You can use the GetCellType method of the SheetView class.
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))) |