jQuery UI Widgets › Forums › Grid › Data is not displayed from exportdata to excel in Chrome only
Tagged: angular grid, chrome, display, excel, Exportdata, javascript grid, jquery grid
This topic contains 5 replies, has 4 voices, and was last updated by Peter Stoev 8 years, 7 months ago.
-
Author
-
Hi, team.
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,
http://jsfiddle.net/klien54/upvvaf5m/
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.In short,
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,
http://www.jqwidgets.com/jquery-widgets-demo/demos/jqxgrid/index.htm#demos/jqxgrid/spreadsheet.htmWould you check if it happens to you please?
I hope to know how to solve this problem.
Thanks in advance for your help.Best regards,
klien54Hi klien54,
Thanks for the feedback. We will investigate this behavior.
Best Regards,
Ivailo IvanovjQWidgets Team
http://www.jqwidgets.comHi 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.Warm Regards,
klien54.Hi klien54,
The issue is sent for resolving.
You can check about fixes and/or new features in our release history page.Best Regards,
Ivailo IvanovjQWidgets Team
http://www.jqwidgets.comHi guys,
There is a method to solve this, at least for now:
Add altrows and autoheight properties, both with true value.
Works for me!
Hi csjoao,
UPDATE: This is already resolved item in the current release.
Best Regards,
Peter StoevjQWidgets Team
http://www.jqwidgets.com -
AuthorPosts
You must be logged in to reply to this topic.