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

ok. I am using xml to populate the data into grid – one of the columns has a html link so that data looks like like this

<a href="somepage.php" target="_blank" rel="noopener">Link to page</a>

on the grid the link looks fine, however when exported to excel it html encoded as follows and basically I am wanting to show it a link in excel as well.
I can’t seem to post the encoded html code – so attaching the image at the link below

View post on imgur.com

• This reply was modified 1 year, 6 months ago by krisreddy.
• This reply was modified 1 year, 6 months ago by krisreddy.
• This reply was modified 1 year, 6 months ago by krisreddy.

All this works great, however when errorCell is defined and there is a server error, focus is lost, is there a way to set focus back just like in validationCell

Thanks,

Kris