It seems that for the moment, conditional formatting (or an IF() function) are the only ways to do this in Numbers. If the value = 0 you can either conditionally format the text to 0% opacity, or use IF() to set the value to "" if it's 0.
_________________________ If it's brokenless, don't suffix it...
Loc: Alexandria, VA
I'd love to use iWork instead of Office -- namely Keynote instead of Powerpoint. Except that Keynote burned me very badly on a show one time and I'm still reluctant to rely on it again ... plus, the translation to/from Powerpoint has in the past not been bulletproof enough (in my line, we often have to deliver a final copy in Powerpoint to the client anyways, so its just easer to develop in Powerpoint in the first place rather than reinventing the wheel after the show is done=) ...
Anyways, until the translation to/from Powerpoint is seamless I probably have to stick with Powerpoint, alas =(
I'll probably give pages a try for proposals, though, just for grins ...
Loc: Riyadh, Saudi Arabia
iWork '08 was my main business tool at work and the family pack of iWork '06 at home.. I'm definitely upgrading to '09 and will buy the new iLife '09 as well, my daughter have been enjoying the old GarageBand v.1 on the family eMac and I'm sure she'll like the new version, especially with the lessons.
I'm probably the only Keynote user at work and when the time comes for the departments quarterly meeting, ALL other PowerPoint departments falter in the presence of the Apple logo :P
For now, I'm still on Office 2004. Works for me and does everything I need, so I can't see myself spending more money on other similar products right now if I don't need them. (Yes, iWork is Apple and Office is Microsoft, but Office came to me first.)
Although... I'll note that I got Office 2008 as well, and simply that product almost did push me to iWork... Office 2008 is pure, undiluted CRAP.
Yeah, the conversion of Keynote to PowerPoint is pretty bad when you use the coolest features of Keynote in your presentation (the animations). 9 times out of 10 it just doesn't work too well - at least in my experience. Too bad they don't have some kind of "reader" software for Windows that could just read/display the native Keynote file for presentation sake.
I love Pages' simplicity, much more so than MS Word. Numbers I don't have a need for, so can't comment on how good (or not) it is.
The iWork 09 upgrade is nice so far, no complaints. But nothing to write home about either.
_________________________ The Graphic Mac- Tips, reviews & more on all things OSX & graphic design.
Loc: Riyadh, Saudi Arabia
To me, Numbers was God-sent. At work, I do and track the departmental budget, and at home I tracked my diabetes and my son's dialysis.
My transition is from NeoOffice to iWork and only use NeoOffice for Arabic windoze documents.. I don't know what's stopping Apple from supporting UTF-8 and Right-to-Left support in iWork... I miss Claris Works..
Except that Keynote burned me very badly on a show one time and I'm still reluctant to rely on it again
Pretty much the same reason I am stuck in Word/Excel/Powerpoint instead of iWork. I carry a Mac, I know a Mac will be there, I know I have a Powerpoint on my thumb drive which I made on a Mac but when all the terror of a presentation comes to a boil I don't want to worry about having to run my talk off a PC and the thing looks like crap because a photo does not show.
As MacGizmo says, when the transfer back to Word/Excel/Powerpoint is seamless then I get to change. Either that or we just go about the world's conference centers and destroy all copies of Word/Powerpoint/Excel.
I'll buy a new copy of iWork but I'll wait until the world realizes they need a new copy too.
Xplain's use of MacNews, AppleCentral and AppleExpo are not affiliated with Apple, Inc. MacTech is a registered trademark of Xplain Corporation. AppleCentral, MacNews, Xplain, "The journal of Apple technology", Apple Expo, Explain It, MacDev, MacDev-1, THINK Reference, NetProfessional, MacTech Central, MacTech Domains, MacForge, and the MacTutorMan are trademarks or service marks of Xplain Corp. Sprocket is a registered trademark of eSprocket Corp. Other trademarks and copyrights appearing in this printing or software remain the property of their respective holders.
All contents are Copyright 1984-2010 by Xplain Corporation. All rights reserved. Theme designed by Icreon.