<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

Thank you Will! colmenu position works now.

Here is the link demonstrating the issue

http://50.53.70.194:90/jqgrid/gridExportHtml.php

Thank you, Will! much appreciated.

I will test it and let you know

Kris