A control drawn in the cells of a range, such as a checkbox.
Remarks
A cell control decorates the cell's value; it never holds one. A checkbox draws TRUE as
checked and FALSE or blank as unchecked, and a click writes the boolean into the cell, where
formulas read it as any other value. Excel's model is the same: the checkbox is a cell
format, and Clear Formats removes it while the value stays.
A cell has at most one control. One control covers any number of cells, and its ranges
shift, split, copy and fill with them.
A control draws only the values its type accepts (isAccepted). Any other value draws
as plain text: a checkbox over 2 or "true" draws 2 or true, as in Excel.
A control drawn in the cells of a range, such as a checkbox.
Remarks
A cell control decorates the cell's value; it never holds one. A checkbox draws
TRUEas checked andFALSEor blank as unchecked, and a click writes the boolean into the cell, where formulas read it as any other value. Excel's model is the same: the checkbox is a cell format, and Clear Formats removes it while the value stays.2or"true"draws2ortrue, as in Excel.Range.setControl/getControl.See
Interface
ICellControl
Additional Interfaces