Using copy & paste

<< Click to Display Table of Contents >>

Navigation:  Data Module > Data entry > Using data grids >

Using copy & paste

There are various options to copy & paste data between grids and other applications.

Data_Interface_Grid_CellPaste

hmtoggle_arrow1How To: Copy / paste editor data

img_1 Select the required data, then press CTRL+C:

Data_Interface_Grid_CellCopy

img_2 Select the destination cell, and the insertion point, then press CTRL+V:

Data_Interface_Grid_CellPaste

Alternately these actions can be selected from the contextual menu shown by right-clicking in the cell:

Data_Interface_Grid_Contextual_Clipboard

hmtoggle_arrow1How To: Copy records (one or more)

img_1 Click on a row header to select a single record, or press CTRL+A to select all records:

Data_Interface_Grid_Records_SelectAll

img_2 Press CTRL+C to copy data to the clipboard.

noteNote

•Selection of ranges is not supported.

•Only data from visible columns is copied.

hmtoggle_arrow1How To: Paste records into the same grid

img_1 Turn off continuous range mode, if its enabled:

Data_Interface_Ribbon_Button_Point_ContinuousRange

img_2 Select the left-most cell, then press the ESC key to ensure that the editor is closed:

Data_Interface_Grid_Records_Paste_Select

img_2 Press CTRL+V:

Data_Interface_Grid_Records_Paste_Final

hmtoggle_arrow1How To: Paste records into Excel

Select the cell to begin inserting data, then press CTRL+V.

hmtoggle_arrow1How To: Paste Excel data into grid with key values

Pasting data will generate new records, and default values will be set when creating these records.

img_1 Select the desired range of cells in Excel and press CTRL+C:

Data_Tools_CopyPaste_Excel_CopyKeys

img_2 Turn off continuous range mode, if its enabled:

Data_Interface_Ribbon_Button_Point_ContinuousRange

img_3 Select the left-most cell to start pasting data, then press the ESC key to ensure that the editor is closed:

Data_Interface_Grid_Records_Paste_Select

img_4 Press CTRL+V:

Data_Tools_CopyPaste_Grid_PasteKeys

hmtoggle_arrow1How To: Paste Excel data into grid without key values

The number of rows in the copied range must be less than or equal to the existing row count and will change existing data.

img_1 Select a range of cells in Excel and press CTRL+C:

Data_Tools_CopyPaste_Excel_CopyData

img_2 Select the cell to start pasting data, then press the ESC key to ensure that the editor is closed:

Data_Tools_CopyPaste_Grid_PasteCell

img_3 Press CTRL+V:

Data_Tools_CopyPaste_Grid_PasteData

noteNotes

•Data is pasted in exactly the same order as it is shown in Excel, so ensure that the column order is exactly the same.

•When data is pasted, all constraints are enforced (i.e. data types, lookup codes) and may result in errors where differences occur.