SSpread.TypeCheckType Property
In the check box type cell, set the check box type.
Only valid for cells with $CellTypeCheckBox (checkbox type) set in the CellType property. Before setting this property, use the Col and Row properties, and so on to specify what to do. The initial value is a blank character string.
Specify the following values. The initial value is $TypeCheckTypeNormal.
| Constant | Value | Description |
|---|---|---|
| $TypeCheckTypeNormal | 0 | Standard (checked, unchecked) |
| $TypeCheckTypeThreeState | 1 | 3 states (checked, unchecked, gray) |
The state of the check box can be obtained with the Text property and Value property.
(Unchecked = “0”, checked = “1”, gray state = “2”)
This property is subject to property inheritance for checkbox cells.
Example of usage
Col = 3;
Row = 2;
CellType = $CellTypeCheckBox;
TypeCheckType = $TypeCheckTypeThreeState;
BlockMode = $TRUE;
Col = 3;
Row = 3;
Col2 = 5;
Row2 = 5;
CellType = $CellTypeCheckBox;
TypeCheckType = $TypeCheckTypeNormal;
BlockMode = $FALSE;
Related Items
CellType, Text, Value properties