Skip to main content
Version: Streamsheets 3.0

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

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)NumberCurrent 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.
MinNumberMinimum value displayed in the knob.
MaxNumberMaximum value displayed in the knob.
StepNumberStep to use for interaction while changing the knob value.
Marker (optional)SliderMarkerMarker style to indicate the current value.

Options:
"none"
"arrowtop"
"arrowbottom"
"circlesmall"
"circlelarge"
"rect"
"square"

Default value: "circlelarge"
FormatRange (optional)RangeCell 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

TypeDescription
BooleanTRUE, if slider could be created.

Hint

This function should not be used in a cell

Examples

ABC
10Bad#FF0000
230Average#00FF00
370Good#0000FF
FormulaResultComment
=DRAW.SLIDER(51800,20705,14314,6509, "#AAAAAA","#DDDDDD",,"Slider", A1,0,100,5,,D11:F13)
TRUEDraw 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.