<p>Thank you Will. </p><p>It is not about creating a method, but having a button show on the navgrid whenever any grid is rendered without having to add it with every grid. For example, would like to add a button for export to excel automatically similar to refresh, edit, add, delete which always shows on the navgrid.</p><p>Kris</p>

Just want to see if it possible to get – filtered data

Kris

Yes, I knew about that solution, wanted it to more seamless..

Thank you! look forward to hearing from you.

Kris

<p>Hello Will,</p><p>Thats great subGridRowExpanded – I can add multiple subgrid one below the other. This however is not feasable usability wise as it requires user to scroll a lot. I was wondering if there is possiblility – so I can another column with (+) that triggers subGridRowExpanded – so that different subgrid can be shown conditionally – this way user can choose which subgrid to see.</p><p>Let me know if there is a way,</p><p>Kris</p>

Thank you Will! appreciate the example.

How can we use this will cell edit – where user picks that color and saves the cell. I have tried to use spectrum color picker plugin – like below and apply the style to the background of cell when saved.

dataInit: function(el) {
$(el).spectrum({
type:’color’,
preferredFormat: “hex”,
showInput:true,
change:function(c){
myGrid.jqGrid(‘saveCell’,seliRow,seliCol);
$(el).spectrum(‘destroy’);
}
});
}

Thank you for quick response Will!

May be quick work around will be having a utility function checking the rowObject if xml or json object.

Kris

Not sure what you mean, xml data does not contain a “$” symbol in the data. $ symbol seems to be from the formatter used

formatter:’currency’,formatoptions:{decimalSeparator:’.’,thousandsSeparator: ‘,’,decimalPlaces:2,prefix:’$’}

ok. will try the replace_format

Thanks,

Kris