theili
Level 1 (0 points)

Q: Pulldown Menu and sumif don't work correct in "Numbers 3.0"?!

When I enter the word "Februar" (German for February) in the pulldown-menu-setup, in order to set the second possible pulldown-value, it changes to "März" (March) right after I hit return. Produces the same bug with other months, i.e. April turn to Mai (May).

 

Step 1:

1.JPG

 

Step 2 - enter "Februar"

2.JPG

 

Step 3 - hit "return" changes "Februar" into "März"

3.JPG

 

That's bad enough, but what's realy bad: The result using "sumif" referring with the pulldown-fields calculate absolute wrong values!

MacBook Pro, OS X Mavericks (10.9)

Posted on Oct 29, 2013 4:41 AM

Close
theili

Q: Pulldown Menu and sumif don't work correct in "Numbers 3.0"?!

  • All replies
  • Helpful answers

  • by SGIII,Helpful

    SGIII SGIII Oct 29, 2013 7:58 AM in response to theili
    Level 6 (10,796 points)
    Mac OS X
    Oct 29, 2013 7:58 AM in response to theili

    Hi Theili,

     

    There are a number of threads about this problem.  It has something to do with Numbers 3.0 "smart" recognition of dates in languages other than English.  It's too smart, not with the SUMIF function.

     

    One workaround (assuming you don't want to switch your language to English) that apparently has yielded some success for some users is to go to cells where the month names appear and type a space after each the month names.

     

    SG