To work with the tool in Foresight Analytics Platform 10, use the new interface.
On working with data in table area via clipboard, the following operations are available:
NOTE. Working with clipboard between browser tabs in the web application is available only via shortcuts. There may be some restrictions depending on the browser security policy.
To copy cell values or selected cell range to clipboard:
Click the Copy button in the Clipboard group on the Home ribbon tab.
Select the Copy context menu item of the cell or cell range.
Press CTRL+C or CTRL+INSERT.
To cut cell values or selected cell range to clipboard:
Click the Cut button in the Clipboard group on the Home ribbon tab.
Select the Cut context menu item of the cell or cell range.
Press CTRL+X or SHIFT+DELETE.
To paste values of the cell or selected cell range from clipboard to the current table area location:
Click the Paste button in the Clipboard group on the Home ribbon tab.
Select the Paste context menu item of the cell or cell range.
Press CTRL+V or SHIFT+INSERT.
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.
When pasting clipboard contents to a data entry form sheet, the Paste Options button appears at the right bottom corner from the pasted cells, which indicates whether the pasted data has proper formatting. Clicking the Paste Options button displays paste options:
Keep Source Formatting. Data will be pasted using source formatting.
Paste Without Source Formatting. Data will be pasted using the cell format, to which paste is executed.
NOTE. When data is pasted from MyOffice and Google Sheets, source formatting is not saved.
The paste options button is temporarily hidden:
On focusing other elements (for example, font, formula bar, and so on).
On opening dialog box.
On opening context menu.
On switching to cell edit mode for one of the pasted cells, provided that nothing was modified, and/or the user exited the edit mode using the ESC key.
The Paste Options button is fully hidden when:
Clipboard contents is changed (for example, data of another cell is copied).
On switching to cell edit mode for any cell outside the paste range and exiting the edit mode, even if nothing was modified.
On changing sheet state (for example, changing of sheet zoom).
On pressing the ESC key after pasting data.
See also:
Getting Started with the Interactive Data Entry Forms in the Web Application | Building Data Entry Form | Working with Ready Data Entry Form