Web Components Tree Grid Clipboard Overview

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

    Web Components Tree Grid Clipboard Example

    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.

    API Usage

    We expose clipboardOptions 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.

    • GridCopy Emitted when a copy operation is executed. Fired only if copy behavior is enabled through the clipboardOptions.

    Additional Resources

    Our community is active and always welcoming to new ideas.