You can make a difference in the Apple Support Community!

When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.

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

sjlawton Author

Level 1

13 points

What has been lost in Numbers 3.0 upgrade?

Has anyone got a list of features that has been lost in the new version of Numbers?

I am aware (and disappointed) that the useful Categories feature has gone (I have requested this feature back on relevant Apple page). I think I also saw that Print view had disappeared.

What else has gone? I make extensive use of filtering and sorting - if those features have been watered down then I think I may not bother updataing.

Thanks in advance,

Simon.

MacBook Pro (15-inch Mid 2010), OS X Mavericks (10.9)

Posted on Oct 23, 2013 7:36 AM

Top-ranking reply

Jerrold Green1

Level 7

30,229 points

Posted on Oct 23, 2013 7:43 AM

SJ,

Here's my list as of 10:30 EDT:

Function or feature or issue

Reorganize Panel gone

Categories View gone

References now don’t follow sorted rows as they did before. (Now like Excel)

Table Fills not supported

German user can’t use decimal point from numeric keypad.

Split Cells is gone

Sheet View seems to be the only view available during editing. Page view only available in the Print dialog.

Page Headers and Footers are gone

Edit Toolbar (add, delete, rearrange tool icons) is gone.

That's it from here at this time, but I think I have just scratched the surface. Would love to hear from others who are keeping a list.

Jerry

View in context

291 replies

aarild

Level 1

5 points

Nov 18, 2013 2:19 AM in response to racram033

I agree it is silly to take away such a vast number of features, it seems very clear that iOS sync is given priority above anything. But you should actually see your old Numbers version still living on your Mac. It has not been replaced, and you can actually have them both running simultaneously. But take care not to open your "old" documents with the new version if there are features you need to keep. Bottom line: You can use your old Numbers version for anything that does not go in your iCloud folder, whereas you need to use the new version to sync with iOS. Now you will at least be certain not to have any compatibiliy issues with the latter.

Badunit

Level 7

28,222 points

Nov 18, 2013 5:03 AM in response to aarild

Yes, both version can be run at the same time but it is not seamless and convenient. Opening a Numbers 2.3 document in Numbers 3.0 has the potential to ruin it. So I had this brainstorm: I set my computer up so all Numbers documents open with Numbers 2.3 by default. My thinking was that the worst that could happen is a Numbers 3.0 document will say it cannot be read. Numbers 3.0 documents would require a right click and "open with Numbers (3.0)". Only problem is that my computer decided it liked it the other way and changed it back itself. Everything is opening in Numbers 3.0 again. So I guess that idea might not work after all.

aarild

Level 1

5 points

Nov 18, 2013 5:11 AM in response to Badunit

For me this is working as a temporary solution, I distinguish between the two with Mavericks tags. A second option is to always open the files from within the right version, using cmd+O or to use the menu object Archive->Open recent.

sca

Level 1

0 points

Nov 18, 2013 6:25 AM in response to sjlawton

it is a joke we have to keep 2 versions of the same software to make it work...

for me it was a downgrade and now I know why it was free

Nov 21, 2013 5:19 PM in response to sjlawton

SJ,

The first update has been issued. I have marked the items that have been corrected with a strike-through font.

Function or feature or issue

Applescript support has been greatly reduced (To be improved by May 2014 - full restoration not mentioned)

Automatic Format does not always recognize YYYY-MM-DD as a date input.

Categories View gone

Cell border custom line weight is sometimes lost when using Filter Rows

Character Styles are limited to 7, no way to create more. (There is a plus-button but it is inactive)

Charted Dates don’t display properly when used as X-Axis values - hope this is just a bug

Chart Linking, Charts in Pages Updated from Tables in Numbers, is gone

Charts, when Copied to the Clipboard, are low resolution bit map images, not vector graphics as in previous version of Numbers.

Comments can’t be Printed

Comments can’t be repositioned

Comments can’t be resized

Comments only display as Tool Tips now, can’t be static displays

Conditional Format of Logic State (TRUE/FALSE) in 2.3 is converted to Numeric Value of 0 or 1 when document is opened by 3.0. Yet the only way to write such a conditional format in 3.0 requires a Text condition of TRUE/FALSE. Any attempt to edit the converted document’s conditional format results in a loss of the logic state conditional format that was imported.

Conditional Format with Dates doesn’t support all date formats (perhaps just a bug)

Contacts; Drag and Drop into Numbers from Contacts no longer supported

CSV, Pasting or Dragging. to a table or the canvas is gone file import seems to be limited to dragging a CSV file to the Numbers Dock Icon or using File > Open.

Custom Formats gone

Date Format Options represent only US English norms and do not change with Country Settings

Filter action no longer moves content below the table up or down to account fo the length of the table being filtered.

Filter, Show Rows that Match, no longer treats a null string as a Blank Cell

Find and Replace Results Pane is gone - was a great navigation tool

Find and Replace can no longer be used to modify formulas

Formula Bar is gone, replaced by a field at the bottom of the Numbers window in which the expression is displayed but can not be edited

Formulas and Functions user guide PDF, easily searchable, is gone, replaced by web help page

Formula List is Gone

Formula entry bug prevents direct entry of cell range in which the second column reference begins with the same letter as any function name.

Functions Tool has lost the ability to insert a row containing a statistics function, acting on a selected range, including multiple column ranges

