Paste more rows than that is defined by the `grid`.

[hamodey]

Hi,

Lets say I have a Grid of 5 Rows and 3 columns, however in my excel I have 10 Rows and 3 columns.

Using the onCellChanged and possibly the pasteParser I would like to generate 10 Rows in my grid.

Currently the Datasheet looks like this:

I would like to paste this data:

To end up looking like this:

From reading the source code I can see that there is:

parsePaste={(pasted) => {
         //do something
        }}

However, this seems to overwrite the current paste functionality, is there a way I can extend that approach?

Thank you :)

[BaherZ]

onCellsChanged takes in 2 params, "changes" and "additions", you can use the additions to see the data that you copied that do not have a place to copy yet, you can then work with that info to add additional rows to your sheet

[hamodey]

Awesome, thanks for response I will have a look at that approach.

I have had some time to apply functionality that does the above, but has small bugs for row length.

I will take yours into account and see if that helps! :)