| NumericFormat Enumeration |
The valid values for the
Format property.
Namespace: Stingray.GridAssembly: Stingray.GridControl (in Stingray.GridControl.dll) Version: 14.0.0.0
Syntax public enum NumericFormat
Public Enumeration NumericFormat
public enum class NumericFormat
Members
| Member name | Value | Description |
---|
| Default | 0 |
Default numeric formatting.
|
| Float | 1 |
Floating point number.
|
| Fixed | 2 |
Displayed using a fixed number of decimal places.
|
| General | 3 |
Displayed using fixed or scientific, whichever fits.
|
| Dollars | 4 |
Displayed with leading dollar sign and comma separators; negative values in
parentheses.
|
| Comma | 5 |
Displayed with comma separators; negative values in parentheses.
|
| Hex | 6 |
Displayed in hexadecimal notation.
|
| Logic | 7 |
0 is shown as 0, and 1 as 1; all other values are displayed as ?
|
| DayMonthYear | 8 |
Gregorian date (DD-MMM-YY).
|
| DayMonth | 9 |
Day and month (DD-MMM).
|
| MonthYear | 10 |
Month and year (DD-MMM).
|
| Date | 11 |
Displays the date using the format specified in the system settings.
|
| Hidden | 12 |
Cell contents are not displayed.
|
| Time | 13 |
Displays the fractional part of the number as a time using the system settings
format.
|
| Percent | 14 |
A percentage, multiplied by 100.
|
| Text | 15 |
For formula cells, the formula is displayed, rather than the computed value.
|
| InternationalDate | 16 |
A date with the format: DD.MM.YYYY.
|
| ISO8061Date | 17 |
A date with the format: YYYY-MM-DD.
|
| DateTime | 18 |
A date with the format: MM/DD/YY HH:MM.
|
| FixedParens | 23 |
Displayed with fixed number of decimal places; negative values in parentheses.
|
| Fractions | 24 |
Whole number followed by proper fraction.
|
| TimeHourMinuteAMPM | 25 |
A time with the format: HH:MM AM/PM.
|
| TimeHourMinuteSecondAMPM | 26 |
A time with the format: HH:MM:SS AM/PM.
|
| TimeHourMinute | 27 |
A time with the format: HH:MM.
|
Remarks
Numeric formatting only affects cells if the value type is Numeric.
See Also