This is a migrated thread and some comments may be shown as answers.

not able to insert a new row

11 Answers 245 Views
Wrappers for React
This is a migrated thread and some comments may be shown as answers.
Dhruven
Top achievements
Rank 1
Veteran
Dhruven asked on 03 Jun 2020, 08:23 PM

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

Sort by
0
Stefan
Telerik team
answered on 04 Jun 2020, 12:26 PM

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

Progress is here for your business, like always. Read more about the measures we are taking to ensure business continuity and help fight the COVID-19 pandemic.
Our thoughts here at Progress are with those affected by the outbreak.
0
Dhruven
Top achievements
Rank 1
Veteran
answered on 04 Jun 2020, 01:10 PM
Thank you so much fro your reply Stefan. 
0
Software
Top achievements
Rank 1
answered on 09 Jun 2020, 12:49 PM
We are also experiencing this issue and would like a solution as soon as possible, please and thank you!
0
Stefan
Telerik team
answered on 09 Jun 2020, 01:11 PM

Hello,

Thank you for reporting it as well.

I raised the priority of the issue.

Regards,
Stefan
Progress Telerik

Progress is here for your business, like always. Read more about the measures we are taking to ensure business continuity and help fight the COVID-19 pandemic.
Our thoughts here at Progress are with those affected by the outbreak.
0
Software
Top achievements
Rank 1
answered on 09 Jun 2020, 06:05 PM
I appreciate that, Stefan!
0
Software
Top achievements
Rank 1
answered on 18 Jun 2020, 08:19 PM
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!
0
Stefan
Telerik team
answered on 19 Jun 2020, 05:46 AM

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

Progress is here for your business, like always. Read more about the measures we are taking to ensure business continuity and help fight the COVID-19 pandemic.
Our thoughts here at Progress are with those affected by the outbreak.
0
Dhruven
Top achievements
Rank 1
Veteran
answered on 20 Nov 2020, 05:41 PM

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. 

0
Nikolay
Telerik team
answered on 24 Nov 2020, 03:26 PM

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/.

0
Roja Jayashree
Top achievements
Rank 1
Veteran
answered on 12 Jan 2021, 10:46 AM

 

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})})()

0
Stefan
Telerik team
answered on 12 Jan 2021, 01:34 PM

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/.

Tags
Wrappers for React
Asked by
Dhruven
Top achievements
Rank 1
Veteran
Answers by
Stefan
Telerik team
Dhruven
Top achievements
Rank 1
Veteran
Software
Top achievements
Rank 1
Nikolay
Telerik team
Roja Jayashree
Top achievements
Rank 1
Veteran
Share this question
or