You can copy data values within a data form, from one data form to another, or from another application, such as Microsoft Excel. In one copy and paste operation, you can copy from one cell to another cell, from one cell to many cells, or from many cells to many cells.
Because Planning applies spreading logic to pasted values, understand how data values are spread before you paste values into time periods. See How Spreading Data Works. |
To copy and paste data:
Right-click, select Edit, and select an option:
Cut to remove the cell values
Copy to copy the cell values. Select the cells to which to paste the data. Right-click, and then select Paste.
Paste inserts the Clipboard contents at the insertion point, replacing any selection.
Clear to clear the cell values
About copying and pasting data:
If the destination selected area is an exact multiple of the size and shape of the copied selected area, the data is repeatedly pasted into the destination area. For example, if you copy the contents of two rows, and select six rows to paste the data into, Planning copies the contents of the two rows three times, to fill the six destination rows.
When you copy within or among data forms, Planning copies and pastes the cells' stored values, not the values that are displayed based on the precision setting.
Data that is copied and pasted from Microsoft Excel to Planning reflects the formatting that is set up in Microsoft Excel. For example, if the number of decimal places in Microsoft Excel is set to zero, when you enter the value 459.123 in Microsoft Excel, the value is displayed as 459. If you copy this value into a Planning form, the value 459 is pasted.
When pasting data to time periods, Planning applies the spreading rules for each cell in succession, starting from left to right and top to bottom. The resulting data from a paste operation may not match the original copied data. For information on how pasting data may affect cells' values, see How Spreading Data Works.
When you copy data, a message might display if you disabled Internet Explorer’s setting for Allow Paste Operations via Script.
Copying and pasting data from a text editor (for example, TextPad, Notepad, or WordPad) fails if the data is space delimited. Use Tab-delimited values instead.