Cellstyler for a subgrid

[stephenl]

Hello

I am trying to apply a format, to the cell of a sub grid.

The format should add a comma to seperate thousands, and also change the text to RED if the value is less than 0.

Suggestions would be appreciated

Thank you

[jarry]

Define a 'formatter' function on the column, change its colour on some conditions. Please refer to this code:

Code:

onExpandRow: function(index,row){
  var ddv = $(this).datagrid('getRowDetail',index).find('table.ddv');
  ddv.datagrid({
    url:'datagrid22_getdetail.php?itemid='+row.itemid,
    fitColumns:true,
    singleSelect:true,
    rownumbers:true,
    loadMsg:'',
    height:'auto',
    columns:[[
      {field:'orderid',title:'Order ID',width:200},
      {field:'quantity',title:'Quantity',width:100,align:'right',
        formatter(value){
          if (value<0){
            return '<span style="color:red">'+value+'</span>'
          } else {
            return value;
          }
        }
      },
      {field:'unitprice',title:'Unit Price',width:100,align:'right'}
    ]],

[stephenl]

Works Great !
Thank you !

[stephenl]

Hello

I now need to align the column values to the right, but would like to leave the column header aligned to the centre..

I have tried adding align:right to the formatter however this seems to be ignored ??
 
columns:[[
      {field:'orderid',title:'Order ID',width:200},
      {field:'quantity',title:'Quantity',width:100,align:'center',
        formatter(value){
          if (value<0){
            return '<span style="color:red;align:right">'+value+'</span>'
          } else {
            return '<span style="align:right">'+value+'</span>'
          }
        }
      },

Any suggestions ?
Thank you

[stephenl]

Solved - just spotted parameter.....halign:centre !