Grid export to excel causing errors in excel file

[Sean]

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! 

[Sean]

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)
        )

[T. Tsonev]

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

 

 

[Sean]

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

[T. Tsonev]

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

 

 

[Sean]

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

[T. Tsonev]

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

 

 

[Atanas Korchev]

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

 

 

[Sean]

Thanks Atanas!