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.
11 Answers, 1 is accepted
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
Our thoughts here at Progress are with those affected by the outbreak.
Hello,
Thank you for reporting it as well.
I raised the priority of the issue.
Regards,
Stefan
Progress Telerik
Our thoughts here at Progress are with those affected by the outbreak.
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
Our thoughts here at Progress are with those affected by the outbreak.
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.
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
Virtual Classroom, the free self-paced technical training that gets you up to speed with Telerik and Kendo UI products quickly just got a fresh new look + new and improved content including a brand new Blazor course! Check it out at https://learn.telerik.com/.
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})})()
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
Virtual Classroom, the free self-paced technical training that gets you up to speed with Telerik and Kendo UI products quickly just got a fresh new look + new and improved content including a brand new Blazor course! Check it out at https://learn.telerik.com/.