[Solved] allowCopy

[Matt Barker]

Hello.
I've just tried these settings in the grid options:

var persons = [
    { FirstName: 'Andy', MiddleName: 'Albert', LastName: 'Arbuckle' },
    { FirstName: 'Bob', MiddleName: 'Bertrand', LastName: 'Barrington' },
    { FirstName: 'Carl', MiddleName: 'Cuthbert', LastName: 'Carruthers' }
];

$('#grid').kendoGrid({
    dataSource: { data: persons },
    columns: [
        { field: 'FirstName', title: 'First Name' },
        { field: 'MiddleName', title: 'Middle Name', hidden: true },
        { field: 'LastName', title: 'Last Name' },
    ],
    selectable: 'multiple cell',
    allowCopy: true
});

It works nicely other than the fact that hidden columns are copied as empty cells.
Is this expected functionality?
(My preference would be to not copy the middle cell - I don't think that empty cells add any value)
Thank you.

[Petur Subev]

Hello Matthew,

We created the copyToExcel feature according to the Excel behavior, where if you have a hidden column and you select between two cells holding the shift key, you will get the cell between as well.

e.g.

http://screencast.com/t/ZGNuumUut

If you believe it is good to have option to enable/disable this behavior, please share on our official feedback portal where more people can support the idea and we can consider improving the feature in that direction.

Currently the only option is to omit defining this column.

Thank you for the understanding.

Kind Regards,
Petur Subev
Telerik

 

 

[Matt Barker]

Hi Petur,

Unfortunately I can't access screencast.com due to our company firewall.
When I try in Excel it copies the hidden cell - including the cell value.
It is fine to copy Excel's behaviour (if that is what happens, but it isn't) -  so is copying the cells with no value in them a bug?

[Petur Subev]

Hello Matthew,

Thank you for the feedback, we appreciate it.

How exactly do you make the selection, if you select a cell then hold shift and select another cell (so that the hidden column remains in the middle of the selection)? Then you should see the cell content copied.

Or do you use the rectangle mouse selection? Indeed in such scenario the cell is actually hidden and the content is not copied because the Grid have not actually selected the cell.

While waiting for your reply I will discuss if this is actually expected and if we should change this behavior.

Kind Regards,
Petur Subev
Telerik

 

 

[Matt Barker]

[quote]Petur Subev said:Or do you use the rectangle mouse selection? Indeed in such scenario the cell is actually hidden and the content is not copied because the Grid have not actually selected the cell[/quote]
Yes, it was mouse selection. It's not a massive issue, I just wanted to point out that if you are not copying the column content it doesn't add any value to paste empty columns, that is all.
I.e. If the column is hidden then the column shouldn't be copied at all.

[Petur Subev]

Hello Matthew,

Thank you for the feedback, we discussed with the team and we ended with the same idea. Any invisible cells won't be added like the column did not exist. This is more flexible since on  other side if the user wants to include column he just have to make the column visible.

We will try to include the change for the next release.

Kind Regards,
Petur Subev
Telerik