User Tools

Site Tools


Guide Section: An EASAP GUI

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:

  • Currency
  • Percentage

Optional Parameters:
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

Child objects of INPUTBOX
CONDITIONAL FORMATTINGChange the appearance of an INPUTBOX if a certain condition applies.
DATA VALIDATIONDefine what data is allowed to be entered by users
PARAMETRIC RANGEperform parametric studies with an EASAP

Input Type:

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
CurrencyData to be represented as a monetary value preceded by a specific currency symbol when displayedDecimal Places:
Currency Symbol:
CustomSelect a custom format as specified in Number Format Code:Decimal Places:
Thousand Separator:

Currency Symbol:
Number Format Code:
DateTimeDate and time data to be entered via a popup calendar and shown in the form specified in Pattern: Pattern:
GeneralAllow any form of data to be entered-
Number Data to be represented as a numberDecimal Places:
PercentageData 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 numberDecimal Places:
TextData to be represented as text, even if it is numerical-

Regional differences in number formats

INPUTBOX formats 'Currency', 'Percentage' and 'Number'-types according to either the US or EU conventions.

'Thousands Separator' and 'Decimal Mark'