jqxGrid data export breaking

[jbambroughParticipant]

Hello all,

I am experiencing a problem with the data export to Excel feature of the jqxGrid. It works fine in most scenarios; but I noticed that the data export breaks under certain conditions such as the following:

-Special characters
-<br> tag is part of the cell value

Does anyone know if I can fix this with some type of UTF8 setting, or are these scenarios not designed to work on data export to Excel?

Thanks,
-Jim

[DimitarParticipant]

Hello Jim,

We tested our demo Spreadsheet for this issue and were able to export the <br /> tag and characters such as ö successfully.

Best Regards,
Dimitar

jQWidgets team
http://www.jqwidgets.com/

[jbambroughParticipant]

Thanks for taking the time to test this Dimitar. I’m assuming this test harness was meant to work upon user edit (adding <br> and special characters). Do you think this behavior would be the same if it was pre-populated with those? That is how my app currrently works. I can provide my own test harness that breaks if needed. Might be a versioning thing – our app is using 2.4.1. Looks like your test is using 3.7.1

[jbambroughParticipant]

UPDATE: I confirmed by suspicion… this breaks for version 2.4.1. Works for 3.7.1. I suspect at some point there was a patch or bug fix along the way for the data export. If there is a fix or workaround please let me know. Otherwise we will work on upgrading our version. Thanks for the help….

[DimitarParticipant]

Hi Jim,

Fixes are introduced only in new versions. You would have to update to 3.7.1.

Best Regards,
Dimitar

jQWidgets team
http://www.jqwidgets.com/

[Author]

Posts