Format
In FancyGrid formatting depends on localization.
About localization read Localization
Number format
To enable local number formatting, it requires to set column property format: 'number'
.
Example
columns: [{
title: 'Salary',
index: 'salary',
format: 'number'
...
Date format
By default date formatting is set to local, no special config is required.
If requires some special formatting for read/write/edit date that needs to set it over property format
Universal date formatting
columns: [{
title: 'Birthday',
index: 'birthday',
format: 'm.d.Y'
...
Configuring date formatting
columns: [{
title: 'Birthday',
index: 'birthday',
format: {
read: 'm.d.Y',
write: 'Y.m.d',
edit: 'd/m/Y'
}
...
List of supported formats
SQL date formatting
columns: [{
title: 'Birthday',
index: 'birthday',
format: {
mode: 'sql',
read: 'YYYY-mm-dd',
write: 'YYYY-mm-dd',
edit: 'YYYY-mm-dd'
}
...