Spreadsheet not loading data when number is formatted as text

1 Answer 104 Views
Spreadsheet
Jaspreet
Top achievements
Rank 1
Iron
Veteran
Jaspreet asked on 03 May 2021, 07:51 AM

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.

 

1 Answer, 1 is accepted

Sort by
0
Misho
Telerik team
answered on 06 May 2021, 06:08 AM

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

Love the Telerik and Kendo UI products and believe more people should try them? Invite a fellow developer to become a Progress customer and each of you can get a $50 Amazon gift voucher.

Jaspreet
Top achievements
Rank 1
Iron
Veteran
commented on 06 May 2021, 07:59 AM

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
Telerik team
commented on 10 May 2021, 01:51 PM

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

Тhe web is about to get a bit better! 

The Progress Hack-For-Good Challenge has started. Learn how to enter and make the web a worthier place: https://progress-worthyweb.devpost.com.

Tags
Spreadsheet
Asked by
Jaspreet
Top achievements
Rank 1
Iron
Veteran
Answers by
Misho
Telerik team
Share this question
or