Click or drag to resize
NumericFormat Enumeration
The valid values for the Format property.

Namespace: Stingray.Grid
Assembly: Stingray.GridControl (in Stingray.GridControl.dll) Version: 14.0.0.0
Syntax
public enum NumericFormat
Members
  Member nameValueDescription
Default0 Default numeric formatting.
Float1 Floating point number.
Fixed2 Displayed using a fixed number of decimal places.
General3 Displayed using fixed or scientific, whichever fits.
Dollars4 Displayed with leading dollar sign and comma separators; negative values in parentheses.
Comma5 Displayed with comma separators; negative values in parentheses.
Hex6 Displayed in hexadecimal notation.
Logic7 0 is shown as 0, and 1 as 1; all other values are displayed as ?
DayMonthYear8 Gregorian date (DD-MMM-YY).
DayMonth9 Day and month (DD-MMM).
MonthYear10 Month and year (DD-MMM).
Date11 Displays the date using the format specified in the system settings.
Hidden12 Cell contents are not displayed.
Time13 Displays the fractional part of the number as a time using the system settings format.
Percent14 A percentage, multiplied by 100.
Text15 For formula cells, the formula is displayed, rather than the computed value.
InternationalDate16 A date with the format: DD.MM.YYYY.
ISO8061Date17 A date with the format: YYYY-MM-DD.
DateTime18 A date with the format: MM/DD/YY HH:MM.
FixedParens23 Displayed with fixed number of decimal places; negative values in parentheses.
Fractions24 Whole number followed by proper fraction.
TimeHourMinuteAMPM25 A time with the format: HH:MM AM/PM.
TimeHourMinuteSecondAMPM26 A time with the format: HH:MM:SS AM/PM.
TimeHourMinute27 A time with the format: HH:MM.
Remarks
Numeric formatting only affects cells if the value type is Numeric.
See Also