Duplicate entries occur

[jdarwood007]

Just started using this and I noticed that it seems to enter data one field in a row at a time and slickgrid fires off a change for that field.

This it the debug code from my application

Detected Row Changed:undefined Not a Row Change, No ID, inserting new row Object {name: "John Doe"} Preparing to Insert New Row Detected Row Changed:undefined Not a Row Change, No ID, inserting new row Object {name: "John Doe", Number: "AAA1234"} Preparing to Insert New Row Detected Row Changed:undefined Not a Row Change, No ID, inserting new row Object {name: "Susan Smith"} Preparing to Insert New Row Detected Row Changed:undefined Not a Row Change, No ID, inserting new row Object {name: "Susan Smith", Number: "BZA7890"} Preparing to Insert New Row Detected Row Changed:undefined Not a Row Change, No ID, inserting new row Object {name: ""} Preparing to Insert New Row Detected Row Changed:undefined Not a Row Change, No ID, inserting new row Object {name: "", Number: undefined} Preparing to Insert New Row Done. Going to Row: 0; Cell: 0

Is this by design or bug? I believe rather than it putting data in 1 field at a time in a row, it should build a item row array and submit all at once when it hits the end of line.

I believe for now I will just work around it by only allowing 2 columns to be copied and pasted, ignoring the insert until it gets both those columns and ignoring blank rows.

[Celebio]

Hi, No it is not necessarily by design, the only feature contract is that it pastes well something copied from a native spreadsheet program. Any suggestion to modify the code for the behaviour you want is welcome.

[jdarwood007]

For my purposes I was able to work around it as we are only copying 2 columns from the excel sheet.

I looked at the code but I haven't figured out exactly how its working on putting data into the system.