Skip navigation

Numbers buggy

367 Views 8 Replies Latest reply: Jan 29, 2013 11:08 AM by Badunit RSS
tomtombs Calculating status...
Currently Being Moderated
Jan 29, 2013 9:52 AM

When I try to continue a Numbers table that simply fails at the simplest things. Have a look at just two pictures. When one is not akzpetiert the other. I'm stumped.

 

 

Leer.jpg

 

Leer 2.jpg

  • Wayne Contello Level 6 Level 6 (12,790 points)
    Currently Being Moderated
    Jan 29, 2013 10:20 AM (in response to tomtombs)

    You are pointing to a cell that is indicating an error (as demonstrated by the orange triangle in the cell).

     

    What is the message you see if you click the triangle in the cell?

     

    I clicked on a cell where I introduced an error (I reference a cell that is not in the table) and here is what I get:

    Screen Shot 2013-01-29 at 12.10.22 PM.png

  • Wayne Contello Level 6 Level 6 (12,790 points)
    Currently Being Moderated
    Jan 29, 2013 10:40 AM (in response to tomtombs)

    The formula you entered has a syntax error.  The formula entered is not correct because the text for the formula elements is not converted to a tag. like:

     

    Good:

    Screen Shot 2013-01-29 at 12.31.26 PM.png

    Bad:

     

    Screen Shot 2013-01-29 at 12.31.16 PM.png

     

    The cell "WP Nacht Verbrach 01.02.2013" is not a good cell reference

     

    I do NOT recommend using the Feature "Use header cell names as references" in the Numbers Preferences.

  • Wayne Contello Level 6 Level 6 (12,790 points)
    Currently Being Moderated
    Jan 29, 2013 10:57 AM (in response to tomtombs)

    Best I can tell you are attempting to reference a cell who row header names do not match the row and column in the table.  Are you trying to reference a cell in another table?

  • Badunit Level 6 Level 6 (10,775 points)
    Currently Being Moderated
    Jan 29, 2013 11:07 AM (in response to tomtombs)

    Sometimes Numbers has problems with cell references. Often it happens when using header cell names as references and very often it is when a cell header (and, therefore, the reference) has non-alphanumeric characters in it. But it also happens sometimes with normal cell references like B2, C10, etc..

     

    As Wayne suggested, open Preferences and uncheck the box for "use cell names as references". That may be enough to fix your problem.

     

    When this problem happens to me, I do this workaround to get around the bug: Instead of selecting the cell I want to reference, I will select a cell next to it then I will adjust it to the correct cell afterward.  As an example, if I want to create the formula =B2 but it won't turn the "B2" into a reference, I will write the formula as =B3 then I will change it to B2 afterward.  Usually this works.

  • Badunit Level 6 Level 6 (10,775 points)
    Currently Being Moderated
    Jan 29, 2013 11:08 AM (in response to tomtombs)

    We have been waiting patiently for several years for such an update.

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.