Initializing help system before first use

Table Data Copy, Paste and Undo

The described range of table selection options supports copying and pasting table data. This functionality is designed to support use-cases such as copying a table selection into an external tool - such as Excel - manipulating it and then pasting it back.

Copy the current selection into the system clipboard in TSV (Tab Separated Variables) format using CTRL-C. Paste it into a target application using CTRL-V. Boolean cell values are copied as '0' or '1', and non-boolean fields using checkboxes copy the underlying data.

Use CTRL-V to paste data from the clipboard into the current table relative to the current active cell or block selection. The paste operation supports a maximum of 5000 values for performance reasons. If a row filter is present in the table, pasted data is validated against the filter and the paste operation will fail if any of the modified rows would subsequently be filtered out. If you paste into a larger block selection than is contained in the current clipboard, the clipboard contents are tiled so as to fill up the receiving block selection. Pasting will not overwrite index columns and cannot be used to add new rows to the table.

Undo

Xpress Insight tables support a single level undo, in which you can revert the last change you made to an editable table. You can undo single pastes, cell edits or row deletions - use the key combination CTRL-Z. A successful undo generates an information message - Last table change was reverted.

Parent Topic Using Tables to Select, Navigate and Edit Data