INPUTBOX is a versatile data entry component with a variety of modes which differ by Input Type:
INPUTBOX may take the place of the following data entry objects:
INPUTBOX may provide two data types not found in other data entry objects:
|Label:||Enter text to display to the left of box|
|Input Type:||Select the data type
'Currency' displays Currency Symbol:
'Custom' displays a custom format set in Number Format Code:
'DateTime' selects a date and time with a calendar popup, displayed according to Pattern:
'General' a generic input
'Number' restricts input to a number, an error popup will show if otherwise
'Percentage' accepts numerical value with a percent sign or otherwise as a decimal fraction which will be displayed with percent sign and decimal point moved left two digits
'Text' generic text input
|Default:||Default value to be displayed|
|Range Reference:||NAMED RANGE or existing RANGE REFERENCE to link value to cell in an Excel spreadsheet|
|Label Width:||Width in pixels of Label:|
|Label Style:||Reference to a USER INTERFACE STYLE that controls the visual appearance of this INPUTBOX's label|
|Input Style:||Literal string, a USER INTERFACE STYLE, or an object reference for dynamic CSS-style for input area|
|Show if:||Logical expression, if TRUE then box shown, otherwise not shown|
|Enable if:||Logical expression, if TRUE then box enabled, otherwise not enabled|
|Tool Tip:||Text to display as a tool tip|
|Decimal Places:||Number of decimal places shown|
|Thousand Separator:|| Show a thousands separator? default→FALSE, TRUE
see Regional differences in number formats
|Currency Symbol:||Type of currency symbol (default: $, £, €, ¥ )|
|Pattern:||Format for storage and display of date and time|
|Tab Index:||Establish an order of preference for <TAB> key navigation (default: 0 )
<TAB> delivers focus to Tab Index: 1 then 2 and continues in ascending numerical order
After the highest set Tab Index: value, focus is delivered to Tab Index: 0
Tab Index: -1 will completely exclude this object from <TAB> focus selection
|Characters:||Width of INPUTBOX in characters|
|Show Date Button:||Display a BUTTON next to the calendar selection tool (default: TRUE, FALSE )
only available if Input Type: DateTime
|Number Format Code:||Select the custom number format|
|Delimiter:||Character to delimit object references in Label: and Default: with non-numeric Input Type: (default: % )|
|Rowspan:||Span vertically across more than one cell in a parent LAYOUT PANEL or SUB PANE with Layout: GRID|
|Colspan:||Span horizontally across more than one cell in a parent LAYOUT PANEL or SUB PANE with Layout: GRID|
Input Type: sets the type of data entered by the user. INPUTBOX has cell types compatible with Excel. Once Input Type: has been set for an INPUTBOX then other optional parameters will appear to allow further configuration. The available data types for Input Type: and their effects on the INPUTBOX are shown below.
The value of an INPUTBOX when Input Type: Percentage is the actual decimal value; the displayed value is the actual value multiplied by 100.
|Data Type||Effect||Optional Parameters|
|Currency||Data to be represented as a monetary value preceded by a specific currency symbol when displayed||Decimal Places:
|Custom||Select a custom format as specified in Number Format Code:||Decimal Places:
Number Format Code:
|DateTime||Date and time data to be entered via a popup calendar and shown in the form specified in Pattern:||Pattern:|
|General||Allow any form of data to be entered||-|
|Number||Data to be represented as a number||Decimal Places:
|Percentage||Data may be input with a percentage symbol or treated as a decimal fraction and displayed with the decimal point shifted to the Right two places and a % symbol shown after the number||Decimal Places:|
|Text||Data to be represented as text, even if it is numerical||-|
INPUTBOX formats 'Currency', 'Percentage' and 'Number'-types according to either the US or EU conventions.
The use of commas and periods to format thousands, millions, billions (the 'thousands separator') and decimal fractions less than one (the 'decimal mark') varies by region. EASA has implemented the two most common systems, US and EU.
In the US, commas are used as the 'thousands separator' and periods are used as the 'decimal mark'.
In the EU, periods are used as the 'thousands separator' and commas are used as the 'decimal mark'.
“Two million three hundred forty-three thousand two hundred thirty-two and thirty-four hundredths” is denoted:
For a 'global' toggle between the two number formats for an EASAP's Percentage-/Currency-/Number- type INPUTBOX's, set MENU ACTION:
Once set, all INPUTBOX's will accept input and display numbers in the locally expected convention.
For input 'thousands separator' is optional but 'decimal mark' must be the correct one.
Thousand Separator: parameter of INPUTBOX must be set to true to enable number formatting.