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

Corrupt Excel Files

4 Answers 111 Views
Spreadsheet
This is a migrated thread and some comments may be shown as answers.
Muhammad Fiqih
Top achievements
Rank 1
Muhammad Fiqih asked on 21 Nov 2017, 03:40 AM

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

4 Answers, 1 is accepted

Sort by
0
Marc
Top achievements
Rank 1
answered on 21 Nov 2017, 07:47 AM
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.
0
Muhammad Fiqih
Top achievements
Rank 1
answered on 21 Nov 2017, 09:22 AM

Hi marc,

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

thank you

0
Marc
Top achievements
Rank 1
answered on 21 Nov 2017, 09:24 AM
range.validation(null);
0
Dimitar
Telerik team
answered on 22 Nov 2017, 01:23 PM
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.
Tags
Spreadsheet
Asked by
Muhammad Fiqih
Top achievements
Rank 1
Answers by
Marc
Top achievements
Rank 1
Muhammad Fiqih
Top achievements
Rank 1
Dimitar
Telerik team
Share this question
or