not able to insert a new row

[Dhruven]

HI, 

I am working with the spreadsheet wrapper component. I found an issue where I was not able to insert a new row into s sheet.

I created a sheet with some data in it using a spreadsheet component, downloaded it and uploaded it into another spreadsheet component. Now after uploading it into the second component I am not able to insert a new row to that sheet.

I don't have data in the last row, but still it is throwing me an error saying "Cannot insert cells due to data loss possibility. Select another insert location or delete the data from the end of your worksheet."

Also to make it work, I have to delete rows from bottom of my sheet and then I can insert the same amount of rows anywhere in the sheet.

Please let me know if this is the expected behaviour or it's an actual issue.

If it's the expected behaviour is there a possible way so I don't have to remove all the rows from the bottom of the sheet and I can insert rows?

 

Thank you.

[Stefan]

Hello, Dhruven,

Thank you for reporting this.

I was able to reproduce the same issue and logged it for fixing:

https://github.com/telerik/kendo-ui-core/issues/5826

Currently, there is no workaround available, and if one is found it will be added to the GitHub item.

Additionally, I have updated your Telerik points for bringing this to our attention.

Regards,
Stefan
Progress Telerik

[Dhruven]

Thank you so much fro your reply Stefan. 

[Software]

We are also experiencing this issue and would like a solution as soon as possible, please and thank you!

[Stefan]

Hello,

Thank you for reporting it as well.

I raised the priority of the issue.

Regards,
Stefan
Progress Telerik

[Software]

I appreciate that, Stefan!

[Software]

Hi Stefan, I see the priority of the issue https://github.com/telerik/kendo-ui-core/issues/5826 was raised - thank you for making that happen.  However, I see that it is still unplanned.  Is there any possibility to get an idea of when it might be planned to tackle?  Thank you!

[Stefan]

Hello,

The planning is usually done for a quarter, but the team is still monitoring all issues and planning them based on priority and severity.

Providing a specific ETA could be misleading as this will depend on many dynamic factors.

Still, I can suggest commenting directly inside the issue as that way as soon as a developer starts working on it, you can receive more specific information.

Regards,
Stefan
Progress Telerik

[Dhruven]

HI, 

 

I can see that this issue was fixed for jQuery component but we did not get any update for the spreadsheet react wrapper component. 

Can I get an ETA for getting this fix on the react wrapper?

Please and thank you. 

[Nikolay]

Hello,

Unfortunately, the kendo react wrappers are no longer supported. Please, see the following article about using Kendo UI for jQuery in React.

I have made for you a sample Spreadsheet wrapper for react. It is actually a copy of the existing Spreadsheet wrapper but with an updated version of Kendo UI library - https://stackblitz.com/edit/react-6sn1dm?file=app%2Fmain.jsx. I hope you can use it.

Regards,
Nikolay
Progress Telerik

[Roja Jayashree]

 

Question - if we want the function of exporting the sheet and importing back again into spreadsheet and adding the row should work on this package "@progress/kendo-base-component-react-wrapper" without throwing error as "Cannot insert cells due to data loss possibility. Select another insert location or delete the data from the end of your worksheet." ? 

 

if so, I have tired this above example and seems like the downloaded sheet is unable to open and throws out an error as

"Excel cannot open the file 'Workbook.xlsx' because the file format or file extension is not valid. Verify that the file has not been corrupted and that the file extension matches the format of the file."

 

i have tired changing the .xlsx to .xls and it opens but with an error as below
(function(){_preboot("https://l.staticblitz.com/b/v1/react-6sn1dm/a1254650f61", {"p":"stackblitz","a":"AIzaSyBZSvuCzbUhuRrSps-HjM5bFClLPaFF9Vg","o":false,"u":null,"$":false})})()

[Stefan]

Hello, Roja, Dhruven,

The fix is available in the Kendo UI package version, it is not part of the wrapper and there is no need for a custom base wrapper.

Just update the '@progress/kendo-ui' package and the fix should be automatically available.

Please give it a try and advise if the issue still occurs.

Regards,
Stefan
Progress Telerik