On working with data in table area via clipboard, the following operations are available:
To copy cell values or selected cell range to clipboard:
Select the Copy context menu item of the cell or cell range.
Press CTRL+C.
To cut cell values or selected cell range to clipboard:
Select the Cut context menu item of the cell or cell range.
Press CTRL+X.
To paste values of the cell or selected cell range from clipboard to the current table area location:
Select the Paste context menu item of the cell or cell range.
Press CTRL+V.
If pasted range is out of the table area, paste will be executed inside table area.
If the size of selected for paste cell range is less, the range size where data is pasted will be broaden right and button to the size of pasted range.
If the size of selected for paste range is greater, only the range corresponding to the size of pasted range will be filled in.
If the range is selected for cell paste, the range will be entirely filled with data from the cell.
The Interactive Data Entry Forms extension supports pasting of data on copying from the products:
Microsoft Office.
LibreOffice.
MyOffice.
Google Sheets.
Clipboard contents is pasted to a data entry form sheet:
With saving source formatting if the form is opened for edit.
Without saving source formatting if the form is opened for view.
NOTE. When data is pasted from MyOffice and Google Sheets, source formatting is not saved.
See also:
Data Entry and Saving | Building Data Entry Form | Working with Ready Data Entry Form