cellType Method

Gets or sets the cell type of the cell.

Syntax

Javascript (Usage)
Javascript (Specification)

var instance = new GC.Spread.Sheets.CellRange(sheet, row, col, rowCount, colCount, sheetArea);
var returnValue; // Type: any
returnValue = instance.cellType(value);

function cellType( 
   value : Base
) : any;

Parameters

value: The cell type.

Return Value

If no value is set, returns the cell type; otherwise, returns the cell.

Example

The following examples create check box cells.

Javascript

activeSheet.getRange(1, -1, 1, -1, GC.Spread.Sheets.SheetArea.viewport).cellType(new GC.Spread.Sheets.CellTypes.CheckBox());

Javascript

activeSheet.getCell(1, 1).cellType(new GC.Spread.Sheets.CellTypes.CheckBox());

Javascript

activeSheet.getRange(-1, 1, -1, 1, GC.Spread.Sheets.SheetArea.viewport).cellType(new GC.Spread.Sheets.CellTypes.CheckBox());

Reference

CellRange type
Working with Cell Types