Celebio/SlickGrid

Duplicate entries occur

jdarwood007 opened this issue · 2 comments

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.

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.

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.