Forums Ignite UI for jQuery
Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
Close
Armando Garcia
510
Unable to disable grid feature options in GridExcelExporter?
posted

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

Parents
No Data
Reply
  • 16310
    Verified Answer
    Offline posted

    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.

Children