Paste in hole column

Getting help Questions
1

Hello, i wonder if is possible in handsontable when pasting the data in the full column when selecting in header, only paste in the filled cells.

For example i have a table like:
NAME AGE
James 18
Jenny
Mitch
John
[empty line]
[empty line]

If i select the header Age and paste the number 18 it will insert all the 18 in all lines, it gets this:

NAME AGE
James 18
Jenny 18
Mitch 18
John 18
[empty line] 18
[empty line] 18

When in reality i want to be like this:
NAME AGE
James 18
Jenny 18
Mitch 18
John 18
[empty line]
[empty line]

Is it possible?

2

It depends on what you would like to get after that. You can (for example) add a readOnly state to last two rows to disallow copying data like in this demo: http://jsfiddle.net/n5noqbgv/

3

Well, is not quite the solution i need, since i need the next rows available to add new data, basically the idea is for example a table of 100 rows, in column Name, i have for example 50 names, and i wish to add in the column age all the same value, i could paste it selecting the header of the column, but since i have more than 50 rows it will paste the values in the empty rows (the other 50 rows).

4

So I guess the best way would be to erase the cells’ content after the action. In this case a pasteLimit will be a great option but unfortunately there’s only a copyLimit

5

Thanks Aleksandra for your help, one more question, is it possible for me have in my “minSpareRows” of 0 but initialize the table with one row?

6

Hi @geral
If you would like to initialize your table with one row of data you can pass an empty array and then use updateSettings to load the data you want, like in this example: http://jsfiddle.net/t4ccmqy8/