|
|
|
|
|
- Overview
- Reminder
- Default input and display mask
- In a window or page
- WEBDEV specific features
- In a report
- Custom input masks
- Examples
- Remarks
- Currency controls
- Differences between the Numeric type and the Currency type
- Currency + Euro control
- Remarks
Numerical or Monetary fields: Edit control or display masks
Reminder WINDEV, WINDEV Mobile and WEBDEV propose two types of masks: - the input masks that define the characters that can be typed in the controls found in a window or in a page. Sometimes, these masks can also be used to modify the case (uppercase/lowercase characters) of the values assigned to the window controls or to the page controls programmatically.
- the display masks that define the characters that can be printed in the controls found in a report.
Default input and display mask In a window or page By default, the input mask corresponds to the one defined for the project: the information defined in the Numerical, Monetary, ... management parameters for the project is automatically taken into account.. Reminder: These parameters are defined for each language in the "Languages" tab of the project description: under the "Proyecto" pane, in the "Proyecto" group, click on "Descripción". The default input masks are as follows: - Numeric defined by the project.
- File size.
Bitcoin. Scientific (exponential) notation. - Percentage.
In a report By default, the input mask: - 999,999.99 is associated with Numeric controls.
- +99,999,999.99 is associated with Currency controls.
- +999,999.99 $ is associated with Currency + Euro controls.
For the Numeric and Currency controls, the input/display masks are defined by the following characters: - 9': number,
- '.': period,
- ', ': comma,
- '+': plus sign (to allow the signed numbers),
- '-': minus sign used at the end of string to display the negative numbers. To display the "-" sign at the end of string no matter whether the number is positive or negative, specify "--".
- ' ': space,
- 0': to the left of the mask, so that the number is automatically completed with zeros (left),
- '%': percentage. The value displayed (assigned through programming for example) is multiplied by 100 and the % symbol is displayed.
To display the % sign without multiplying by 100, simply double the acronym % (example: "99.99%%").. Important: if in previous versions of WINDEV 9, WEBDEV 9 or WINDEV Mobile 9 (Version 90028 or earlier) you used the % character in your input masks, this character is automatically doubled for compatibility.. Example: Mask 99.99%, input value: 19.6, display value: 19.6%, value manipulated by programming: 0.196. Mask 99.99%%, value entered: 19.6, value displayed: 19.6%, value manipulated by programming: 19.6. - '()': brackets, to display negative numbers.
Advanced custom format: You also have the ability to define: - the format of positive numbers
- the format of negative numbers
- the value if 0
- the value if NULL
The format of this type of input/display mask is as follows: <Format des positif>;<Format des négatifs>;<Valeur si 0>;<Valeur si NULL> You can specify a color using [<Color>] next to the desired mask. <Color> can correspond to: - to one of the following constants: Red, Green, Blue, Black, White, Yellow, Orange
- a hexadecimal value in "#BBGGRR" format.
Differences between the Numeric type and the Currency type The masks proposed for the Currency controls have the same type as the numeric masks. The difference lies in precision: the monetary units have 17 significant digits for the integer part and a maximum of 6 decimal places. Currency + Euro control The dollar character ("$") can be added into the mask to display: - the '
' symbol if the current currency is the Euro. - the caption of the currency (defined in the exchange table by eInitCurrency) if the currency differs from the Euro.
For example: the mask '$999.99' will display '250.25  ' if the current currency is the Euro and '250.25 GBP' if the current currency is the Pound Sterling. Note: It's possible to write "$$" to force the use of the acronym $. Remarks - The "++++" value will be displayed in the control if the following conditions are fulfilled:
- assignment programmatically.
- number of digits in the integer part greater than the number of digits in the integer part of the mask.
For example, if the mask is '99.999' and if the value assigned through programming is '123456', the value "++++" will be displayed in the control. - The decimal part will be rounded if the following conditions are fulfilled:
- assignment programmatically.
- number of digits in the decimal part greater than the number of digits in the decimal part of the mask.
For example, if the mask is '99.999,99' and if the value assigned through programming is '12345,159', the value "12345,16" will be displayed in the control.
Esta página también está disponible para…
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|