Copy cells and include headers

Tags: #<Tag:0x00007f8b1ac6b4c8>
#1

Is there any way to include column headers when using the copy plugin so that headers are included in the copied data?

Selecting the entire grid highlights the headers but a copy then only contains the data cells.

#2

Hi @chris2

At the moment this functionality is unavailable. The requirement has been reported under this issue https://github.com/handsontable/handsontable/issues/2288. However, the development of this functionality hasn’t been scheduled yet.

#3

May I ask for the availability for this schedule, this feature actually improves a lot for usability?

#4

Hi @sam.demands, at the moment, we established that the following technique http://jsfiddle.net/f618oqat/7/ should be enough. If that does not work for your please let me know.

#5

Thanks it work for single header, but nested header do not work.
Seems getColHeader does not return the correct value when there is nested header, it always return null in getColHeader function

#6

That is correct, @sam.demands
The following method does not work for nestedHeaders as the logic is based on colHeaders that do not change when we add nestedHeaders. Now, how to get them. If you do not need to have them merged and in this case

36

The response can be

D | E | E | E | E | E
2017 | B | C | 12 | 12 | 15
etc.

When I recommend saving the header name in cell meta and then attach that cell meta array into the results array in the beforeCopy hook. It’s a theory, and I haven’t tried it. But that should work, if you do not move/hide headers.

#7

Thanks, Budnik,

I fixed that already. But I found that the header always be copied by default, do you have a function showing whether I select the header or not? I would like to ask if I do not select the headers, and do not copy the header by default.

Thanks and Regards
Ivan Cheung

#8

Hi! This is great.
There is a small problem when using CTRL + A and CTRL-C.
The content cells and the header does not align correctly.

#9

@sam.demands

If you do not want to copy with colHeaders you need to skip the logic of headers.push(this.getColHeader(i)); and replace it with the data from nestedHeaders.

#10

@dan1

true, this happens when rowHeaders an enabled so we get this top-left element in header with a name. You can add one additional if to avoid that

if(startRow < 0){ startCol = 0}
for (var i = startCol; i <= endCol; i++) {
   headers.push(this.getColHeader(i));
}
#11

Hi,
Looks like the declaration of startRow is missing in the code.
startRow = ?

#12

@dan1

yes, it’s similar to the column

startRow is selection[0].from.row

#13

This is working fine with CTRL+A and CTRL+C. Added && startCol < 0

beforeCopy: function(data) {
	var headers = [];
	var selection = this.getSelectedRange();
	var startCol = Math.min(selection[0].from.col, selection[0].to.col);
	var endCol = Math.max(selection[0].from.col, selection[0].to.col);
	var startRow = Math.min(selection[0].from.row, selection[0].from.row);

	if(startRow < 0 && startCol < 0 ){ startCol = 0}
	for (var i = startCol; i <= endCol; i++) {
		headers.push(this.getColHeader(i));
	}							  
	data.splice(0, 0, headers);
},
1 Like
#14

@aleksandra_budnik

Thanks for your quick response. Actually, I would like to see if there is a property or function to check if I selected the header or not so that I can get a correct copy to decide if I should skip the logic of headers.push(this.getColHeader(i)).

Thanks and Regards
Ivan Cheung

#15

Hey @sam.demands

You can use the response of the afterOnCellMouseDown() hook. It returns -1 for a clicked header.

57
Screenshot 2022-09-01 at 08.11.57.png945×419 42.7 KB

https://handsontable.com/docs/api/hooks/#afteroncellmousedown

#16

Hi @sam.demands @dan1 @chris2

I have great news! We’re a single step from introducing a new functionality - Copy with headers.
While we’re doing final tests we’ve opened an issue for the community at https://github.com/handsontable/handsontable/issues/10112

I would be grateful if you could share any translations or just leave a thumbs up :slight_smile: thank you.

#17

Hi guys! It’s here!

We just relased Handsontable v12.3.0 that allows to copy cells with headers and headers only. Here https://handsontable.com/docs/javascript-data-grid/release-notes/#_12-3-0 you can read more about the changes.

#18