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
| 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
TRUE, if button could be created.
Hint
This function should not be used in a cell
Examples
| Formula | Result | Comment |
|---|---|---|
| TRUE | A knob with an interval from 0 to 100 and a step value of 5. Current Value is 50. |