Grid exportSelectedToExcel() issue

[Laurent]

Hi team,

This dojo to illustrate the problem: https://dojo.telerik.com/inukEneV

In this dojo, i want to export selected rows to excel with exportSelectedToExcel(true). Rows are selected by clicking checkboxes.

What I experience:

- Column headers are duplicated in excel file, one for each row when selecting row with checkboxes. When selecting rows by dragging the mouse (not clicking the checkbox), it seems to work. (screenshot 1)

- Many times, when selecting rows by clicking checkbox mixed with dragging mouse to select, I can get an excel file with rows that were not selected! (screenshot2) Quite strange.

Please advise,

Best regards,

Laurent.

 

[Nikolay]

Hello Laurent,

Thank you for the Dojo demo and images provided.

Actually, the pointed behavior is expected. The exported items are considered separate ones. This is the reason for the duplicated headers.

The exportSelectedToExcel method of the Kendo UI Grid receives a boolean parameter in order to include a header for every exported item, or to exclude the headers(if exportSelectedToExcel(false)).

To avoid duplication of the headers, you could use a custom function that maps the selected rows in a kendo.ooxml.Workbook and export them via kendo.saveAs() method. Below I am posting a Dojo demo demonstrating this:

• https://dojo.telerik.com/iNEmAlIR

Regarding the second question, I was not able to replicate it. Could you please share step by step how this is replicable?

Hope this helps.

Regards,

Nikolay
Progress Telerik

[Laurent]

Hi Nikolay,

Thank you for the prompt response.

To reproduce the second point, just make successive exports by selecting different rows each time, and then you'll get something like screenshot 2.

Best regards

Laurent

[Nikolay]

Hi Laurent,

I am still investigating. Please expect a follow-up shortly.

Regards,

Nikolay

[Nikolay]

Hi Laurent,

Sorry for the late reply.

Did you manage to resolve the export problem? If not could you please record a screencast demonstrating how the issue is replicable?

Regards,

Nikolay

[Laurent]

Hi Nikolay,

No, the problem is still there.

Sorry, but I can't make a screencast.

Here is how you can reproduce the issue:

1- select a bunch of lines by dragging the mouse (screenshot 1).

2- unselect some lines by clicking their checkboxes (screenshot 2)

3- export selected to excel and see the difference (screenshot 3).

 

Best regards,

Laurent.

[Georgi Denchev]

Hi, Laurent,

Thank you for the provided screenshots and details. This behavior does indeed look like a bug and I've logged an issue in our public GitHub repository that you can track for progress:

https://github.com/telerik/kendo-ui-core/issues/6692 

I've also updated your Telerik Points as a sign of gratitude for bringing this issue to our attention.

Until the problem is resolved, you should avoid using drag selection with checkbox selection. Please accept my apologies about the caused inconvenience.