Skip navigation

How to paste calculated values from Numbers?

353 Views 3 Replies Latest reply: Jan 20, 2013 6:20 PM by 4thSpace RSS
4thSpace Level 1 Level 1 (0 points)
Currently Being Moderated
Jan 20, 2013 8:54 AM

When I copy calculated values from Numbers and paste into a table in Pages, I get an image like the one below.  Non calculated values paste fine.

 

To get around this issue, I paste the calculated values into TextWrangler, then copy from there and paste into Pages.  Is there a way to go directly from Numbers to Pages with calculated values?

 

BBS_ExposureThruTwitterHashTags no graphs.pages-1.png

  • Jeff Shenk Level 4 Level 4 (1,995 points)
    Currently Being Moderated
    Jan 20, 2013 12:16 PM (in response to 4thSpace)

    I think maybe the easiest way to deal with this is with a small work around in Numbers.

     

    After you copy your values in Numbers, click on the page outside any table. From the Edit menu, select Paste Values. This will produce a new table with just the calculated values. Copy this and paste it into Pages. Now you can delete the extra table in Numbers. (Or just cut and paste).

  • Yellowbox Level 4 Level 4 (3,870 points)
    Currently Being Moderated
    Jan 20, 2013 5:49 PM (in response to Jeff Shenk)

    Hi 4th Space,

     

    I you are pasting into a table in Pages, follow Jeffs instructions.

     

    I you are not pasting into a table, this works. Copy the cells in Numbers. Go to your Pages document and under the Edit Menu > Paste and Match Style. It works like Paste Values.

     

    Ian.

Actions

More Like This

  • Retrieving data ...

Bookmarked By (0)

Legend

  • This solved my question - 10 points
  • This helped me - 5 points
This site contains user submitted content, comments and opinions and is for informational purposes only. Apple disclaims any and all liability for the acts, omissions and conduct of any third parties in connection with or related to your use of the site. All postings and use of the content on this site are subject to the Apple Support Communities Terms of Use.