Skip to main content
Version: Streamsheets 3.0

DRAW.BUTTON

Define a graphical button on a given drawing.

Syntax

=DRAW.BUTTON(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)Angle 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

TypeDescription
BooleanTRUE, if button could be created.

Hint

This function should not be used in a cell

Examples

FormulaResultComment
=DRAW.BUTTON(5801,20056,5292,3625,,,,"Button",A1)
TRUEA button with "Button" as label. A1 turns TRUE as long as the button is pressed.