- Excel Desktop Client new !
REALBOX creates a data entry box for users to input a real number.
Below is an example of a REALBOX with Units: set as it might appear on the user interface.
|Default:||Default value to be displayed, expression allowed. default→0|
|Label:||Text displayed to the left of box|
|Range Reference:||Select NAMED RANGE or existing RANGE REFERENCE to link value to cell in an Excel spreadsheet|
|Upper Bound:||Upper bound on REALBOX value, expression allowed|
|Lower Bound:||Lower bound on REALBOX value, expression allowed|
|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|
|Type:||Used for web browser client to disable input but allow value to be updated during application usage.|
|Units:||Select from list of all available dimensional groups|
|Number Format:||Number format displayed in box. default→6.4g|
|Label Width:||Width in pixels of Label:|
|Characters:||Width of INPUTBOX in characters|
|Style:||A literal string, a USER INTERFACE STYLE, or an object reference for dynamic CSS-style to apply to the whole object|
|Input Style:||A literal string, a USER INTERFACE STYLE, or an object reference for dynamic CSS-style to apply to the input area|
|Delimiter:||Character to delimit object references on Label: and Default: above, when|
is non-numeric. default→%.
A REALBOX allows an upper and lower bound on user input defined by Upper Bound: and Lower Bound:. This capability is useful for keeping inputs from users sensible and thus keeping an EASAP running reliably.
If a User enters a value outside of the bounds, an error message is displayed.
After all inputs are within acceptable bounds the EASAP may be submitted by the user to run.
The Tool Tip: for a REALBOX automatically shows the bounds that have been set, below.
Since real numbers are often associated with a measurement of some kind, the ability to show users the unit of measure and even provide them with a choices of units is available when defining a REALBOX via the Units: parameters. See Use of Units.
The number format displayed within a REALBOX can be specified within the Number Format: parameter. There are three different formats available within a real box:
The default for a REALBOX is the 'Mixed' format of 6.4g