DRAW.BUTTON
Define a graphical button on a given drawing.
Syntax
=DRAW.BUTTON(X, Y, Width, Height, [LineColor], [FillColor], [Angle], Label, [Value])
Arguments
| Name | Type | Description |
|---|---|---|
| X | Number | X Coordinate in 1/100th mm |
| Y | Number | Y Coordinate in 1/100th mm |
| Width | Number | Width in 1/100th mm |
| Height | Number | Height in 1/100th mm |
| LineColor (optional) | Color | Line 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) | Color | Fill 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 | |
| Label | String | Label to display |
| Value (optional) | Boolean | Current 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
| Type | Description |
|---|---|
| Boolean | TRUE, if button could be created. |
Hint
This function should not be used in a cell
Examples
| Formula | Result | Comment |
|---|---|---|
| TRUE | A button with "Button" as label. A1 turns TRUE as long as the button is pressed. |