Spread.Sheets Documentation
Setting a Check Box Cell
Spread.Sheets Documentation > Developer's Guide > Managing the User Interface > Working with Cell Types > Setting a Check Box Cell

You can display a check box in a cell using the check box cell. A check box cell displays a small check box that can have one of three states, checked, unchecked, or indeterminate. You can customize the check box by setting the text.

Set the isThreeState method to true to display three states instead of two (checked or unchecked). You can also specify the alignment of the check box and the text with the textAlign method.

You can set the state of the check box in code with the value method as shown in the following table:

Value State
null Indeterminate
0 Unchecked
1 Checked

Using Code

This example creates a check box cell with three states.

JavaScript
Copy Code
var cellType = new GC.Spread.Sheets.CellTypes.CheckBox();
cellType.caption("caption");
cellType.textTrue("True");
cellType.textFalse("False");
cellType.textIndeterminate("Indeterminate");
cellType.textAlign(GC.Spread.Sheets.CellTypes.CheckBoxTextAlign.bottom);
cellType.isThreeState(true);
activeSheet.getCell(1, 1).cellType(cellType);
// activeSheet.getCell(1, 1).value(1);
See Also