You can convert the raw values appearing in any column of the FlexGrid into different formats. FlexGrid supports standard .NET format strings used to display numeric values as local currency, percentages, dates, and more. Formatting only applies to display value of a cell and does not affect the underlying data.
You can specify a column's format by setting its Format property to a valid string. The string should contain one or two characters from a known list of formats. The first character specifies the format (format specifier) while the second optional character specifies precision (precision specifier). For example, the following format string converts a raw value to display local currency up to 2 decimal places.
The following code example demonstrates how to specify a column's format in C#. The example uses the sample created in the Quick start section.
|
Copy Code
|
|
|---|---|
grid.Columns["OrderTotal"].Format = "N2"; |
|
The format strings are not case sensitive. The following table lists the numerical format strings that FlexGrid currently supports.
| Format Specifier | Name | Precision Specifier | Example |
| "C" or "c" | Currency | Number of decimal digits | 123.4567 (C2) à $123.46 |
| "D" or "d" | Decimal | Minimum number of digits | 1234 (D6) à 001234 |
| "E" or "e" | Exponential | Number of decimal digits | 1,234 (E2) à 1.23E3 |
| "F" or "f" | Fixed Point | Number of decimal digits | -1234.56 (F4) à -1234.5600 |
| "G" or "g" | General | Number of significant digits | 123.45 (G4) à 123.5 |
| "N" or "n" | Number | Desired number of decimal places | 1234 (N1) à 1234.0 |
| "P" or "p" | Percent | Desired number of decimal places | 1 (P2) à 100.00% |
| "X" or "x" | Hexadecimal | Desired number of digits in the result | 123 (X2) à 7B |
FlexGrid also supports custom date and time format strings that allow you to display date and time values in numerous ways. For example, the format string below converts the default format (MM/dd/yy) to "yyyy-MM" format.
|
Copy Code
|
|
|---|---|
grid.Columns["Hired"].Format = "yyyy-MM"; |
|
The DateFormat string is created using a combination of format specifiers. The following table lists some common format specifiers for creating custom date and time strings.
| Format Specifier | Description | Example |
| "d" | Day of the month | 1 |
| "dd" | Day of the month | 01 |
| "ddd" | Abbreviated day of the week | Mon |
| "dddd" | Full day of the week | Monday |
| "h" | The hour using 12-hour clock | 1 |
| "hh" | The hour using 12-hour clock | 01 |
| "H" | The hour using 24-hour clock | 13 |
| "HH" | The hour using 24-hour clock | 13 |
| "m" | Minute of time | 1 |
| "mm" | Minute of time | 01 |
| "M" | Month number | 1 |
| "MM" | Month number | 01 |
| "MMM" | Abbreviated month name | Mar |
| "MMMM" | Full month name | March |
| "s" | Second of time | 1 |
| "ss" | Second of time | 01 |
| "tt" | The AM/PM Designator | AM |
| "yy" | Abbreviated year | 16 |
| "yyyy" | Full year | 2016 |
| "\" | Escape character | H/H => 13H |
| Any other character | The character is copied to the result string | yyyy-MM => 2016-03 |
