What has been lost in Numbers 3.0 upgrade?

Please let Apple hear your voice on this

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

SGIII wrote:

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

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).

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

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..

TOTALLY UNACCEPTABLE !!!

WHAT WOULD STEVE JOBS SAY ???

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

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

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.

SG

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

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

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.

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.

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.

The first time you choose Media from the fixed toolbar, it takes a considerable amount of time to load in Numbers 3; much longer than in the previous version. Also, the lack of ability to search wastes a lot of time finding the photo you want to insert.