Skip to main content
Version: Streamsheets 3.0

DRAW.KNOB

Define a graphical knob on a given drawing.

Syntax

=DRAW.KNOB(X, Y, Width, Height, [LineColor], [FillColor], [Angle], Label, [Value], Min, Max, Step, [Marker])

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 Value of the Knob. 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)KnobMarkerMarker style to indicate the current value.

Options:
"none"
"arrowinner"
"line"
"circlesmall"

Default value: "line"

Return

TypeDescription
BooleanTRUE, if button could be created.

Hint

This function should not be used in a cell

Examples

FormulaResultComment
=DRAW.KNOB(8711,14368,9578,3942,,,,"Knob",50,0,100,5,,0,0.52,5.76)
TRUEA knob with an interval from 0 to 100 and a step value of 5. Current Value is 50.