- How to define advanced general settings for Number column types
- Select Advanced from the column poppup context menu to view the advanced General tab for the column
- 1 and 2) Utilize the Minmum Value and Maximum Value settings if you want to limit the data entered to a specific range of whole numbers. Enter the min and max value you wish to limit the data to.
- 3) The Rendered Leading Text is text that you want displayed in front of the actual data. The text will not be part of the actual column's value, only displayed.
- 4) The Rendered Trailing Text is text that you want displayed at the end of the actual data. The text will not be part of the actual column's value, only displayed.
- 5) The Format Pattern is utilized to specify the Java number format expression, for example: $###,###.## would be rendered as USD currency rounded to the hundredths decimal place. See the Java number formatting pattern api documentation for additional details on this feature's capabilities.
|
