DRAW.KNOB
Define a graphical knob on a given drawing.
Syntax
=DRAW.KNOB(X,Y,Width,Height,lineColor,FillColor,AngleLabel,Value,Min,Max,Step,Marker,FormatRange,StartAngle,EndAngle)
Arguments
Name | Description |
---|---|
X | X Coordinate in 1/100th mm |
Y | Y Coordinate in 1/100th mm |
Width | Width in 1/100th mm |
Height | Height in 1/100th mm |
LineColor | Optional. Options: - None for no line - Hexadecimal color value ( #FF0000 for Red) |
FillColor | Optional. - Hexadecimal color value ("#FF0000" for Red) |
Angle | Optional. Angle in radians. |
Label | Label to display |
Value | Optional. 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 | Minimum value displayed in the knob. |
Max | Maximum value displayed in the knob. |
Step | Step to use for interaction while changing the knob value. |
Marker | Optional. Marker style to indicate the current value. Allowed values are: none arrowinner line circlesmall Default is a large circle. |
Return Value
TRUE, if button could be created.
Example
Function | Result | Comment |
---|---|---|
=DRAW.KNOB(8711,14368,9578,3942,,,,"Knob",50,0,100,5,,0,0.52,5.76) | TRUE | A knob with an interval from 0 to 100 and a step value of 5. Current Value is 50. |