search

DillonHammill / DataEditR

An Interactive R Package for Viewing, Entering Filtering and Editing Data
https://dillonhammill.github.io/DataEditR/
381 stars 40 forks source link

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

Open psads-git opened 2 years ago

psads-git commented 2 years ago

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 commented 2 years ago

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

psads-git commented 2 years ago

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

DillonHammill commented 2 years ago

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 commented 2 years ago

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 commented 2 years ago

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 commented 2 months ago

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?