Skip to main content
Version: Streamsheets 3.0

DRAW.CHECKBOX

Define a graphical checkbox button on a given drawing.

Syntax

=DRAW.CHECKBOX(X, Y, Width, Height, [LineColor], [FillColor], [Angle], Label, [Value])

Arguments

NameTypeDescription
XNumberX Coordinate in 1/100th mm
YNumberY Coordinate in 1/100th mm
WidthNumberWidth in 1/100th mm
HeightNumberHeight in 1/100th mm
LineColor (optional)ColorLine Color Value

Options:
"none": Invisible
"#FFFFFF": White
"#000000": Black
"#FF0000": Red
"#00FF00": Green
"#0000FF": Blue
"#FFFF00": Yellow
"#AAAAAA": Grey

Default value: "Color derived from theme."
FillColor (optional)ColorFill Color Value

Options:
"none": Invisible
"#FFFFFF": White
"#000000": Black
"#FF0000": Red
"#00FF00": Green
"#0000FF": Blue
"#FFFF00": Yellow
"#AAAAAA": Grey

Default value: "Color derived from theme."
Angle (optional)NumberAngle in radians.

Default value: 0
LabelStringLabel to display
Value (optional)BooleanCurrent state of the button. TRUE for pushed and FALSE for released. If a cell reference is used, a value change from user interaction will be pushed into that cell.

Return

TRUE, if checkbox could be created.

Hint

This function should not be used in a cell

Examples

FormulaResultComment
=DRAW.CHECKBOX(5377,17106,4286,1217,,,,"Checkbox",A1)
TRUEA checkbox with "Checkbox" as label. In A1 TRUE or FALSE is printed, depending on the state of the box.