Hello,
used the following to set the dollar sign in front – but when exported to excel and opening the file – it produces and error. although dollar sign is in front – it is rendered as text in excel
exportoptions : { excel_parsers: false, excel_format : “[$$-45C]\ #,##0.00_-“ }
Here is link to reproduce the issue, export to excel and open the file
http://50.53.70.194:90/jqgrid/gridExportHtml.php
Kris
Guriddo customer
Copyright 2014 TriRand LtdAll Rights ReservedRSS
Back to Top