There are various options to copy & paste data between grids and other applications.
![Data_Interface_Grid_CellPaste](data_interface_grid_cellpaste.png)
Select the required data, then press CTRL+C:
![Data_Interface_Grid_CellCopy](data_interface_grid_cellcopy.png)
Select the destination cell, and the insertion point, then press CTRL+V:
![Data_Interface_Grid_CellPaste](data_interface_grid_cellpaste.png)
Alternately these actions can be selected from the contextual menu shown by right-clicking in the cell:
![Data_Interface_Grid_Contextual_Clipboard](data_interface_grid_contextual_clipboard.png)
|
Click on a row header to select a single record, or press CTRL+A to select all records:
![Data_Interface_Grid_Records_SelectAll](data_interface_grid_records_selectall.png)
Press CTRL+C to copy data to the clipboard.
Note
|
•Selection of ranges is not supported. •Only data from visible columns is copied. |
|
Turn off continuous range mode, if its enabled:
![Data_Interface_Ribbon_Button_Point_ContinuousRange](data_interface_ribbon_button_point_continuousrange.png)
Select the left-most cell, then press the ESC key to ensure that the editor is closed:
![Data_Interface_Grid_Records_Paste_Select](data_interface_grid_records_paste_select.png)
Press CTRL+V:
![Data_Interface_Grid_Records_Paste_Final](data_interface_grid_records_paste_final.png)
|
Select the cell to begin inserting data, then press CTRL+V.
|
Pasting data will generate new records, and default values will be set when creating these records.
Select the desired range of cells in Excel and press CTRL+C:
![Data_Tools_CopyPaste_Excel_CopyKeys](data_tools_copypaste_excel_copykeys.png)
Turn off continuous range mode, if its enabled:
![Data_Interface_Ribbon_Button_Point_ContinuousRange](data_interface_ribbon_button_point_continuousrange.png)
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](data_interface_grid_records_paste_select.png)
Press CTRL+V:
![Data_Tools_CopyPaste_Grid_PasteKeys](data_tools_copypaste_grid_pastekeys.png)
|
The number of rows in the copied range must be less than or equal to the existing row count and will change existing data.
Select a range of cells in Excel and press CTRL+C:
![Data_Tools_CopyPaste_Excel_CopyData](data_tools_copypaste_excel_copydata.png)
Select the cell to start pasting data, then press the ESC key to ensure that the editor is closed:
![Data_Tools_CopyPaste_Grid_PasteCell](data_tools_copypaste_grid_pastecell.png)
Press CTRL+V:
![Data_Tools_CopyPaste_Grid_PasteData](data_tools_copypaste_grid_pastedata.png)
Notes
|
•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. |
|