14 Replies Latest reply: Feb 21, 2008 4:25 PM by WWJD
yetsirah Level 1 Level 1 (0 points)
Hello,

I finished building a Numbers SS tonight and was preparing to insert the Table data into a Pages document. I prefer to keep the info in the SS and then use the Table data in a Layout prog. when applicable. Well, even though i can do this same thing with M$ Office, I can't seem to find a way to do it in iWork '08. I tried copying, dragging dropping, and even opening. No deal. I tried dragging the file onto the open Pages doc—eh uh. I received a big shake of the finger on that one.

Can someone suggest a way to do this—someone that has done it and it worked?

MBP, Mac OS X (10.5.1)
  • Walt K Level 4 Level 4 (2,905 points)
    Welcome to Apple Discussions.

    I think this will do what you're asking: in the Thumbnails, click on the table you want and then Copy. In Pages Layout click in the page (not the Thumbnail) you want the SS in and then Paste. You may have to resize the table.

    Walt
  • yetsirah Level 1 Level 1 (0 points)
    Weird, does this work for you? For me it completely drops the table. All data shows up but the table is completely gone.
  • WWJD Level 6 Level 6 (15,825 points)
    Here is an example where I selected the table and graph, copied then paste into Pages:

    Photobucket

    Make sure the the selection shows the "open boxes" at the corners of the table.

    Regards,
  • yetsirah Level 1 Level 1 (0 points)
    AHHH... For some reason the '06 opened. I just figured that out. It works great in 08. Man that was frustrating. I thought 06 would have been removed. Thank you all for your help.

    j
  • WWJD Level 6 Level 6 (15,825 points)
    If you have both versions of iWork, then you have both versions on your HD. Once you are comfortable with '08, '06 can be deleted.

    Regards,
  • NYCTREE Level 1 Level 1 (0 points)
    when I try this, the data in some cells changes or is missing, it is like the formulas in the cells are looking for the wrong thing, shouldn't the copy/paste just put the format and VALUES from numbers into pages? what is wrong? this is always such a straight forward process with excel and word.
  • JanM Level 1 Level 1 (0 points)
    I thought that this thread would solve my problem, but it doesn't. I want to insert a Numbers document that has a bunch of arrows and text boxes and things like that, into a Pages document. When I copy either the entire Numbers document or Table 1, I get the text and colors but the arrows are all over the place and things aren't formatted properly, even the column headings aren't formatted as they are in the Numbers document. Is there some way to combine the two documents?
  • J Douglas Rogers Level 1 Level 1 (25 points)
    I wanted to exactly this today in Mail. What I found after reading this thread was this:

    one sheet with one table

    select and copy the table, you get the text.
    select and copy the sheet, you get the table.
  • WWJD Level 6 Level 6 (15,825 points)
    You might select all of the objects then group then copy and paste. See below.

    Select Objects:
    Photobucket

    Select Group:
    Photobucket

    Copy then Paste into Pages:
    Photobucket

    Regards,
  • JanM Level 1 Level 1 (0 points)
    Thanks, that sounded as if it would work, but it doesn't. When I select everything (either manually or using Select All) and then group, copy and paste into the Pages document, I get only the things other than the chart (arrows, bubbles, text box) and they aren't the same size as in Numbers, so some things get cut off. I could probably deal with that, but not with losing the entire chart as well as the column and row headings. And yes, the open boxes at the top, bottom & sides of the chart showed before I did "group" so I'm reasonably confident everything was selected. Oh, and when I say "chart" it's just a spreadsheet with rows and columns of information, mostly text. I was using Numbers essentially as a layout tool, not to do any computations at all. It worked very well - I could put arrows where I wanted them and color things and add text boxes. But if I can't move it into a Word Processing document it's not nearly so useful.
  • WWJD Level 6 Level 6 (15,825 points)
    OK, I tried to group the tables but only the chart and graphic objects would group. Tables do not group but are copied in sequence but not in the layout in Numbers. Can objects in Pages be made to float (in Word you can change this behavior)? Here's my trial:

    Numbers Selection:
    Photobucket

    Pages Paste Page 1 (Tables not grouped as in Numbers):
    Photobucket

    Pages Paste Page 2 (Charts & Graphic Object Paste true):
    Photobucket

    Regards,
  • JanM Level 1 Level 1 (0 points)
    I guess the answer is that if the Numbers document is simple it can be copied and pasted into Pages but if it's complicated (mine has very complicated layout - arrows with description in text boxes that are lined up with the arrows and the arrows go from one chart to another) it just isn't going to work.

    I'm going to try to reverse approach and put the Word Processing things into the Numbers document in text boxes before and after the chart - that should work, I hope.
  • JanM Level 1 Level 1 (0 points)
    I found a different work-around. Export the Numbers sheet as PDF and then insert as "picture" in the Pages document. That worked.
  • WWJD Level 6 Level 6 (15,825 points)
    Yes, that is a good work-around if the quality of the pdf file is high enough for your situation.

    Regards,