Macworld Forums: Excel 2008 vs. Numbers '08 - Macworld Forums

Jump to content

  • (3 Pages)
  • +
  • 1
  • 2
  • 3
  • You cannot start a new topic
  • You cannot reply to this topic

Excel 2008 vs. Numbers '08

#1 User is offline   Macworld Icon

  • Story Poster
  • Icon
  • Group: MW Bot
  • Posts: 12,872
  • Joined: 30-November 07

Posted 15 April 2008 - 05:20 AM

Post your comments for Excel 2008 vs. Numbers '08 here
0

#2 User is offline   palane Icon

  • Member
  • PipPip
  • Group: Members
  • Posts: 446
  • Joined: 18-November 04

Posted 15 April 2008 - 05:47 AM

It would be nice to see NeoOffice mentioned in the context of the comparative review. Microsoft's decision to drop macros orphans anyone who invested time in developing macros. It's a shame as I put together a nice set of spreadsheets for my bowling league (I'm league secretary). A few macros cut an hour long and error prone exercise into something done in less than half an hour. I'd rather head over to NeoOffice and debug my macros than give them up altogether.
BB
0

#3 User is offline   motley Icon

  • Member
  • PipPip
  • Group: Members
  • Posts: 65
  • Joined: 19-April 05

Posted 15 April 2008 - 06:06 AM

The biggest short coming for me is the way Numbers handles coping. When I copy a table in Numbers and try to paste it into Dreamweaver, all I get is plain text. I have to copy the table in Numbers paste it in Excel then recopy the table and paste it back into Dreamweaver. When I do this I get all my cells pasted in as a table. But of course I then have to strip out all the MS junk that was pasted as well. Wish there was a better way to import my info from Numbers to Dreamweaver!!!
0

#4 User is offline   Hurley42 Icon

  • Member
  • PipPip
  • Group: Members
  • Posts: 332
  • Joined: 08-August 07

Posted 15 April 2008 - 06:29 AM

Numbers has a superb interface that is easy to use and makes spreadsheets fun to use. However I have had to stick with Excel simply for the lack of trend lines and formula placement on scatter plots. I am not a macro user, so I have no complaints there but I can understand others' frustrations. I look forward to the day that I can use Numbers and still work with others who use Excel (unfortunately the majority of spreadsheet users). If Apple keeps investing in Numbers development, then it will quickly become a tool worthy of academic and business environments, among others. Until then, Numbers is merely a tool I use once in a while to see if it can do some particular task Excel does easily.
0

#5 User is offline   Ronnie81 Icon

  • Newbie
  • Pip
  • Group: Members
  • Posts: 1
  • Joined: 15-April 08

Posted 15 April 2008 - 06:42 AM

Both Numbers and Excel 2008 has one huge drawback: The inability to add custom error bars to graphs. This makes both programs completely useless for scientific purposes. Since numbers is a new program I can understand that it does not yet have all the functionality as other programs. That Excel 2008 does not have it is unforgivable.. Microsoft omitted to include a feature that is included in Excel 2004, making Excel 2008 a utterly useless program for scientists.
0

#6 User is offline   joshtogo Icon

  • Newbie
  • Pip
  • Group: Members
  • Posts: 1
  • Joined: 15-April 08

Posted 15 April 2008 - 06:43 AM

The article neglects probably the most glaring omission in Numbers: the ability to freeze cells.

This lack means that any data entry of more than a few rows or columns requires constant scrolling and squinting to ensure correct entry. This renders the program almost unusable. It is particularly odd given the program's effective incorporation of headers and label columns. I thought that Apple would have set these fields to stay visible by default but they haven't even made this possible.

Until Apple enables a feature similar to Excel's freeze panes, Numbers will never be a viable alternative for anyone who has more information to enter than their kid's soccer roster, knitting circle's member list or pot luck supper schedule--and even these may be a stretch.
0

#7 User is offline   motley Icon

  • Member
  • PipPip
  • Group: Members
  • Posts: 65
  • Joined: 19-April 05

Posted 15 April 2008 - 07:05 AM

That would be a great feature as well!!!!
0

#8 User is offline   aangel Icon

  • Newbie
  • Pip
  • Group: Members
  • Posts: 7
  • Joined: 27-June 06

Posted 15 April 2008 - 07:51 AM

100% agree with joshtogo. I gave up on Numbers the moment it became clear there was no way to freeze cells. That user interface deficiency was a deal-killer for me.
I have no doubt the next version will be better but if it still is missing the ability to freeze cell, I will continue to use and recommend Excel.
0

#9 User is offline   dankothehun Icon

  • Member
  • PipPip
  • Group: Members
  • Posts: 24
  • Joined: 07-September 07

Posted 15 April 2008 - 08:52 AM

One spreadsheet alternative, albeit an expensive one, that was not mentioned is Quantrix. Iit blows Excel out of the water if you need any sort of multi-dimensional anaylsis. If you just need to make a list, Quantrix is too much, but for many business and scientific purposes, Quantrix has no equal.
0

#10 User is offline   dreyfus Icon

  • Member
  • PipPip
  • Group: Members
  • Posts: 579
  • Joined: 05-January 06

Posted 15 April 2008 - 08:54 AM

As somebody whose spreadsheet needs are pretty basic, I really appreciate Numbers as a great and relatively bug-free version 1 software with a great interface and a great print layout feature that beats Excel handily in this regard. Still, even for my basic needs (no pivoting tables or advanced charts required) two things keep me from abandoning NeoOffice or Excel yet: 1) lack of cell freezing and 2) no way to rotate text in cells (it is nice to be able to place checkboxes in a column, but not much use if the heading cannot be rotated and consumes significant width.
If version 2 (or an intermediate update) corrects this, I am happy. Even more if a future version will make it possible to use Numbers tables (and maybe Filemaker DBs) as a data source for mail merge in Pages.
0

#11 User is offline   DLC48 Icon

  • Member
  • PipPip
  • Group: Members
  • Posts: 17
  • Joined: 18-November 07

Posted 15 April 2008 - 09:04 AM

I think the BIG thing the author missed is that this is version ?? of Excel ... I dunno version 10 ? ... i.e. it's been out there for > a decade ! If not as Excel, as MS Works. So the fact that Numbers is even in the same ballpark as the "older, tried and evolved" Excel is quite remarkable. i.e. Excel v10.0, 3.5 mice... Numbers v1.0, 3 mice... = great start !! I admit it's not quite there yet.. esp. in scientific calculating (me). But I bet Numbers v2.0 is better than Excel. And Apple does listen to your cries... so cell freezing will most likely be added, as well as more formulas, features, and templates.

David
0

#12 User is offline   DisabledTrucker Icon

  • Member
  • PipPip
  • Group: Members
  • Posts: 321
  • Joined: 01-August 07

Posted 15 April 2008 - 09:06 AM

From the prospective of someone who doesn't use a spreadsheet at all, I found that although Numbers was missing a few functions it wasn't all that hard at all to put together a basic spreadsheet, especially when using a preformed one. I happened to like how it also did the graphs and everything for me automatically, even if I didn't need them. For the cost of it, it more than compares to and holds it's own against Microsoft's version vastly more expensive version.
0

#13 User is offline   palane Icon

  • Member
  • PipPip
  • Group: Members
  • Posts: 446
  • Joined: 18-November 04

Posted 15 April 2008 - 09:24 AM

Multiplan was actually the predecessor to Excel. It was succeeded by Excel in 1985, so Excel has been out in the wild for >20 years.
With regards to scientific graphing, I chuckle internally whenever I see an obvious Excel plot. Excel's great for playing with numbers, but a dedicated graphing program is a must. Kaleidagraph is my favorite, though there are alternatives.
It would be nice if one could replace the chart module of Excel with another program, as MathType will do for equations in Word. Then again, such an approach would probably require macros, so we're SOL.
BB
0

#14 User is offline   griffman Icon

  • Advanced Member
  • Icon
  • Group: Moderators
  • Posts: 8,605
  • Joined: 09-January 01

Posted 15 April 2008 - 09:25 AM

David:

The flip side of your argument is just as persuasive: Excel has been on the market for nearly 20 years. The Numbers team certainly had the ability to purchase Excel, look at its features, and decide which to implement. The fact that they left out things like freezing cells, simple data entry validation, pivot tables, etc., clearly speaks that they are targeting Numbers at a different sort of spreadsheet user.

Each program's score is independent of others -- while we may discuss how one program compares to another, its score is based on how well it does what it purports to do.

-rob.

  • (3 Pages)
  • +
  • 1
  • 2
  • 3
  • You cannot start a new topic
  • You cannot reply to this topic

2 User(s) are reading this topic
0 members, 2 guests, 0 anonymous users