Spreadsheet Export to Excel

[Marc]

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

[Nencho]

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