Hi..
i’m export jqxgrid to excel and find out something strange, if my cell contain string that begin with “AG” characters at the beginning than the result of export file will missing these two characters, for example if the cell value in jqxgrid is “AGUS” than the export file will missing “AG” and only remain “US” in the excel file.
this only appear when i export to excel format, not with csv and pdf and only if the first two characters begin with “AG” if the cell value is “BAGUS” then it’s ok and export as expected.
than i found out this condition appears because of this line of code in jqxdata.export.js
“if(s!=null&&s.toString().substring(0,2)==”AG”){s=s.toString().substring(2);q=”String”}else{if(t.type==”date”){s=this.formatData(s,t.type,t.formatString,t.localization);if(s===null||s===””){s=””;q=”String”}}”
Please help