Graphics Inspector no longer treats a Table as an Object that can be formatted by the Graphics Inspector tools. Or, looking at it from the Table perspective, there is no way to add Shadow effect to a Table’s outline

Hyperlink click no longer takes user directly to URL. Instead user must first click, then choose Edit or Open.

INDEX function no longer recognizes a Table Name as a Range

Insert > Date and Time is gone

Insert > Filename is gone

Keyboard Shortcut reminders have been removed from Drop-Down Row and Column menus

Media Browser no longer includes a Search field

Move and Mark for Move are gone from the Edit Menu

Numbers User Guide PDF is gone, replaced by web help page

Numbers 08 documents Can’t be opened in Numbers 3.0

Page Headers and Footers are gone (To be restored May 2014)

Page Margins can’t be adjusted

Print Preview view not available while editing (Zoom and Windowing to be improved in some way by May 2014 - Editing in Print Preview View not mentioned)

Pop-Up Menu Format no longer expands with a click of the Spacebar

QFX Financial File Exchange, bank and brokerage files, import is no longer supported

Reorganize Panel gone, no multi-level sort. (Multilevel Sort to be restored by May 2014)

Return key option to set the behavior while editing a cell is gone

Scatter Chart can no longer accept data dragged in from another table. Must reconfigure tables to aggregate data for charting.

Services are curtailed. Devon Wordservice services are absent in Numbers 3.0.

Share Menu is gone, and Export to PDF not longer has the option to make a PDF in Sheet View mode with no page breaks.

Show Autocompletion List in Table Columns is gone (To be restored May 2014)

Sort Selected Rows is gone (To be restored May 2014)

Sorting detector now stops cell references from following the sort movement. This loss a PLUS.

Split Cells is gone

Table Fills are not supported

Text Boxes can not be Copied to the Clipboard, therefore can not be converted to a PDF in Preview via the Command-N route

~~Toolbar Editor(add, delete, rearrange tool icons) is gone.~~ Numbers 3.0.1

Trendline Equation and R-Squared values are fixed in place now - formerly were movable.

Values sometimes replace expressions when V2 documents are opened in V3

~~Window size and Placement not Preserved on Save~~ Numbers 3.0.1

~~Zoom (default view magnification) not settable as a Preference.~~ Numbers 3.0.1

Jerry

Nov 23, 2013 10:11 AM in response to Jerrold Green1

Jerry, I think the issue with not saving the zoom leve is still there when the file lives in iCloud. When I change it to 100%, it opens at 125%.

Regarding window placement I haven't noticed any changes even when saving on Mac. Still opening on my 13" screen but not on the 23" secondary display (like numbers '09 does). So annoying. 😠

SGIII

Level 8

36,134 points

Nov 23, 2013 10:16 AM in response to papalapapp

Hi papalapapp,

Try File > Save before closing and see if the document saved in iCloud keeps its zoom level when you reopen. It does here.

Best,

Nov 23, 2013 11:09 AM in response to SGIII

Ok, on Mac-only it indeed saves the zoom. As I am also working with iPad, it resets the zoom every time I touch the document there. Sigh.

Btw: It's the same the other way around. Opening the file on Mac, resets the zoom level on iPad.

Nov 24, 2013 1:50 AM in response to sjlawton

Hi,

Has anyone noticed the problem with 'Enter' going to the next cell down, and there is no option to choose that it can go to a new line in the same cell? I think the option before was 'enter goes to new cell' which I had unchecked, but in new numbers, it defaults to enter going to next cell in column and no option to stop this.

I believe the keyboard shortcut to 'edit a cell' is Option-Return, and 'Complete a cell entry and select the cell' is Enter (http://help.apple.com/numbers/mac/3.0/#/tan6f3e4ba25). I want to switch these around. Any ideas? Bugged if I know why the chocie to do this in the previous Numbers was taken out ....

Has anyone found the same problem and has a solution to this?

Many many thanks!

Nov 24, 2013 1:52 AM in response to sjlawton

How did they lose so much functionality in the new Numbers? So many useful things gone!

Nov 24, 2013 3:23 AM in response to sjlawton

I now have started using Filter Table ... instead of Categorize to get almost the same result for me in a different way, but I still would prefer Categorize.

Nov 24, 2013 7:39 AM in response to Bondi Locals @ Bondi 88FM

Bondi,

Pages treats the Enter/Return key the way you like it. Pages may meet your needs better than Numbers.

Jerry

Nov 26, 2013 10:28 PM in response to Mississippimudd

Until they fix this debaucle, I've resorted to taking a quick picture, shift/Command/4 and referring to it until this is resolved.

I completely agree with you!

Nov 26, 2013 10:34 PM in response to SGIII

Best of both worlds?

No because if you make changes to an 09 document you'd better keep using that version because, from what I know, once you make changes to the 09 document, it will upgrade that doc permanently to the 10.9 version. THEN, if you want to work in the 10.9 doc you have to export it in the 09 choice. But then, you will have to keep track of your changes in BOTH the 10.8 and 10.9 versions, heaven knows why you'd want to do that say what?! Backed into a corner. I should have known better than to upgrade right away!

Nov 26, 2013 10:44 PM in response to sjlawton

I will add....

In search it doesn't show a complete list of all the cells it found like before. You have to scroll through the document and all the found highlighted cells or use the forward or backward arrows.

What has been lost in Numbers 3.0 upgrade?