Data pasted into the table or list is analyzed. The results of the analysis can be seen in the Paste Preview with specific cell errors shown in tooltips:
- Paste Area Frame: the total paste area is distinguished by a two-pixel frame, or border. If the paste area extends beyond the display, the frame appears open in that direction.
- White cells: the data in the cell is unchanged. Hovering above the cell lets you see the old and new values (in this case, they are the same) in a tooltip. Standard typeface is used for cell values.
- Green cells: the data in the cell is new and has been successfully pasted, replacing any empty or old values. Cell values are bold. Hovering above the cell lets you see the old and new values in a tooltip.
For dynamic lists that allow sub-items, new sub-item cells are also shaded in green with bold cell values.
- Yellow background: in order to paste the data, PPM performed an automatic adjustment. For example: a float number was pasted into a cell that was defined for integer input. The new value is automatically rounded so it can be pasted into the cell. Hovering above the cell lets you see a tooltip showing the old and new values as well as the conversion that was performed.
For dynamic lists, any sub-item rows that were replaced and renamed are shaded in yellow with bold cell values.
- Red background: the new table or list value cannot be pasted and appears crossed-out in the cell. Hovering over a red cell presents a tooltip showing its old value and invalid new value, as well as the reason the new value cannot be pasted.
Note:
- If the cell holds a Calculated or Imported category value, the tooltip will show old and new values. If the cell is Denied View, the tooltip will not show values.
- You can only copy and paste entire rows or columns if their titles are identical.