Spread Windows Forms 13.0 Product Documentation
FarPoint.Win.Spread Assembly / FarPoint.Win.Spread Namespace / Cell Class / CellType Property
Example


In This Topic
    CellType Property (Cell)
    In This Topic
    Gets or sets the type of cell.
    Syntax
    '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 containing the cell type
    Remarks

    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 setting is different than the GetCellType method for the sheet (SheetView object). The GetCellType method returns the composite (that is, inherited) cell type while this property gets the direct cell type.

    Here are graphic or control cell types based on FarPoint.Win.Spread.CellType.BaseCellType:

    Here are editable cell types based on FarPoint.Win.Spread.CellType.EditBaseCellType:

    Example
    This example creates a check box cell.
    FarPoint.Win.Spread.Cell acell;
    FarPoint.Win.Spread.CellType.CheckBoxCellType ck = new FarPoint.Win.Spread.CellType.CheckBoxCellType();
    acell = fpSpread1.ActiveSheet.Cells[0, 0];
    acell.CellType = ck;
    Dim acell As FarPoint.Win.Spread.Cell
    Dim ck As New FarPoint.Win.Spread.CellType.CheckBoxCellType()
    acell = fpSpread1.ActiveSheet.Cells(0, 0)
    acell.CellType = ck
    See Also