Angular Tree Grid Clipboard Interactions
Copy to clipboard operations are now available in the Tree 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 Tree Grid into Excel or other external programs.
Angular Tree Grid Clipboard Interactions 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 exposepaste
within grid behavior.
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.
gridCopy
Emitted when a copy operation is executed. Fired only if copy behavior is enabled through theclipboardOptions
Additional Resources
- Tree Grid overview
- Paging
- Filtering
- Sorting
- Summaries
- Column Pinning
- Selection
- Virtualization and Performance
- Multi-column headers