Spread Windows Forms 17
Spread Windows Forms 17.0 Product Documentation / Developer's Guide / Cell Types / Understanding How Cell Types Work
In This Topic
    Understanding How Cell Types Work
    In This Topic

    You can specify the cell type for an individual cell, a range of cells, columns, rows, or an entire sheet using named styles. Object Parentage is also applied to the cell type. The closer to the cell level, the higher the precedence.

    Using Code

    Create the cell type you want to apply and set it in the CellType property of named style and each object. CellType property can be set for the following objects:

    Objects Class Property
    Cell Cell Class CellType Property
    Column Column Class CellType Property
    Row Row Class CellType Property
    Alternating rows AlternatingRow Class CellType Property
    Named style NamedStyle Class CellType Property

    You can also determine the cell type of the active cell using GetCellType method of SheetView class. You can check the cell type using the typeof operator in Visual Basic and is operator in C#.

    Example

    This example code sets the cell type for rows, columns and specific cells.

    C#
    Copy Code
    // Set general cell in the entire first row.
    fpSpread1.ActiveSheet.Rows[0].CellType = new FarPoint.Win.Spread.CellType.GeneralCellType();
    
    // Set button cell for the entire second column.
    FarPoint.Win.Spread.CellType.ButtonCellType buttonCell = new FarPoint.Win.Spread.CellType.ButtonCellType();
    buttonCell.Text = "Button";
    fpSpread1.ActiveSheet.Columns[1].CellType = buttonCell;
    
    // Set date-time cell only for the first row and first column.
    FarPoint.Win.Spread.CellType.DateTimeCellType datecell = new FarPoint.Win.Spread.CellType.DateTimeCellType();
    datecell.DateTimeFormat = FarPoint.Win.Spread.CellType.DateTimeFormat.ShortDate;
    fpSpread1.ActiveSheet.Cells[0, 0].CellType = datecell;
    fpSpread1.ActiveSheet.Cells[0, 0].Value = System.DateTime.Now;
    
    Visual Basic
    Copy Code
    ' Set general cell in the entire first row.
    FpSpread1.ActiveSheet.Rows(0).CellType = New FarPoint.Win.Spread.CellType.GeneralCellType()
    
    ' Set button cell for the entire second column.
    Dim buttonCell As New FarPoint.Win.Spread.CellType.ButtonCellType()
    buttonCell.Text = "Button"
    FpSpread1.ActiveSheet.Columns(1).CellType = buttonCell
    
    ' Set date-time cell only for the first row and first column.
    Dim datecell As New FarPoint.Win.Spread.CellType.DateTimeCellType()
    datecell.DateTimeFormat = FarPoint.Win.Spread.CellType.DateTimeFormat.ShortDate
    FpSpread1.ActiveSheet.Cells(0, 0).CellType = datecell
    FpSpread1.ActiveSheet.Cells(0, 0).Value = System.DateTime.Now
    
    See Also