Skip navigation

cannot copy/paste in a table in numbers

1957 Views 13 Replies Latest reply: Feb 26, 2014 9:31 AM by maxo44 RSS
tarcisiogreggio Level 1 Level 1 (0 points)
Currently Being Moderated
Feb 7, 2013 1:38 PM

I can´t copy/paste any data in a table in numbers and even copy this table from numbers to pages.
note: this is happening to a single table

 

any thoughts?

 

thanks!

MacBook Pro (13-inch, Mid 2012), Mac OS X (10.7.5)
  • Jerrold Green1 Level 7 Level 7 (28,185 points)
    Currently Being Moderated
    Feb 7, 2013 2:27 PM (in response to tarcisiogreggio)

    Perhaps you have a Locked table there.

     

    Jerry

  • Ciro Bruno Level 1 Level 1 (0 points)
    Currently Being Moderated
    Feb 14, 2013 3:08 PM (in response to tarcisiogreggio)

    I've been facing the same issue! I can't copy any table nor any cell from a single Numbers file! Doesn't matter what part of this file or wherever I want to copy into, it simply doesnt work!

     

    This file is NOT LOCKED!

     

    The only "new procedure" I've performed has been to send it to be edited in my iPad. I'm not sure, but maybe sharing this file with iPad has damaged it. I wish I find out later that I'm wrong, but right now I wish I hadn't shared this file with iPad.

     

    I guess I'd better export my file to MS Excel and continue my work there from now on.

     

    Anyway, I'd be glad to understand what happened and to learn how to fix it!

     

    Await for replies and contributions.

     

    Regards, Ciro.

  • Jerrold Green1 Level 7 Level 7 (28,185 points)
    Currently Being Moderated
    Feb 14, 2013 3:17 PM (in response to Ciro Bruno)

    Ciro,

    Ciro Bruno wrote:

     

    I've been facing the same issue! I can't copy any table nor any cell from a single Numbers file! Doesn't matter what part of this file or wherever I want to copy into, it simply doesnt work!

     

    This file is NOT LOCKED!

     

    The only "new procedure" I've performed has been to send it to be edited in my iPad. I'm not sure, but maybe sharing this file with iPad has damaged it. I wish I find out later that I'm wrong, but right now I wish I hadn't shared this file with iPad.

     

    I guess I'd better export my file to MS Excel and continue my work there from now on.

     

    Anyway, I'd be glad to understand what happened and to learn how to fix it!

     

    Await for replies and contributions.

     

    Regards, Ciro.

     

    Since the writer of the original question never returned, one assumption would be that we solved his/her problem.

     

    Notice that I did not suggest that the file was locked, only the table.

     

    Jerry

  • Ciro Bruno Level 1 Level 1 (0 points)
    Currently Being Moderated
    Feb 15, 2013 5:18 AM (in response to Jerrold Green1)

    I understand, I'd assume it likewise.

     

    How can a table witin a file be locked? I can't find any related command in the menu.

     

    By "locked" I understood locked file.

     

    Thank you.

    Regards, Ciro.

  • Wayne Contello Level 6 Level 6 (12,640 points)
    Currently Being Moderated
    Feb 15, 2013 5:26 AM (in response to Ciro Bruno)

    you lock a table by selecting the table, then using the key combination <COMMAND> + L or the menu item "Arrange > Lock"

     

    Screen Shot 2013-02-15 at 7.25.23 AM.png

  • Jerrold Green1 Level 7 Level 7 (28,185 points)
    Currently Being Moderated
    Feb 15, 2013 5:42 AM (in response to Ciro Bruno)

    Ciro Bruno wrote:

     

    I understand, I'd assume it likewise.

     

    How can a table witin a file be locked? I can't find any related command in the menu.

     

    By "locked" I understood locked file.

     

    Thank you.

    Regards, Ciro.

    A locked table, or any other "object", can be identified by little "x"s in the corners. Arrange > Unlock will turn these figures into normal sizing handles. See Locking and Unlocking Objects in Chapter 9 of the Numbers User Guide. You can download the guide from the Help menu.

     

    Jerry

  • Ciro Bruno Level 1 Level 1 (0 points)
    Currently Being Moderated
    Feb 15, 2013 6:17 AM (in response to Jerrold Green1)

    Thank you Jerry and Wayne.

     

    I found it (⌘L). In my table only ⌘L is available, ⌥⌘L isn't. It means that it hasn't been locked.

     

    We're back to stage 1. It seems that this file has somehow been corrupted. I can't figure out how!

     

    My only suspicion regards the file exchanging between Mac OS and iOS.

     

    Tarcisio, can you help us? Have you also transfered your Numbers file to iOS and then cought it back to Mac OS?

     

    Regards,

    Ciro.

  • Jerrold Green1 Level 7 Level 7 (28,185 points)
    Currently Being Moderated
    Feb 15, 2013 7:59 AM (in response to Ciro Bruno)

    Ciro,

     

    I can tell you, because it has happened to me, that it is easy to accidently lock a table in the iOS version with a slip of the finger.

     

    Jerry

  • Ciro Bruno Level 1 Level 1 (0 points)
    Currently Being Moderated
    Feb 15, 2013 8:59 AM (in response to Jerrold Green1)

    In fact I'm afraid I don't domain the gesture for iWork in iOS. I'm not able to create tables and to do advanced tasks yet. That's why I use to prepare them in Mac OS and transfer to iOS to have them available in the field. Back to the office, I return them to Mac OS to process data.

     

    Anyway, I think that any commands in Numbers for iOS should have its equivalent in Numbers for Mac OS and vice-versa. If it has been locked in iOS, i should be able to unlock and re-lock it in Mac OS. Doesn't it sound reasonable?

     

    Would it be suitable for an issue feedback?

     

    Thank you.

    Regards, Ciro.

  • Jerrold Green1 Level 7 Level 7 (28,185 points)
    Currently Being Moderated
    Feb 15, 2013 9:26 AM (in response to Ciro Bruno)

    Ciro,

     

    No, there is nothing reportable with the controls for locking and unlocking tables across iCloud. You can lock a table in the Mac environment and unlock it in the iOS environment, and you can lock a table in the iOS environment and unlock it in the Mac environment. There is nothing broken there, nothing to be fixed.

     

    Here's the Mac control:

    Screen Shot 2013-02-15 at 12.14.37 pm.png

     

     

    Here's the control on the iOS side:

     

    IMG_0084.png

     

    The screen shot above is from the Format menu, but the following option appears upon just touching a locked table:

     

    IMG_0086.png

     

    Jerry

  • macmva Level 1 Level 1 (0 points)
    Currently Being Moderated
    Feb 20, 2013 7:29 AM (in response to tarcisiogreggio)

    I have the same problem. Making a copy of the file in Mac helps. Seems to be problem between iCloud and Mac...

  • maxo44 Level 1 Level 1 (0 points)
    Currently Being Moderated
    Feb 26, 2014 5:48 AM (in response to tarcisiogreggio)

    I have the same problem. I can't copy/paste cell contents, nor copy/paste a style from one cell to another. It is only this file, no problem with other files.

     

    Interesting fact to note is it was originally a Microsoft Excell file, that was opened in Numbers, and I created a new work sheet. But it was saved as a numbers file now.

     

    I tried creating a new file and copy/pasting my table there, but even though in that file I can copy/paste cell contents and styles, it doesn't allow me to paste the table from the other file.

  • maxo44 Level 1 Level 1 (0 points)
    Currently Being Moderated
    Feb 26, 2014 9:31 AM (in response to maxo44)

    Solved my issue: I have a copy of Excell for Mac, I saved the numbers file in .xls, opened it in Microsoft Excell, saved it again in .xlsx format and opened it again in Numbers. Now I can copy/paste again.

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.