cannot copy from numbers to pages

cannot copy from numbers version 10.0 (6748) to pages version 10.2 (7028.0.88


iMac Pro

Posted on Oct 1, 2020 11:11 PM

Reply
Question marked as Top-ranking reply

Posted on Oct 2, 2020 8:19 AM

When you select, and copy cells from Numbers with text and formulas, Pages detects this on the clipboard, and offers a special paste category that preserves the data and formulas — Paste Formula Results, which has no assigned keyboard shortcut. After clicking once in the Pages document, and in practice, whether you use this menu item, or just a simple Paste, it appears that the original appearance, and formulas from Numbers are preserved — where Pages tables support those Number's cell formats — and a new table is created with this content in the Pages document.


If you insert a blank Pages table, and single-click the first cell to select it, then choose Paste, you will receive the original numbers data, including functional formulas. Doing so with Paste and Match Style, or Paste Formula Results will paste content without active formulas, and the latter will paste in monochrome.


Tested with Pages/Numbers v10.1 on Mojave 10.14.6 (18G6032).

4 replies
Question marked as Top-ranking reply

Oct 2, 2020 8:19 AM in response to wilhco

When you select, and copy cells from Numbers with text and formulas, Pages detects this on the clipboard, and offers a special paste category that preserves the data and formulas — Paste Formula Results, which has no assigned keyboard shortcut. After clicking once in the Pages document, and in practice, whether you use this menu item, or just a simple Paste, it appears that the original appearance, and formulas from Numbers are preserved — where Pages tables support those Number's cell formats — and a new table is created with this content in the Pages document.


If you insert a blank Pages table, and single-click the first cell to select it, then choose Paste, you will receive the original numbers data, including functional formulas. Doing so with Paste and Match Style, or Paste Formula Results will paste content without active formulas, and the latter will paste in monochrome.


Tested with Pages/Numbers v10.1 on Mojave 10.14.6 (18G6032).

Oct 2, 2020 12:53 AM in response to Barry

Apologies I accidentally ticked right answer

I used to be able to simply copy a section out of a table containing both text and calculations and paste it straight into pages.

I have used all previous method used:

command+c and then command+v

Edit copy in Numbers and Edit paste in Pages

Edit copy in Numbers and Edit paste formula results in Pages

Nothing works

This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

cannot copy from numbers to pages

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.