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.
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#.
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 |