Can be used in the property formulas to format a number field (see Number Properties).
Can be used in the property formula of property "Number Type" to define the type of a number field.
| Constant | Type | Example |
|---|---|---|
integerNumberFormat |
Whole number only | 123 |
fractionalNumberFormat |
Number including its decimal digits | 123.00 |
percentNumberFormat |
Number multiplied by 100, with a percent sign | %123 |
currencynumberformat |
Number including currency symbol | $ 123 |
useCustomFormat |
Custom format | Allows you to set the format properties yourself. |
Can be used in the property formula of property "Currency Type" to define the type of the currency symbol (no symbol, fixed, floating).
| Constant | Example |
|---|---|
noCurrencySymbol |
123.45 |
| $ 123.45 $ 123 |
|
floatingCurrencySymbol |
$ 123 $ 123.345 |
Can be used in the property formula of property "Currency Position" to specify where to show the currency symbol relative to number and sign.
| Constant | Example |
|---|---|
leadingCurrencyInsideNegative |
$-123.45 |
leadingCurrencyOutsideNegative |
-$123.45 |
trailingCurrencyInsideNegative |
-123.45$ |
trailingCurrencyOutsideNegative |
-123.45$ |
Can be used in the property formula of property "Negatives" to specify the style for negatives.
| Constant | Example |
|---|---|
noNegativeSign |
123.45 |
leadingMinus |
-123.45 |
trailingMinus |
123.45- |
bracketedNegatives |
(123.45) |
i-net software strives to provide accurate product documentation. Please give us your feedback using the form below.
NOTE: This form is for documentation feedback only. For technical assistance, please send an email to crystalclear@inetsoftware.de.