Input Value

This article describes the value input component and its properties.

The value input allows a user to either type in a value or alter it using up and down arrows.

Select Value Input from the controls category of the component library. Move the mouse over the canvas and click to add the component to your project:

Value Input Properties

The Value input properties are organized into, STYLING,  and DYNAMIC VISIBILITY drawers. This guide will describe the data insertion and styling properties only; the dynamic visibility properties are generic and a separate guide and tutorial on dynamic visibility can be found here.

The component properties are set and edited using different methods, some have multiple methods, some just one. See this Set property values article for more information on using the different methods.

DATA INSERTION:

• Value – This property is the value which is controlled by the value input. This should be bound to a cell in the spreadsheet. The value in the spreadsheet will update and be updated by the component’s value.
• Step Size – the size of the change in the value caused by the up/down arrow buttons (if enabled)
• Enable limits – determines is there are limits to the values which can be input
• Min / Max – These properties determine the minimum and maximum values the user can enter using the component.

STYLING:

The appearance of the slider can be altered to suit a theme or particular style by using the STYLING properties.

Hide Up / Down arrows – this determines whether the component shows up and down arrows which allow the user to click to increase od decrease the value

VALUE

These properties apply to the value displayed by the component

• Font – The fonts used for the labels.
• Size – The size of the font of the labels.
• Text Colour – The colour of the text of the labels..
  • Opacity – This opacity of the text of the labels.
• Number format – This property determines how the displayed value is formatted. Note:
  • • selecting number, percentage or currency provide a extra option to set the number of decimal places displayed
    • selecting currency also provides an option to set the currency character and in the case of a custom character whither it should come before or after the number
    • when percentage is selected the component treats the value in the cell as fractional, i.e. 0.1 to represent 10%, 0.5 to represent 50% etc.  However, the other values in the property sheet (Min, Max and Step Size) should are treated as percentages, ie 10 for 10% and 50 for 50%.

BACKGROUND

These formatting properties apply to the handle of the slider

• Fill – the colour of the body of the component
  • Opacity – the opacity of the body of the component
• Border – the colour of the outline of the component
  • Opacity – the opacity of the outline of the component