A set of examples follows to show you that various types of cell selections that are valid for pasting a single value or multiple values into a planning view. For common questions about pasting values, see these topics:
A single value can be pasted into a single cell, multiple adjacent cells, or multiple non-adjacent cells. Consider a case were the following value was copied from another measure item in a view. Examples follow that show that value being copied into one and then multiple cells.
First, one cell was right-clicked and Paste was selected from the pop-up menu.
Here is the paste result.
Next, three adjacent cells were selected for the Paste area.
Here is the paste result.
Finally, two non-adjacent cells were selected for the Paste area. The first cell that was selected has a blue background, and the second cell that was selected has a black border but no special background shading.
Here is the paste result.
When multiple values are used for a copy and paste, the copy and paste selection areas must match in size and shape. For example, Actual Sales Units values from a 3 by 1 block of cells were copied in this first example.
An area of the same size and shape was selected in order to update Budget Units Working values.
Here is the paste result.
In this example, values from two adjacent cells in a row were copied.
The user then right-clicked in a single cell elsewhere in the grid and chose Paste from the pop-up menu.
Stratum.Viewer calculated the paste area in this case, using the single cell as the starting point of the paste and moving right to the next available cell. If any cells in the area calculated by Stratum.Viewer had been read only or had not met planning requirements, then the paste would not have been completed. A message would display explaining why the paste could not be completed.
