This topic contains 4 replies, has 2 voices, and was last updated by Gwyn 5 years, 10 months ago.
Viewing 5 posts - 1 through 5 (of 5 total)
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic.
jQuery UI Widgets › Forums › Grid › Exporting grid to xls – columns not visible
This topic contains 4 replies, has 2 voices, and was last updated by Gwyn 5 years, 10 months ago.
If I have a grid displaying more columns than will fit on the screen, if I scroll to a set of columns and then use the exporter to export as Excel XLS format then only the columns in view are visible, the Excel style of other columns is set so that the text is white on a white background. If I don’t scroll I get all columns visible, but if I scroll then I only get those in view visible.
Why is this? And how do I stop it happening?
Hi Gwyn,
Please, share jsfiddle.net or codepen example about the described behavior with our Grid component.
Best Regards,
Peter Stoev
jQWidgets Team
https://www.jqwidgets.com
Please use this hacked together fiddle that demonstrates the problem
Ensure that you have the grid scrolled right so that one or more left columns are not visible
Press export
You’ll notice in the xls file that the left hand columns have a style of white on white!
Hi Gwyn,
We will create a work item about this behavior here https://github.com/jqwidgets/jQWidgets/issues
Thanks for the feedback.
Best Regards,
Peter Stoev
jQWidgets Team
https://www.jqwidgets.com
If anyone else stumbles across this problem, the workaround is to programmatically scroll top left before doing the export e.g;
$(‘#jqxgrid’).jqxGrid(‘scrolloffset’, 0, 0);
You must be logged in to reply to this topic.