This is a migrated thread and some comments may be shown as answers.

Grid export to excel causing errors in excel file

8 Answers 124 Views
Grid
This is a migrated thread and some comments may be shown as answers.
Sean
Top achievements
Rank 1
Sean asked on 07 Feb 2015, 04:10 PM
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! 

8 Answers, 1 is accepted

Sort by
0
Sean
Top achievements
Rank 1
answered on 09 Feb 2015, 02:55 PM
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)
        )









0
T. Tsonev
Telerik team
answered on 11 Feb 2015, 09:25 AM
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.

 
0
Sean
Top achievements
Rank 1
answered on 11 Feb 2015, 02:21 PM
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
0
T. Tsonev
Telerik team
answered on 13 Feb 2015, 10:47 AM
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.

 
0
Sean
Top achievements
Rank 1
answered on 16 Feb 2015, 02:36 PM
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
0
T. Tsonev
Telerik team
answered on 18 Feb 2015, 12:06 PM
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.

 
0
Atanas Korchev
Telerik team
answered on 18 Feb 2015, 02:20 PM
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.

 
0
Sean
Top achievements
Rank 1
answered on 18 Feb 2015, 02:25 PM
Thanks Atanas!
Tags
Grid
Asked by
Sean
Top achievements
Rank 1
Answers by
Sean
Top achievements
Rank 1
T. Tsonev
Telerik team
Atanas Korchev
Telerik team
Share this question
or