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

Spreadsheet Export to Excel

1 Answer 130 Views
Spreadsheet
This is a migrated thread and some comments may be shown as answers.
Marc
Top achievements
Rank 1
Marc asked on 26 Apr 2017, 08:41 AM

When exporting to Excel, if the spreadsheet has any validation (using range.validation(string here)) then the Export fails to open in Excel 365. Error message is below:

<?xml version="1.0" encoding="UTF-8"
standalone="true"?>
-<recoveryLog xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main">
<logFileName>error113640_02.xml</logFileName>
<summary>Errors were detected in file
'C:\Users\freemand\Downloads\CurrentStageSkuLine.xlsx'</summary>
-<removedFeatures summary="Following is a list of
removed features:">
<removedFeature>Removed Feature: Data validatin from
/xl/worksheets/sheet1.xml part</removedFeature>
</removedFeatures>
</recoveryLog>

Currently we get around this, by removing all the range.validation before we export and then add it back afterwards. However this is incredibly slow (over 15 seconds, when the spreadsheet has only 3 rows populated).

Thanks

Marc

1 Answer, 1 is accepted

Sort by
0
Nencho
Telerik team
answered on 27 Apr 2017, 12:21 PM
Hello Marc,

I am afraid that I was unable to replicate such an issue with the exported Excel file. I have used the following example to test the described issue:

http://dojo.telerik.com/@nenchef/IJiMo/3


Could you modify it with your implementation and send it back to us, so we would replicate the described issue and pin down the reason for it.

Regards,
Nencho
Telerik by Progress
Try our brand new, jQuery-free Angular 2 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
Marc
Top achievements
Rank 1
Answers by
Nencho
Telerik team
Share this question
or