Copying & Pasting header into excel

[Administrator]

When I highlight and copy a grid by selecting all the columns (click on header and drag), and then paste it into excel, everything gets copied except the headers. Is this just a mmatter of an attribute setting?

[Administrator]

To include the headers, you need to set a flag in the ClipboardCopy event handler.

' in formload
AddHandler Me.gridDataBoundGrid1.Model.ClipboardCopy, AddressOf HandleCopy

’......
Private Sub HandleCopy(sender As Object, e As GridCutPasteEventArgs)
   e.ClipboardFlags = e.ClipboardFlags Or GridDragDropFlags.ColHeader
End Sub ’HandleCopy