Grid - Selection & Export - Empty rows and repeated headers

[FMS]

We have successfully implemented the Copy and Export in our product as shown in the demo here.

We observed two things that we consider anomalous, which also happen on the demo page:

• if we select multiple non-contiguous rows and copy them to clipboard, the copied text contains blank rows instead of the unselected ones in the range
• if we export with headers, in the resulting Excel file the headers are repeated for each selected row

Is there any way to avoid these behaviors?

[Mihaela]

Thank you for your feedback.

• Copying non-contiguous rows - The behavior is expected since the data of the non-selected rows are not available. You could select a range of rows, as is explained in the demo description, and the required subset of data will be pasted as expected.

• Exporting with headers  - requires a custom logic. You could call the saveAsExcel() method of the grid to trigger the "excelExport" event and modify the exported rows as per your requirements.