DRAW.SLIDER
Define a graphical slider on a given drawing.
Syntax
=DRAW.SLIDER(X, Y, Width, Height, [LineColor], [FillColor], [Angle], Label, [Value], Min, Max, Step, [Marker], [FormatRange])
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) | Number | Angle in radians. Default value: 0 |
| Label | String | Label to display |
| Value (optional) | Number | 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. |
| Min | Number | Minimum value displayed in the knob. |
| Max | Number | Maximum value displayed in the knob. |
| Step | Number | Step to use for interaction while changing the knob value. |
| Marker (optional) | SliderMarker | Marker style to indicate the current value. Options: "none" "arrowtop" "arrowbottom" "circlesmall" "circlelarge" "rect" "square" Default value: "circlelarge" |
| FormatRange (optional) | Range | Cell range to provide additional scale information. It must be a range with 3 columns. The values in the first column provides a scale value. The value in the second column provides a label, that is displayed instead of the scale value. This is optional. The value in the third column can provide a hexadecimal color value. This is used to color the scale between the last value and the current value in column one. This way you can define a colored scale indicating valid, invalid oder desired values ranges. See the sample below. |
Return
| Type | Description |
|---|---|
| Boolean | TRUE, if slider could be created. |
Hint
This function should not be used in a cell
Examples
| A | B | C | |
|---|---|---|---|
| 1 | 0 | Bad | #FF0000 |
| 2 | 30 | Average | #00FF00 |
| 3 | 70 | Good | #0000FF |
| Formula | Result | Comment |
|---|---|---|
| TRUE | Draw a slider with an interval from 0 to 100 and a step value of 5. As a format range is given, the slider scale will be colored and custom labels will be applied. The selected value will be pushed into cell A1. |