DRAW.SLIDER

Define a graphical slider on a given drawing.

Syntax

=DRAW.SLIDER(UniqueID, Container, Name, X, Y, Width, Height, LineFormat, FillFormat, Angle, Attributes, Events, Angle, RotCenter, Label, LabelFont, Value, Min, Max, Step [,ScaleFont, Marker, FormatRange])

Arguments

NameDescription
UniqueIdUnique Id of drawing object. Should not be modified and must be unique.
ContainerOptional. Name of the container object this object is placed within. Coordinates are relative then.
NameName of drawing object. Must be unique.
XX Coordinate in 1/100th mm
YY Coordinate in 1/100th mm
WidthWidth in 1/100th mm
HeightHeight in 1/100th mm
LineFormatOptional. Options:
- None for no line
- Hexadecimal color value (#FF0000 for Red)
- JSON String created using lineformat
FillFormatOptional. Options:
- "None" for no fill
- Hexadecimal color value ("#FF0000" for Red)
- JSON String created using FILLPATTERN, FILLLINEARGRADIENT, FILLRADIALGRADIENT
AttributesOptional. JSON String created using ATTRIBUTES
EventsOptional. JSON String created using EVENTS
AngleOptional. Angle in radians.
RotCenterOptional. This defines, where the object rotates around:
0: Top left corner
1: Top center
2: Top right corner
4: Center (default)
5: Right center
6: Bottom left corner
7: Bottom center
8: Bottom right corner
LabelLabel to display
LabelFontOptional. Options:
- "None" for no fill
- Hexadecimal color value ("#FF0000" for Red)
- JSON String created using FONTFORMAT
ValueOptional. 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.
MinMinimum value displayed in the slider.
MaxMaximum value displayed in the slider.
StepStep to use for interaction while changing the slider value.
ScaleFontOptional. Font to use for the slider scale. JSON String created using FONTFORMAT
MarkerOptional. Marker style to indicate the current value. Allowed values are:
none
square
line
rect
arrowtop
arrowbottom
circlesmall
Default is a large circle.
FormatRangeOptional. 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 Value

TRUE, if slider could be created.

Example

FunctionResultComment
=DRAW.SLIDER("ID1",,"Slider1",1000,1000,1000,2500,,,
,,,,"Slider",,A1,0,100,10,,"arrowbottom",D11:F13)
TRUEDraw a slider with an interval from 0 to 100 and a step value of 10. 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.
ROWDEF
110Bad#FF0000
1230Average#00FF00
1370Good#0000FF