Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

Numbers 3 has bugs in calculations.

Hi,


Numbers 3 has bugs in calculations. And I do not mean rounding errors. I mean plain wrong. How can I get back to my older version? I have a time machine backup.


Thanks,

Gerd

MacBook Pro, OS X Mavericks (10.9)

Posted on Oct 25, 2013 3:42 PM

Reply
43 replies

Oct 26, 2013 12:32 PM in response to Gerd Castan

Hi Gerd,


I opened the document and here is what I get. As you can see, it doesn't seem to be a Numbers bug.


User uploaded file


I see you have the data format for the first row of the Jährliches Budget nach Monaten table set to Automatic and the format for the Monat column as a pop-up. You could try changing the data format for the first row of the Jährliches Budget nach Monaten table to a pop-up (and add the same pop-up list as you have in the yada table) and see if that helps.


Or maybe it's related somehow to your Language & Region preferences (System Preferences>Language & Region>Advanced>Dates.... Mine are like this and it's possible Numbers 3 is too fussy about what it expects.


User uploaded file


SG

Oct 26, 2013 12:54 PM in response to SGIII

On other thought. Numbers seems to be a little *too* smart about guessing whether you mean a date or not. For example if you type Jan into a cell on your system it will probably convert that to a date and show Januar. It probably is taking the text values from the Pop-up and converting those to dates too. To avoid unwanted conversion to a date try typing an apostrophe (single quote or ') in front of it and it will show just Jan and not convert to a date. (Jerry posted that trick in another thread).


So here you could format both row 1 of the Jährliches Budget nach Monaten table and column Monat of the yada table as Text and type the month names in with a ' in front of each. That way the SUMIF formula should find an exact match. This, of course, becomes a problem if you have more than one Januar (i.e. more than one year in your budget). But for one year it should work.


SG

Oct 26, 2013 1:06 PM in response to Gerd Castan

Hi Gerd,


Right. I see the pop-up here too. What I'm thinking is that under the hood Numbers 3 may be converting the text from the Pop-up choice you make into a date, just as if you had typed it in. So a possible workaround is to not use dates at all just the month names as text. That should work if you have only one year.


SG

Numbers 3 has bugs in calculations.

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