Hi,
I'm trying to disable all grid feature options in the exported excel worksheet but unable to do so.
I just want a plain excel worksheet without the filtering/sorting features in the header cells.
Also, for some reason some of the columns are being hidden (and/or not being sized correclty) in the exported excel worksheet.
Here is a jsfiddle that demonstrates both problems, http://jsfiddle.net/94wumh83/
Thanks,
Armando
Hello Armando,
Thank you for the fiddle shared !
What happens in this sample is that for all columns whose column key contains an empty space there is jQuery selector that fails to find the relevant element and therefore calculates the column width as null. So as you can see in the exported file only the columns whose key does not contain space are visible. I am going to log this and it will be fixes in the next release available for download to our customers.
Regarding your other question - I'm trying to disable all grid feature options in the exported excel worksheet but unable to do so. I just want a plain excel worksheet without the filtering/sorting features in the header cells.
I do not see any grid features enabled, therefore they are not applied to the worksheet also. However the grid is exported into Excel table inside the worksheet, and arrows in the headars cells are native for this tables.
Please let me know if you have any further questions on the matter.
Got it! Thanks :) One follow up question, is it possible to have the exported Excel worksheet AutoFit the width of all columns automatically?
Hello,
I'm just following up to see if you need any further assistance with this issue. If so please let me know.
This is not possible, the exporting process check every column's width and set it to the corresponding column in the excel worksheet. Of course you can leave the grid autofit its width (if you did not set any width, neither on the whole grid or on the columns) and then the same widths will be applied to the worksheet.
Please let me know if you have further questions.