Exporting to Excel result in corrupted Excel file

6 posts, 0 answers
  1. Maxime
    Maxime avatar
    1 posts
    Member since:
    Oct 2017

    Posted 25 Jan 2018 Link to this post

    Hi, I noticed that when we try out the following sequence, we get a corrupted excel file on export.

    Go to https://dojo.telerik.com/IcoRol
    Open the excel file (Attached to this thread)
    Export to excel

    Result: Corrupted Excel file

    I have pinpointed that the issue is related to a filter in my excel sheet. I’ve added a filter on a column, sorted from A to Z and that’s when the export issue started occurring. The bad part about it is, once my file contained a filter, even if I remove that filter, the end result will be that on export, it generates a corrupted excel file.

    Thanks,
    Maxime

  2. Neli
    Admin
    Neli avatar
    432 posts

    Posted 29 Jan 2018 Link to this post

    Hello Maxime,

    Thank you very much for reporting the problem.

    I can confirm that the described issue is a bug in the Kendo UI Spreadsheet, which is now logged in our official GitHub repository. You can track our progress on resolving it on the following link. I am afraid that there is no viable workaround available for this issue at the moment. In case we find one, we will add it to the logged issue.

    As a sign for gratitude for reporting the bug, your Telerik points are now updated.

    Regards,
    Neli
    Progress Telerik
    Try our brand new, jQuery-free Angular components built from ground-up which deliver the business app essential building blocks - a grid component, data visualization (charts) and form elements.
  3. Bhavin
    Bhavin avatar
    2 posts
    Member since:
    May 2013

    Posted 28 Jul 2020 in reply to Neli Link to this post

    Hi,

    I am having the same issue. When I import the excel file using Kendo spreadsheet control, the file got corrupted and needs to be reparied when try to access from excel or any other program than the spereadsheet control itself.

     

    Please advise the solution for it.

    Thanks

    Ghanshyam Parekh (ghanshyam.parekh@acfconsultants.com)

  4. Neli
    Admin
    Neli avatar
    432 posts

    Posted 30 Jul 2020 Link to this post

    Hi Bhavin,

    The described issue is fixed in R2 2018 release. I have tested with our latest version and I did not manage to replicate the problematic behavior. Could you please confirm which is the Kendo version you are using? If it is not the latest one may I ask you to upgrade to the latest and test the behavior? 

    Looking forward to your reply.

    Regards,
    Neli
    Progress Telerik

  5. Bhavin
    Bhavin avatar
    2 posts
    Member since:
    May 2013

    Posted 31 Jul 2020 in reply to Neli Link to this post

    Hi Neli,

    Thanks for the quick response. I am using the latest version (2020.2.617.40). Actually my spreadsheet contains merged cells and other formulas and formatting. I have attached the sample spreadsheet for your reference. Please test the attached spreadhseet and advise the solution worked for you. This spreadsheet uploads and loads in spreadsheet control well but than if I try to open the saved spreadhsheet, it gives the message to repair the spreadhsheet first. I mean the saved spreadsheet got corrupted.

    Please advise.

    Thanks,

    Ghanshyam Parekh (ghanshyam.parekh@acfconsultants.com)

  6. Neli
    Admin
    Neli avatar
    432 posts

    Posted 04 Aug 2020 Link to this post

    Hi Bhavin,

    Thank you for providing the file for testing. However, I have tested by importing and exporting the file using our Demos. On the linked screencast you will see the behavior on my end. The file is correctly exported without any issues. Please let me know if I am missing something. May I ask you to test the same file in our Demos and let me know about the behavior?

    I will appreciate it if you could isolate the issue in a runnable sample and send it back to us. Thus, we could investigate locally and advise you further. If it is more convenient for you, you could modify the Dojo example linked here.

    Looking forward to your reply.

    Regards,
    Neli
    Progress Telerik

Back to Top