Angular Data GridClipboard

You can copy and paste items to and from the grid using the system clipboard.

How to copy

Copying from the grid is enabled by default for enterprise users. To copy your selection to the system clipboard, you can use the keybind ^ Ctrl+C, or right click on a cell and select 'Copy' from the context menu. Unless Cell Selection or Row Selection is enabled, you will only be copying from the currently focused cell.

When copying multiple cells, the contents will be copied in an Excel compatible format, with fields separated by a \t (tab) character.

Copying Cell Ranges

When Cell Ranges are enabled by setting gridOptions.cellSelection=true, copying will copy the Cell Range's content to your clipboard. Select a range by clicking on a cell and dragging with the mouse, then copy with the ^ Ctrl+C keybind.

Multiple cell ranges can be selected at once using ^ Ctrl and dragging with the mouse. When copying, all ranges will be copied to the clipboard. Note that the relative positions of multiple ranges is not preserved when copying, they are stacked vertically in the clipboard.

The column headers can be copied to the clipboard in addition to the cell contents by enabling the option copyHeadersToClipboard.

In the below example copyHeadersToClipboard has been enabled, try:

• Select a cell range with click & drag
• Copy with ^ Ctrl+C
• Paste into an external program / text editor, note that the column headers were also copied.

Copying Rows

When Row Selection is enabled by setting gridOptions.rowSelection.mode to either "singleRow" or "multiRow", the default behaviour is to copy only the focused cell to the clipboard. In order to copy the whole row, enable the gridOptions.rowSelection.copySelectedRows flag.

<ag-grid-angular
    [mode]="mode"
    [copySelectedRows]="copySelectedRows"
    /* other grid options ... */ />

this.mode = 'multiRow';
this.copySelectedRows = true;

The below example demonstrates copying rows. Initially, pressing ^ Ctrl+C will select the focused cell, regardless of which rows have been selected. ] You can change this behaviour by toggling the "Copy Selected Rows" checkbox to enable the copySelectedRows flag:

• Toggle the "Copy Selected Rows" checkbox on
• Select one or more rows in the example below and press ^ Ctrl+C
• Paste copied content in a text editor
• When the "Copy Selected Rows" checkbox is toggled on, the pasted content includes all selected rows. When the "Copy Selected Rows" checkbox is toggled off, the pasted content includes only the focussed cell.

Custom Clipboard Interaction

