Grid export to excel causing errors in excel file

9 posts, 0 answers
  1. Sean
    Sean avatar
    5 posts
    Member since:
    Mar 2014

    Posted 07 Feb 2015 Link to this post

    Have any of you seen the issue when exporting a grid to excel you receive excel errors when sorting the filtered data? The excel file works fine up until you try to sort it.  

    I originally thought it was due to bad data but then tried exporting some basic grids with the same issue. This seems like it just started happening in the last few days. Hopefully someone has seen this! 
  2. Sean
    Sean avatar
    5 posts
    Member since:
    Mar 2014

    Posted 09 Feb 2015 Link to this post

    So in my excel grid configurations I removed .Filterable(true) and everything works well now.  Is this a bug? 

    Here was what my excel grid configuration looked like when I received the errors in excel.

    .Excel(excel => excel
                .FileName("Test_Excel.xlsx")
                .ProxyURL(Url.Action("Excel_Export_Save", "Search"))
                .Filterable(true)
                .AllPages(true)
            )

    Now my Excel grid Configuration looks like this
     .Excel(excel => excel
                .FileName("Test_Excel.xlsx")
                .ProxyURL(Url.Action("Excel_Export_Save", "Search"))
                .AllPages(true)
            )









  3. T. Tsonev
    Admin
    T. Tsonev avatar
    2833 posts

    Posted 11 Feb 2015 Link to this post

    Hi,

    I tried this with Excel 2013 and it seems to work.

    What version of Excel are you using?
    Can we get a sample file to test with?

    Regards,
    T. Tsonev
    Telerik
     

    Check out the Telerik Platform - the only platform that combines a rich set of UI tools with powerful cloud services to develop web, hybrid and native mobile apps.

     
  4. Sean
    Sean avatar
    5 posts
    Member since:
    Mar 2014

    Posted 11 Feb 2015 in reply to T. Tsonev Link to this post

    Hi T. Tsonev,

    We are using Excel 2010, please see attached.  That's good to know that 2013 works fine, since we are moving to 2013 soon.

    Regards,
    Sean
  5. T. Tsonev
    Admin
    T. Tsonev avatar
    2833 posts

    Posted 13 Feb 2015 Link to this post

    Hi,

    Thanks for the sample file. I've tried it in both 2010 and 2013, but didn't have much luck reproducing the issue.
    Do you have to follow any specific steps or any sorting/filtering leads to a crash?

    Regards,
    T. Tsonev
    Telerik
     

    Check out the Telerik Platform - the only platform that combines a rich set of UI tools with powerful cloud services to develop web, hybrid and native mobile apps.

     
  6. Sean
    Sean avatar
    5 posts
    Member since:
    Mar 2014

    Posted 16 Feb 2015 in reply to T. Tsonev Link to this post

    Hi T. Tsonev,

    I found that it only crashes when you go into the excel file, and before changing anything click on the column pull down and choose 'Sort A to Z' or 'Sort Z to A'.  If you do any filters via the dropdown all works ok, seems to be only when you sort.

    What's interesting if you turn off the column filter then turn it back on everything works fine.

    Regards,
    Sean
  7. T. Tsonev
    Admin
    T. Tsonev avatar
    2833 posts

    Posted 18 Feb 2015 Link to this post

    Hi,

    Thanks for the additional info. We've managed to reproduce the issue this time.

    I think we've managed to track down the root cause hopefully the fix will make it into the internal releases soon.

    I've updated our Telerik points as a token of gratitude for your involvement.

    Regards,
    T. Tsonev
    Telerik
     

    Check out the Telerik Platform - the only platform that combines a rich set of UI tools with powerful cloud services to develop web, hybrid and native mobile apps.

     
  8. Atanas Korchev
    Admin
    Atanas Korchev avatar
    8462 posts

    Posted 18 Feb 2015 Link to this post

    Hello Sean,

    I've just landed a fix that should resolve this problem. The latest internal build due by the end of this week will contain that fix.

    Regards,
    Atanas Korchev
    Telerik
     

    Check out the Telerik Platform - the only platform that combines a rich set of UI tools with powerful cloud services to develop web, hybrid and native mobile apps.

     
  9. Sean
    Sean avatar
    5 posts
    Member since:
    Mar 2014

    Posted 18 Feb 2015 in reply to Atanas Korchev Link to this post

    Thanks Atanas!
Back to Top