Problems when pasting values from Prism Mac into iWork Numbers or Excel.

Problem: All values paste into one cell

If you double clicked on a cell in Numbers or Excel, then there will be a flashing insertion point to indicate that you are in edit mode. All values in the clipboard will paste into that one cell. This is frustrating because the appearance of edit mode is so subtle. Look for the insertion point. Excel works the same way, but it is much more obvious when you are in the edit mode, as the selected cell is shown with a drop shadow, giving a 3D look.

Instead, single click on a cell before pasting. The cell will have a border to show it is selected, but  there will be no flashing insertion point. Now, each value will paste into its own cell, starting at the spot you selected. Numbers and Excel work the same way. 

Problem: Only a portion of the copied values paste

If you selected a range of cells in Numbers, then each value will paste into its own cell within that range. If the table copied to the clipboard is longer or wider than the region you selected in Numbers, some values won't paste. In contrast, Excel will paste beyond the selected range to paste all the values on the clipboard.