Spreadsheet not loading data when number is formatted as text

[Jaspreet]

Hi,

When loading the attached file, the data is not completely loaded in spreadsheet. https://dojo.telerik.com/AjOWOPEG

PFA the file as well.

Is there any specific formatting that spreadsheet allows or some restricted formatting. Please suggest.

 

[Misho]

Hello Jaspreet,

I was able to replicate the error on my side with the document you've attached. Could you please provide us with more details about the steps to produce the problematic xlsx file and the tool used to generate it?

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,
The file have a column PO Num, that is number in this cell is formatted as text. If it is converted to number than the file opens correctly. How to handle this kind of scenarios.

Regards,
Jaspreet

[Misho]

Hi,

I've tried to load the attached excel file (Test1) in MS Excel and only save it again with a different name without applying any change. The produced new file (Test2) could be load successfully into Spreadseet component with no data loss. Here is a video showing my test:

https://www.screencast.com/t/pAodNyqBA8q 

The difference between these files is that the format from the initial file is:

<c r="F2" s="4" t="inlineStr">
        <is>
          <t>1005131528</t>
        </is>
      </c>

while the format saved from excel is:

 

<c r="F2" s="2" t="s">
        <v>12</v>
      </c>

The spreadsheet currently relies on the <v> tag and doesn't accept cell type "inlineStr". Here is an article with more info regarding the inlineStr type:

https://c-rex.net/projects/samples/ooxml/e1/Part4/OOXML_P4_DOCX_c_topic_ID0E1XM4.html 

I've added a Feature Request on your behalf for this issue in our Public Feedback portal where you could vote for raising its priority:

https://feedback.telerik.com/kendo-jquery-ui/1518934-add-suppo 

 

Best Regards,
Misho
Progress Telerik