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'
  }
...
List of supported formats