This enumeration lists the valid values for the Style.Format property.
Numeric formatting only affects cells if the value type is Numeric.
Member Name | Description |
---|---|
DateTime | MM/DD/YY HH:MM. |
Date | Displays the date using the format specified in the system settings. |
Default | Default numeric formatting. |
Time | Displays the fractional part of the number as a time using the system settings format. |
TimeHourMinute | HH:MM. |
TimeHourMinuteSecondAMPM | HH:MM:SS AM/PM. |
TimeHourMinuteAMPM | HH:MM AM/PM. |
Fractions | Whole number followed by proper fraction. |
FixedParens | Displayed with fixed number of decimal places; negative values in parentheses. |
ISO8061Date | YYYY-MM-DD. |
InternationalDate | DD.MM.YYYY. |
Text | For formula cells, the formula is displayed, rather than the computed value. |
Percent | A percentage, multiplied by 100. |
Hidden | Cell contents are not displayed. |
MonthYear | Month and year; DD-MMM. |
DayMonth | Day and month; DD-MMM. |
DayMonthYear | Gregorian date; DD-MMM-YY. |
Logic | 0 is shown as 0, and 1 as 1; all other values are displayed as ? |
Hex | Displayed in hexadecimal notation. |
Comma | Displayed with comma separators; negative values in parentheses. |
Dollars | Displayed with leading dollar sign and comma separators; negative values in parentheses. |
General | Displayed using fixed or scientific, whichever fits. |
Fixed | Displayed using a fixed number of decimal places. |
Float | Floating point number. |
Namespace: Stingray.Grid
Assemblies: Stingray.GridControl80 (in Stingray.GridControl80.dll)
Stingray.GridControl90 (in Stingray.GridControl90.dll)
Stingray.GridControl10 (in Stingray.GridControl10.dll)