reg. pasteModel type append not working.

[mraj]

Hi

I am using paste model option

pasteModel: { on: true, type: "append" }.

And, When tried to paste from excel which is having more rows than the rows present in the grid. it is not properly pasting.

what is the exact settings for appending the rows.

[mraj]

It is working.  but in the application, with the below condition.(added for editable )

 title: "Back Details", halign: "center", colModel: [
                            {
                                title: "Name (Based on Pressure)", dataIndx: "back_name", dataType: "string", align: "left", halign: "center", width: 350,
                                editable: function (ui) {
                                    return (ui.rowData.ahead_back_same == "no");
                                },


when date is pasted,(rows more than existing rows in the grid ). getting error.

for ex: if i 10 records in the grid, and , if i paste 20 records from 5th position, it loops upto tenth row. after that getting error.

If i put simply false for the condition  return (ui.rowData.ahead_back_same == "no");, loosing the editable option. but able to copy. all the 20 records.

[mraj]

Hi,
expecting any reply, which will be helpful. When the data is copied from excel having more  rows than the rows (empty rows)  present in the grid, with the above editable condition. getting error. please explain how it works internally. or suggest any workaround for it.

[paramvir]

rows/cells are supposed to be editable for paste to work.

You can set editable to true in beforeValidate event when ( ui.source == 'paste' ) and reset the editable back to initial value in change event.

https://paramquery.com/api#event-beforeValidate

[mraj]

The problem is, if i copy lesser rows than the grid rows. that case even if editable=false , it is working. If i paste more rows than the grid rows. i am getting error as that editable condition is not defined.

[paramvir]

Works fine in the example. https://paramquery.com/demos/copy_paste

Kindly share a jsfiddle if still facing issues.

[mraj]

Thanks for the reply. will try further.