Grid Clipboard Interactions

Copy to clipboard operations are now available in the Grid. This functionality provides a fast, easy and customizable way to copy data of the Angular Data Grid through the current multi cell data select. System Clipboard behavior gives the user ability to copy data from the Grid into Excel or other external programs.

Demo

Functionality

Copy behavior is working with the default interaction defined by the browser and operating system. Thus for the copy and paste behaviors, these are:

  • Windows/Unix based
    • Ctrl + C / Ctrl + Ins as a keyboard shortcut
    • Ctrl + V / Shift + Ins as a keyboard shortcut
    • Copy action through the browser menu
  • macOS
    • ⌘ Cmd + C as a keyboard shortcut
    • ⌘ Cmd + V as a keyboard shortcut
    • Copy action through the browser menu

Limitations

  • Both the cut and copy events are not natively supported in Internet Explorer. The exception is the paste event (IE 11) which is emitted but does not expose the clipboardData property in the event.

    Note

    In order to copy cells in IE 11, you can use the keyboard selection. Hold the shift key in order to make a multi-cell selection, press Ctrl + C in order to copy.

  • The copy behavior is disabled while the grid is in edit mode.

  • The current version of this feature covers only the copy from grid behavior. Later on we plan to expose paste within grid behavior. You can use a custom paste handler in order to configure paste behavior, have a look at our Paste from Excel topic.

API Usage

We expose clipboardOptions @Input property, which handles the following options:

  • enabled Enables/disables copying of selected cells.
  • copyHeaders Include the associated headers when copying.
  • copyFormatters Apply any existing column formatters to the copied data.
  • separator The string separator to use the for formatting the data in the clipboard. Default is /t
Note

Excel can automatically detect text that is separated by tabs (tab-delimited /t) and properly paste the data into separate columns. When the paste format doesn't work, and everything you paste appears in a single column, then Excel's delimiter is set to another character, or your text is using spaces instead of tabs.

Additional Resources

Our community is active and always welcoming to new ideas.