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()

Target Platforms: Windows 7, Windows 8, Windows 10, Windows Vista, Windows Server 2003, Windows Server 2008, Windows Server 2012, Windows XP Professional

Reference

Cell Class
Cell Members
ICellType Interface
StyleName Property
NamedStyle Class

User-Task Documentation

Customizing with Cell Types