Pasting Data From Excel

[DotNetRocks]

We have a grid that we want to allow users to paste from an excel document. The pasting works great with one minor setback. if the user does not have a row selected and they paste, the pasted data will overlay the first X rows (X being how ever many rows they have copied). If they have a row selected and paste, it will overwrite the row they have selected and the rows below.

I would like to make it so the pasted data gets pasted into new rows, Is that possible?

Thanks!

[paramvir]

pasteModel.type = 'append' or 'prepend' can be used for it.

https://paramquery.com/pro/api#option-pasteModel

[DotNetRocks]

Thank you! that solved this issue.

However, I have two other questions for you with pasting from Excel.

1. Is it possible to make all pasted rows go to the end of the grid rather than the current behavior?

2. I have two columns that are hidden which are at the end of the column model, if I pasted data from Excel sometimes these hidden columns get values set to them even though they should not. What is causing this?

Thanks!

[paramvir]

1. I don't see any declarative option for it. It could be done however by implementing beforeValidate event and converting ui.updateList into ui.addList when ui.source == 'paste' inside the event.

2. It could be caused when pasted data has more columns of data than the selected range at the right edge of columns.