DataEditR aborts when one tries to paste more columns than the available

[psads-git]

Suppose one removes all columns but one and, subsequently, tries to paste 3 columns from, say, a spreadsheet, DataEditR simply aborts. Should not DataEditR add more columns in order to accommodate the whole pasted data?

[DillonHammill]

DataEditR only allows addition of columns one at a time, so you need to add the columns before pasting the data.

[psads-git]

Thanks, Dillon. In any case, DataEditR should not abort and should instead inform the user about that feature of DataEditR.

[DillonHammill]

Unfortunately this is handled at the rhandsontable level so there is not much I can do here. Let's leave this issue open for now and I will dive into the rhandsontable code when I get a chance.

[psads-git]

That is OK, Dillon. Thanks!

Interestingly, if one pastes more rows than the ones available, there is no issue and DataEditR adjusts the number of rows as needed.

[sch56]

Related issue: If I have set row_edit = FALSE and accidentally paste something that is larger than the existing data then the app crashes. Preferable would be either a simple check and error message if the paste extent is too large, or trim the paste to what does fit.

[VeraZhouWeiwei1999]

Unfortunately this is handled at the rhandsontable level so there is not much I can do here. Let's leave this issue open for now and I will dive into the rhandsontable code when I get a chance.

Hi! I've noticed that I can paste data with more columns than there are available in the table when using rhandsontable package now, but this is not currently possible with DataEditR. Is there a way to fix it?