CellType Property (Cell)

Visual Basic
C#

'Declaration
 
Public Property CellType As ICellType

'Usage
 
Dim instance As Cell
Dim value As ICellType
 
instance.CellType = value
 
value = instance.CellType

public ICellType CellType {get; set;}

Property Value

ICellType object that contains the cell type for this cell

The setting for this property can be overridden if a named style is assigned to the cell using the StyleName property, and that named style sets the cell type.

This example creates a Cell object, sets in BackColor and ForeColor properties, defines it as a CheckBox cell type, and puts a border around it. When the user edits the cell and checks the CheckBox, the text of the cell changes.

C#

FarPoint.Web.Spread.Cell mycell;
mycell = FpSpread1.Cells[0, 0];
mycell.BackColor = Color.RoyalBlue;
mycell.ForeColor = Color.White;
mycell.Border = new FarPoint.Web.Spread.Border(System.Web.UI.WebControls.BorderStyle.Double, Color.DarkBlue, 2);
mycell.CellType = new FarPoint.Web.Spread.CheckBoxCellType();

Visual Basic

Dim mycell As FarPoint.Web.Spread.Cell
mycell = FpSpread1.Cells(0, 0)
mycell.BackColor = Color.RoyalBlue
mycell.ForeColor = Color.White
mycell.Border = New FarPoint.Web.Spread.Border(System.Web.UI.WebControls.BorderStyle.Double, Color.DarkBlue, 2)
mycell.CellType = New FarPoint.Web.Spread.CheckBoxCellType()

Reference

Cell Class
Cell Members
ICellType Interface
StyleName Property
NamedStyle Class

User-Task Documentation

Customizing with Cell Types