Corrupt Excel Files

5 posts, 0 answers
  1. Muhammad Fiqih
    Muhammad Fiqih avatar
    13 posts
    Member since:
    Nov 2017

    Posted 20 Nov 2017 Link to this post

    Hi,

    I encounter problems in a spreadsheet kendo when I want to download an excel file. The file has been successfully downloaded but when I open, the file is corrupt (the version I use is 2017.3.1026).

    Thank You

  2. Marc
    Marc avatar
    171 posts
    Member since:
    Sep 2016

    Posted 21 Nov 2017 in reply to Muhammad Fiqih Link to this post

    Do you use any validations inside your spreadsheet? I found that sometimes if you do then the Excel file will not open. I got around this by removing the validations before exporting, then adding back afterwards.
  3. Muhammad Fiqih
    Muhammad Fiqih avatar
    13 posts
    Member since:
    Nov 2017

    Posted 21 Nov 2017 in reply to Marc Link to this post

    Hi marc,

    I provide validation in its sheet config, how do I disable its validation?
    I do it like in the picture

    thank you

  4. Marc
    Marc avatar
    171 posts
    Member since:
    Sep 2016

    Posted 21 Nov 2017 in reply to Muhammad Fiqih Link to this post

    range.validation(null);
  5. Dimitar
    Admin
    Dimitar avatar
    459 posts

    Posted 22 Nov 2017 Link to this post

    Hello Muhammad,

    Did you manage to successfully resolve the issue? As suggested by Marc, passing null to the validation method should disable the validation of the cells.

    Regards,
    Dimitar
    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.
Back to Top