xlsx breaking in spreadsheet viewer

[Jaspreet]

hi,
While opening few xlsx in spreadhsheet viewer, an error is being thrown ERROR TypeError: Cannot read property '2' of null. PFA the sample file. 
Regards,
Jaspreet

[Misho]

Hi Jaspreet,

I was able to replicate the error on my side with the document you've attached. I've tried to create xlsx document from scratch on my end with similar data pasted from the excel file you have provided. This way the document is opened in spreadsheet successfully in this dojo. I'm attaching it for reference. Could you please provide us with more details about the steps to produce the problematic xlsx file? This way we will be enabled to investigate the case more easily on our side and do our best to provide you with more detailed information and reliable solution.

Thank you for your collaboration.

Best Regards,
Misho
Progress Telerik

[Jaspreet]

hi Misho,

We have used Apache POI to convert xls to xlsx only because spreadhseet viewer supports xlsx. But after the conversion we got this error. 

Regards,

Jaspreet

[Misho]

Hi,

I've tested the original test10000.xlsx in OpenXML SDK Productivity Tool 2.5 and it reports 24 errors which means that it might be corrupted.

In case opening the same file in MS Excel and just save it, these errors are cleaned by MS Excel and the file could be imported successfully to Kendo Spreadsheet with no errors. I've attached it for reference.

I hope you will find this information useful.

Best Regards,
Misho
Progress Telerik