Guriddo » Topic: quotes in data and export to excel

quotes in data and export to excel

Guriddo
quotes in data and export to excel

This topic has 6 replies, 2 voices, and was last updated 9 years, 1 month ago by krisreddy.

Creator

Topic

February 22, 2017 at 7:40 am #125849

krisreddy

Participant

We are licensed jqGrid Customer
Using v5.2.0 from Github – 2/21/2017

have the following array data

var grid_data = [{  
   &quot;strOrderNumber&quot;:&quot;MO-1138&quot;,
   &quot;dtmShipDate&quot;:&quot;02/20/2017&quot;,
   &quot;strProductID&quot;:&quot;335&quot;,
   &quot;strLatinName&quot;:&quot;GENEVA® 210&quot;,
   &quot;strUnitMeasureDescription&quot;:&quot;1\/4\&quot;&quot;,
   &quot;dblQtyOrdered&quot;:&quot;1000&quot;,
   &quot;dblQtyConfirmed&quot;:&quot;1000&quot;,
   &quot;dblQtyNA&quot;:&quot;&quot;,
   &quot;dblQtyCancel&quot;:&quot;&quot;,
   &quot;dblQtyShipped&quot;:&quot;&quot;,
   &quot;dblQtyLeft&quot;:&quot;1000&quot;,
   &quot;curSalePrice&quot;:&quot;1.029&quot;,
   &quot;MO-1138-1&quot;:&quot;&quot;,
   &quot;MO-1138-6&quot;:&quot;&quot;,
   &quot;MO-1138-7&quot;:&quot;&quot;
}];

var grid_data = [{

"strOrderNumber":"MO-1138",

"dtmShipDate":"02/20/2017",

"strProductID":"335",

"strLatinName":"GENEVA® 210",

"strUnitMeasureDescription":"1\/4\"",

"dblQtyOrdered":"1000",

"dblQtyConfirmed":"1000",

"dblQtyNA":"",

"dblQtyCancel":"",

"dblQtyShipped":"",

"dblQtyLeft":"1000",

"curSalePrice":"1.029",

"MO-1138-1":"",

"MO-1138-6":"",

"MO-1138-7":""

}];

It shows fine in the grid

When we export to excel, "1\/4\"" outputs as 1/4" instead of 1/4"

Is there something we are missing or is this a bug

This topic was modified 9 years, 1 month ago by krisreddy.
This topic was modified 9 years, 1 month ago by krisreddy.
This topic was modified 9 years, 1 month ago by krisreddy.

Creator

Topic

Viewing 6 replies - 1 through 6 (of 6 total)

Author

Replies
February 22, 2017 at 10:36 am #125853

guriddo.support
Participant

Hello,

Is this export to Excel or export to CSV?

Regards,

Will

Guriddo Support Team

February 22, 2017 at 7:53 pm #125854

krisreddy
Participant

It is export to excel using jszip

February 23, 2017 at 12:22 pm #125855

guriddo.support
Participant

Hello,

Thank you for finding this problem.

This was a bug. It is fixed in GitHub and you can get the fixed version from here

Please let us know if the problem is fixed for you.

We do not plan to publish new version soon. Maybe the new release will be done end of March.

Kind Regards

Will

Guriddo Support Team

February 23, 2017 at 7:09 pm #125857
krisreddy
Participant
Thank you fixing the issue with quotes. Still an issue with & (ampersand) character

If the value is B&B then excel outputs as “&amp”
- This reply was modified 9 years, 1 month ago by krisreddy.
- This reply was modified 9 years, 1 month ago by krisreddy.
- This reply was modified 9 years, 1 month ago by krisreddy.
February 24, 2017 at 12:21 pm #125862

guriddo.support
Participant

Hello,

We have fixed the problem.

Also additionally we have a dded a custom function which can be used to parse the excel string (not numbers).

The function is added in exportToExcel method and its name is replaceStr.

To use

$("#grid").jqGrid('exportToExcel', { replaceStr : function(v) { // do your replace here return v; } );

1
2
3
4
5
6

$("#grid").jqGrid('exportToExcel', {
   replaceStr : function(v) {
   // do your replace here
   return v;
   }
);

Kind Regards,
Will

Guriddo Support Team

February 28, 2017 at 6:18 pm #125869

krisreddy
Participant

Thank you!
Author

Replies

Viewing 6 replies - 1 through 6 (of 6 total)

You must be logged in to reply to this topic.

Stay connected with us in your favorite flavor!

quotes in data and export to excel

Search Forum

Recent Replies

Forum Statistics

UserOnline