1 9 10 11 12 13 Previous Next 288 Replies Latest reply: Jan 2, 2014 10:31 AM by Zzyzx239 Go to original post Branched to a new discussion.
  • 150. Re: What has been lost in Numbers 3.0 upgrade?
    SGIII Level 5 Level 5 (4,135 points)

    As far as I can tell you can find and find and replace via command-F:

     

    find-and-replace.png

     

    Nothing with formulas, though, that I can find.

     

    SG

  • 151. Re: What has been lost in Numbers 3.0 upgrade?
    chuck.coxhead Level 1 Level 1 (0 points)

    Please let Apple hear your voice on this

     

    https://www.apple.com/feedback/macosx.html

  • 152. Re: What has been lost in Numbers 3.0 upgrade?
    papalapapp Level 1 Level 1 (80 points)

    SGIII wrote:

     

    As far as I can tell you can find and find and replace via command-F:

     

    find-and-replace.png

     

    Nothing with formulas, though, that I can find.

     

    SG

     

    Unfortunately that's all I could find, too.

     

    I have a file that originated in a different language and now I need to change dozends of formulas (translate TRUE and FALSE and also change 2013 to 2014).

  • 153. Re: What has been lost in Numbers 3.0 upgrade?
    josekimber Level 1 Level 1 (0 points)

    Jerry

     

    Another item for your list.  It used to be possible (in Numbers 09, the only one I had) to select a range of cells and then select "SUM" from the list in the functions button.  That feature has disapeared - now if you click "SUM" it adds the whole column.  If you just want a total for a range, you have to insert a formula (=SUM) and then select your cells or type them in, much slower.

     

    I've reverted to Numbers 09, it does pretty much what I need.  Pity, I would have liked to be able to open the same sheets on my iPad, but the price is too high in terms of lost features, and I am usually using my iMac or Macbook.  I only do simple spreadsheets, no fancy stuff, so if I can't cope with Numbers 3 I don't see many people liking it either.

     

    Regards

    Jose

  • 154. Re: What has been lost in Numbers 3.0 upgrade?
    papalapapp Level 1 Level 1 (80 points)

    Jose, that feature has moved and works a little different now. Took me a while to find out.

     

    Select the cells you want to som up. Then drag SUM from the bottom of the window to where you want it to be placed.

     

    You can als add other functions to that bottom bar like variation etc..

  • 155. Re: What has been lost in Numbers 3.0 upgrade?
    Bozos Level 1 Level 1 (0 points)

          TOTALLY UNACCEPTABLE !!!

     

          WHAT WOULD STEVE JOBS SAY ???

  • 156. Re: What has been lost in Numbers 3.0 upgrade?
    Carrera Turbo Level 1 Level 1 (0 points)

    Hi Badunit,

     

    You solved my question where I looked for the answer almost 2 evenings. With Numbers 3.0 I shifted now from Excel to Numbers and discovering the wonderful world of Numbers.
    Although a lot of stuff is recognizable from Excel, some interesting stuff (for me most of the time formulas) isn't easy to reproduce in Numbers.

     

    I had a lot of problems to write conditions with dates included, finally a archived discussion with your response

    "The condition should be written as ">"&A2", has given me some new light on written formulas in Numbers 3.0.  Thanks-a-lot for your support !

     

    Last but not least a other question to you and other Numbers 3.0 Community fellows: If there already a Numbers 3.0 Userguide or other documents where I can find more information about writing formulas in Numbers 3.0? I found a user guide (See link to pdf) for the older version but this wasn't always a big help to me for the moment.

    Numbers '09 User Guide (pdf) - Support - Apple

     

    Spen911

     


  • 157. Re: What has been lost in Numbers 3.0 upgrade?
    sjlawton Level 1 Level 1 (0 points)

    "You're holding it wrong?"

  • 158. Re: What has been lost in Numbers 3.0 upgrade?
    Jerrold Green1 Level 7 Level 7 (28,995 points)

    Carrera,

     

    Apple hasn't published a new PDF user guide, but they do have a web-based guide for Numbers 3.0 with a link in the Help menu.

     

    Jerry

  • 159. Re: What has been lost in Numbers 3.0 upgrade?
    SGIII Level 5 Level 5 (4,135 points)

    where I can find more information about writing formulas in Numbers 3.0?

     

     

    Carrera

     

    And of course whenever you start inputing a formula in Numbers 3.0 the right pane automatically switches to a formula browser. Lots of explanations and examples in there.

     

    Screen Shot 2013-10-30 at 10.59.29 AM.png

     

    SG

  • 160. Re: What has been lost in Numbers 3.0 upgrade?
    josekimber Level 1 Level 1 (0 points)

    Thanks, papalapp.  I tried it and it works, and I have to admit, it's actually an improvement!  Pity that Apple did not tell us about it in the help files - or I could not find it anyway,

     

    Doesn't quite compensate for the missing autofill though.  You'd have thought that would be a feature appreciated by iPad users too.

     

    Regards

    Jose

  • 161. Re: What has been lost in Numbers 3.0 upgrade?
    t quinn Level 2 Level 2 (320 points)

    Jose,

    Auto fill lives. On the desktop, hover over the cell you want to use for fill and a yellow dot appears in the center of the selection box. Drag and enjoy. On iOS tap the selecton box and arrow past the cut/copy/paste to Delete/fill/comment. It will be clear from there.

    qiao

    Quinn

  • 162. Re: What has been lost in Numbers 3.0 upgrade?
    enteecee Level 2 Level 2 (315 points)

    Yes- the old version in in an iWork folder in your Applications Folder.

     

    Just junk the new one or it'll keep trying to topen your files.

  • 163. Re: What has been lost in Numbers 3.0 upgrade?
    alightman Level 1 Level 1 (0 points)

    Numbers 3 *****. They've dumbend down a usefull xcell alternative into an iPhone app. I thought this was an upgrade, not a downgrade. Thank god it didn't remove numbers 2xx or I would have been screwed.

  • 164. Re: What has been lost in Numbers 3.0 upgrade?
    Andrew No Thanks Level 1 Level 1 (5 points)

    Thanks to all for the great responses here. This has been incredibly useful, and has convinced me to put off upgrading (or it seems, downgrading) to iWork 3.0. This will save me a lot of frustration!

     

    I hope that Apple addresses the many, many problems highlighted by its loyal Numbers, Pages and Keynote users. The action Apple has taken in castrating iWork 3.0 and selling loyal users down the river, simply to gain speedy interoperability between Mac OSX and iOS versions is, frankly, abusive and shameful. Unfortunately, it seems with Apple's increasing size and success, come more frequent displays of arrogance and antisocial behaviour towards long-time users.

     

    Apple is not the company I once believed it was, and Mr Cook clearly does not have the grip on the reins of corporate culture that Mr Jobs had.

1 9 10 11 12 13 Previous Next