Paste Special

One can edit data pasted from the clipboard:

Enable the Paste Special option. To do this, select the checkbox in the cell's context menu.
Press CTRL+ALT+V. It is available if the web application works via the HTTPS protocol.

The Paste Special dialog box opens during paste from the clipboard:

Set the parameters:

Paste from Clipboard. Determine special paste parameters:
- Cell Values. The checkbox is selected by default, and cell values are pasted. When the checkbox is deselected, cell values are not pasted.
- Cell Formulas. The checkbox is selected by default, and formulas from the cells are pasted. When the checkbox is deselected, cell formulas are not pasted.
- Cell Formatting. The checkbox is selected by default, and cell formatting is pasted. When the checkbox is deselected, the format specified for cells, to which data was pasted, will be be used.
- Comments. The checkbox is selected by default, and cell comments are pasted. When the checkbox is deselected, cell comments are not pasted.
Skip Empty Cells. If the pasted data contains empty values, on selecting the checkbox the data is not pasted. Old data remains in the cells, to which empty values should have been pasted.
Transpose Data. When the checkbox is selected, inserted data is transposed, that is, rows are shown in columns and vice versa.

To restore the data paste mode from the clipboard without data correction, deselect the Paste Special checkbox in the cell's context menu.