vpGrid handles the following types of column:

  • string

  • note

    • Enables to input comments on several lines. Editing experience is not disruptive when inline editing the cell (for example you can type the Enter key to enter a new line. Typing the Enter key will not finish the edition; you can also use the arrow keys to navigate in your text);
    • A note column is rendered as a TEXTAREA element in edit mode. 
  • currency

    • Enables to display a number as a currency with monetary symbol automatically added;
    • Enables to edit a number according to custom globalisation parameters (see jqGridOptions below);
    • Format of the cell when displaying, editing and validating is configured through the options object passed to the vpGrid.init() method:
      • jqGridOptions: { jgrid: { formatter: {  currency: { decimalSeparator: ",", thousandsSeparator: " ", decimalPlaces: 2, prefix: "", suffix: " €", defaultValue: '0' } } } }
  • integer

    • Enables to display a number as an integer;
    • Enables to edit a number according to custom globalisation parameters (see jqGridOptions below);
    • When in edition mode, the user can only input integers. All other formats are rejected;
    • Format of the cell when displaying, editing and validating is configured through the options object passed to the vpGrid.init() method:
      • jqGridOptions: { jgrid: { formatter: { integer: { thousandsSeparator: ",", defaultValue: '0' } } } }
  • number

    • numbers are rendered through customizable options.
  • link

    • Links are rendered by listening to the event onLinkCellRendering.
  • date

    • Enables to show a date in a specified format. In edition mode, the jQuery UI datepicker is automatically bound (with customizable options) to the input field.
  • year

    • Enables to show a year in the format yyyy (2014 for example) and automatically generates a select with a range of predefined years in a Select DOM element.
  • image

    • images are rendered by listening to the event onImageCellRendering.
  • key

    • This columns holds the key of the business entity shown in the row. The entity key is any string that uniquely identifies the entity on server side (it could be for example a primary key in a database). 

Last edited Aug 10, 2014 at 4:43 PM by HenridOrgeval, version 12