jQuery UI Widgets › Forums › Grid › Data is not displayed from exportdata to excel in Chrome only
This topic contains 5 replies, has 4 voices, and was last updated by Peter Stoev 7 years, 1 month ago.
February 22, 2016 at 9:44 am Data is not displayed from exportdata to excel in Chrome only #81672
I have a problem with the exportdata method of jqxGrid in Chrome.
If the grid has more than 10 columns with horizontal scrollbar, it doesn’t produce excel data properly in Chrome.
Please take a look at the example below,
In this example, a grid has 11 columns with showing first 4 columns and hiding last 7 columns behind h-scroll area.
When you click the ‘Export to Excel’ in that sample,
you will have an excel downloaded which 7 columns covered with white cells without showing text at all.
The weird part is that each white cell has data behind the white styled cell. It just looks like a big white box hide all data behind.
It doesn’t happen in IE, but Chrome only.
1. connect to the url in Chrome: http://jsfiddle.net/klien54/upvvaf5m/
2. click the ‘Export to Excel’ button.
3. Open the downloaded excel file.
4. You will find data covered with white cells.
The condition is
1. Chrome Browser
2. more than 10 columns
3. horizontal scrollbar should be existed.
It can be reproduced on your sample as well,
Would you check if it happens to you please?
I hope to know how to solve this problem.
Thanks in advance for your help.
klien54February 23, 2016 at 11:44 am Data is not displayed from exportdata to excel in Chrome only #81718
Thanks for the feedback. We will investigate this behavior.
http://www.jqwidgets.comMarch 7, 2016 at 6:41 am Data is not displayed from exportdata to excel in Chrome only #82135
Hi Ivailo Ivanov,
Any progress updated on this issue?
Would you let me know how it is going on and when I can use this function properly please?
I’m looking forward to your reply.
Thanks in advance as always.
klien54.March 7, 2016 at 12:26 pm Data is not displayed from exportdata to excel in Chrome only #82178
The issue is sent for resolving.
You can check about fixes and/or new features in our release history page.
http://www.jqwidgets.comMarch 31, 2016 at 5:17 pm Data is not displayed from exportdata to excel in Chrome only #83046
There is a method to solve this, at least for now:
Add altrows and autoheight properties, both with true value.
Works for me!April 1, 2016 at 6:27 am Data is not displayed from exportdata to excel in Chrome only #83052
UPDATE: This is already resolved item in the current release.
You must be logged in to reply to this topic.