- Excel Desktop Client new !
INPUTBOX is a versatile data entry component that with a variety of modes depending on the setting of Input Type:
INPUTBOX may take the place of the following data entry objects:
Additionally, an INPUTBOX can provide two data types not found in other data entry objects:
Finally, INPUTBOX formats Currency, Percentage and Number-types according to either the US or EU conventions (see Regional differences in number formats, below).
|Label:||Text displayed to the left of box|
|Input Type:||Select the data type.|
|Default:||Default value to be displayed|
|Range Reference:||Select NAMED RANGE or existing RANGE REFERENCE to link value to cell in an Excel spreadsheet|
|Label Width:||Width in pixels of Label:|
|Label Style:||A reference to a USER INTERFACE STYLE that controls the visual appearance of INPUTBOX's label.|
|Input Style:||A literal string, a USER INTERFACE STYLE, or an object reference for dynamic CSS-style to apply to the input area|
|Show if:||Logical expression, if TRUE then box shown, if FALSE then box NOT shown|
|Enable if:||Logical expression, if TRUE then box enabled, if FALSE then box NOT enabled|
|Tool Tip:||Text to be displayed as a tool tip|
|Decimal Places:||The number of decimal places shown|
|Thousand Separator:||Select whether to show a thousands separator (default→FALSE, TRUE).
See Regional differences in number formats.
|Currency Symbol:||Select the currency symbol (default→$, £, €, ¥)|
|Pattern:||Select a format for storage and display of date and time|
|Tab Index:||Establish an order of preference for <TAB> key navigation
<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
By default→Tab Index:0
|Characters:||Width of INPUTBOX in characters|
|Show Date Button:||When set to TRUE, a BUTTON will be displayed next to the object which allows selection from a calendar. Only available if Input Type: DateTime. (default→TRUE)|
|Number Format Code:||Select the custom number format to show.|
|Delimiter:||Character to delimit object references in Label: and Default: above, with non-numeric Input Type:
Child objects of INPUTBOX:
|CONDITIONAL FORMATTING||Changes the appearance of an INPUTBOX if a certain condition applies.|
|DATA VALIDATION||Defines what data is allowed to be entered by users.|
|PARAMETRIC RANGE||Performs parametric studies with an EASAP.|
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||Sets the data entered to be a number that|
will be shown with the specified currency
symbol to the left of the number
|Custom||Set the data entered to be a custom format|
as specified by the selected format in the
Number Format Code: parameter
Number Format Code:
|DateTime||Sets the data entered to be a date and/or|
time stored and shown in the form
specified by the Pattern: parameter
|General||Allows any form of data to be entered||-|
|Number||Sets the data entered to be a number||Decimal Places:
|Percentage||Sets the data entered to be a number|
represented as a percentage with
% symbol shown after the number
|Text||Sets data entered will be treated as text,|
even if it is numerical
|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: allows Currency, Number or Percentage. 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”
For a 'global' toggle between the two number formats for all an EASAP's Percentage, Currency and Number-type INPUTBOX's, set MENU ACTION's parameters below:
Thus INPUTBOX 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, following a
Thousand Separator: parameter of INPUTBOX must be set to true to enable Number Formatting.