Checkbox - Bool type and Check side icon

FastGrid documentation

Bool type

Bool is boolean type contains usually two values 0 (off) and 1 (on), optionally with the third state -1 (unknown).
It can also show numbers up to 999 and cycle some of them on click.
It is shown as checkbox or radio button.
It supports radio groups - only one radio inside group can be checked.
Bool type can be set by Type = "Bool".
Auto type never sets Bool type, but it can show the TRUE and FALSE textual constants, if set AutoBool.
The permitted values for Bool type are: 1 (or any positive) - on, 0 (or false/NaN/null/"") - off, -1 (or any negative) unknown state.
The icon shown, it can be "Check" for squared checkbox and "Radio" for round radio button. If set to "", it hides the Bool icon.
Text displayed next to the check box, according to the Align.
Remember, the Text can be calculated by Formula in DefCells according to the actual value.

Check side icon

Side icon "Check" is shown in cell side icons as check box.
Side icon "Check can be added to cell LeftIcons, RightIcon and TextIcons, like LeftIcons: "Check"
The boolean value for the icon state is read from and written to column set by CheckCol.
The boolean value has usually one of two values 0 (off) and 1 (on), optionally with the third state -1 (unknown).
It can also show numbers up to 999 and cycle some of them on click.
Column id where the Check icon reads and writes its value. It is usually hidden column.
If not set, the Check icons shows / changes the value of its own cell.
The BoolMin, BoolMax, BoolCycle, BoolTree and NoEdit attributes for the Check icon are read also from the column CheckCol.
The icon shown, it can be "Check" for squared checkbox and "Radio" for round radio button.

Attributes for Bool type and Check side icon

For Check side icon these attribute are set in the column set by CheckCol, not in the cell where the Check icon is shown!
Minimal value permitted for the check box. The permitted range is: -1000 <= BoolMin < BoolMax <= 1000.
If the cell value is less or equal BoolMin, the [?] is shown.
If the cell value is between BoolMin and BoolMax and is not zero, the number is displayed in the check box.
Maximal value permitted for the check box. The permitted range is: -1000 <= BoolMin < BoolMax <= 1000.
If the cell value is greater or equal BoolMax, the [x] is shown.
If the cell value is between BoolMin and BoolMax and is not zero, the number is displayed in the check box.
How the Bool type or CheckCol cell changes its value on check box click, if cycles two, three or more values and how.
It chooses value among BoolMin (Min), 0 (Zero), BoolMax (Max).

-1 - sets only Max (for RadioRow / RadioCol)
0 - switches between Zero / Max. For others sets Max.
1 - switches between Zero / Max. For others sets Zero.
2 - cycles Min / Zero / Max / Min / Zero / Max. Ignores Zero if it is not between Min and Max.
3 - cycles Max / Zero / Min / Max / Zero / Min. Ignores Zero if it is not between Min and Max.
4 - cycles from Zero to Max.
5 - cycles from Max to Zero.
6 - cycles from Min to Zero to Max. From Max switches to Min and repeats cycle.
7 - cycles from Max to Zero to Min. From Min switches to Max and repeats cycle.
8 - cycles from Zero to Max-1.
9 - cycles from Max-1 to Zero.
10 - cycles from Min+1 to Zero to Max+1. From Max-1 switches to Min+1 and repeats cycle.
11 - cycles from Max-1 to Zero to Min-1. From Min+1 switches to Max-1 and repeats cycle.
array - cycles among the values in the array. For last or unknown item chooses the first item.
If set, it sets the same value (0 / 1) to all its children with BoolTree set and resets BoolCycle to 1.
0 - no, 1 - row parents and children in the same column, 2 - column parents and children in the same row.

To calculate parent rows check boxes according to their children, use sumbool or countbool function in cell F / Formula.
For example { id:"Col1", BoolTree:1, Formula:"sumbool(null,null,null,64)" }.
Optionally set BoolMin = -1000 to show sum of children in red if some child is zero.
Optionally set BoolMax = 1000 to show sum of children in blue if all the children are positive.
For Bool type it slightly differs from standard FilterOff attribute.
After which Bool value in BoolCycle follows FilterOff value.
Only one check box with the same RadioRow can be on in its row.
To restrict unchecking all check boxes in row set BoolCycle = -1.
Only one check box with the same RadioCol can be on in its column.
To restrict unchecking all check boxes in row set BoolCycle = -1.
Strings exported instead of Bool values.
Strings converted to Bool values for import.
Sets the Bool type or CheckCol cell value to value.
changes specify how to change will be marked, see SetValue.
Unlike SetValue it does not differ between zero values (0 == false == "" == NaN and 1 == true).
It updates also other boolean cells according to BoolTree, RadioRow, RadioCol.
Returns true if the value was changed, false if the value is the same as the cell value (no change was done) and null for error.
Changes the Bool type or CheckCol cell value according to the cycle or BoolCycle.
changes specify how to change will be marked, see SetValue.
Returns true if the value was changed, false if the value is the same as the cell value (no change was done) and null for error.
Changes the Bool type or CheckCol cell value according to the cycle or BoolCycle.
The icon is "Check" if the cell has set CheckCol otherwise it is "Bool".
The icon can be set to the specific icon name (in LeftIcons / RightIcons / TextIcons), if the cell has set more check box icons.