If you want to do the copy to clipboard yourself (i.e. not use the grid's clipboard interaction) then implement the callback sendToClipboard(params). Use this if you are in a non-standard web container that has a bespoke API for interacting with the clipboard. The callback gets the data to go into the clipboard, it's your job to call the bespoke API.

The example below shows using sendToClipboard(params), but rather than using the clipboard, demonstrates the callback by just printing the data to the console.

Copying via the API

You can use the Grid API methods: copySelectedRowsToClipboard(...) and copySelectedRangeToClipboard(...) to copy rows or ranges respectively, these API calls take optional parameters to enable copying column and group headers.

How to Cut

Cut from the grid is enabled by default for enterprise users. To cut your selection to the system clipboard, you can use the keybind ^ Ctrl+X, or right click on a cell and select 'Cut' from the context menu. Unless Range Selection or Row Selection is enabled, you will only be copying from the currently focused cell.

The cut operations will work exactly the same as the copy operations, with the addition that data will be removed from the grid afterwards, so the cut operations will use the same properties described above to customise the copy process.

Disabling Cut

Since Cut is a destructive process, the suppressCutToClipboard property was added to the Grid Options.

<ag-grid-angular
    [suppressCutToClipboard]="suppressCutToClipboard"
    /* other grid options ... */ />

this.suppressCutToClipboard = true;

This is demonstrated in the example below. Note the following:

• Selecting a cell and pressing ^ Ctrl+X will not copy or cut the data.
• The context menu will not show an option to Cut.

How to Paste

Paste is enabled by default in the enterprise version and is possible as long as the cells you're pasting into are editable (non-editable cells cannot be modified, even with a paste operation). You can paste using the keybind ^ Ctrl+V while focus is on the grid.

The behaviour of paste changes depending on whether you have a single cell or a range selected:

• When a single cell is selected. The paste will proceed starting at the selected cell if multiple cells are to be pasted.
• When a range of cells selected. If the selected range being pasted is larger than copied range, it will repeat if it fits evenly, otherwise it will just copy the cells into the start of the range.

Disabling Paste

You can turn paste operations off for the entire grid, by setting the grid property suppressClipboardPaste=true.

Or you can disable pasting for a specific column or cell by setting the property suppressPaste on the column definition. This can be a boolean or a function (use a function to specify for a particular cell, or boolean for the whole column).

Processing Pasted Data

The clipboard data will be processed by default Using the Value Formatter for Export to format the cells when copied, and Using the Value Parser for Import to format the cells when pasted.

It is possible to override this behaviour specifically for the clipboard. This can be done either on individual cells or the whole paste operation.

Processing Individual Cells

The interfaces and parameters for processing individual cells are as follows:

These three callbacks above are demonstrated in the example below. Note the following:

• When cells are copied to the clipboard, values are prefixed with 'C-'. Cells can be copied by dragging a range with the mouse and hitting ^ Ctrl+C.
• When cells are pasted from the clipboard, values are prefixed with 'Z-'. Cells can be pasted by hitting ^ Ctrl+V.
• When headers are copied to the clipboard, values are prefixed with 'H-'. Headers can be copied by using the context menu.
• When group headers are copied to the clipboard, values are prefixed with 'GH-'. Headers can be copied by using the context menu.

Processing Data from Clipboard

To have complete control of processing clipboard data when pasting, you can use the callback below:

The following example shows custom code to process the data from the clipboard:

• The cells are coloured based on the colour that the cell content starts with
• Copy a cell range in the grid which includes a cell value that starts with Red. Pasting into the grid will paste a custom 4x4 cell grid.
• Copy a cell range in the grid which includes a cell value that starts with Yellow and doesn’t include any Red cell values. Pasting this copied cell range will cancel the paste action and not paste anything
• Any other copied cell data will be pasted as-is

Pasting New Rows at the Bottom of the Grid

By default, when pasting multiple rows near the last record shown in the grid, any rows exceeding the total number of rows shown in the grid will not be pasted.

In order to insert all the copied rows in the grid, a custom processDataFromClipboard function is needed to add the necessary number of new rows using the Transaction Update API.

The example below uses a custom processDataFromClipboard function to add new rows to the grid, to fit all the copied rows:

• Select the top 3 rows in the grid using ⇧ Shift + click
• Press ^ Ctrl+C to copy the selected rows
• Select the Ryan Lochte cell on the last row and press ^ Ctrl+V to paste the copied rows
• Notice that the Ryan Lochte row has been overwritten and 2 extra rows are created at the bottom of the grid to accommodate the additional 2 rows pasted

Read Only Edit

When the grid is in Read Only Edit mode the Clipboard will not update the data inside the grid. Instead the grid fires cellEditRequest events allowing the application to process the update request.

The example below will show how to update cell value combining the Clipboard with readOnlyEdit=true.

Changing the Delimiter for Copy & Paste

By default, the grid will use \t (tab) as the field delimiter. This is to keep the copy / paste compatible with Excel. If you want another delimiter then you can set the property gridOptions.clipboardDelimiter to a value of your choosing.

Using the Browser's Text Selection

The grid's selection and copy features replace the built-in browser behaviour for selecting and copying text. If you want to use the normal browser behaviour instead, you should set enableCellTextSelection=true in the gridOptions. Note the following:

• When enableCellTextSelection=true, pressing ^ Ctrl+C doesn’t copy the focused cell value, but only the selected text inside the grid cell. When using AG Grid Enterprise, the user can copy the entire cell value by right-clicking the grid cell to show the context menu and clicking the any of the Copy menu items.

• When enableCellTextSelection=true, the option ensureDomOrder=true needs to be set for correct accessibility support. See Ensure DOM Element order.

See this behaviour shown in the example below:

• Focus a grid cell and press ^ Ctrl+C. The cell value will not be copied because no text is selected.

• Click a cell and drag across its value to select the text. Press ^ Ctrl+C and the value will be copied.

• This sample is using AG Grid Community version, so the context menu is not available to copy the focused cell value. In AG Grid Enterprise the context menu will be available to copy the entire focused cell value without having to select it as text.

Clipboard Events

The following events are relevant to clipboard operations:

For a cut or paste operation the events will be fired as:

1. One cutStart/pasteStart event.
2. Many cellValueChanged events.
3. One cutEnd/pasteEnd event.

If the application is doing work each time it receives a cellValueChanged, you can use the cutStart/pasteStart and cutEnd/pasteEnd events to suspend the applications work and then do the work for all cells impacted by the cut/paste operation after the cut/paste operation.

There are no events triggered by copy to clipboard as this does not change the grid's data.