madison

The Apple Core

Jason D. O'Grady & David Morgenstern

Office:mac 2004 on life support

By | November 29, 2007, 6:02am PST

Summary: Most Mac heads use Microsoft Office for word processing, spreadsheets and maybe even email, but do you really use it? I consider myself an Office power user (8+ hours per day) and increasingly find that Microsoft Office:mac 2004 is bordering on unusable in a couple of key areas. It’s to the point now, where I’ve be [...]

Office for Mac 2004 on life supportMost Mac heads use Microsoft Office for word processing, spreadsheets and maybe even email, but do you really use it?

I consider myself an Office power user (8+ hours per day) and increasingly find that Microsoft Office:mac 2004 is bordering on unusable in a couple of key areas. It’s to the point now, where I’ve be forced to switch to iWork ‘08 to get even basic workflow functionality.

Take for the example the ability to embed an Excel spreadsheet in a Word document. Simple enough, right? Not on a Mac.

What should be a simple, basic function of an integrated office suite is an exercise in futility. If you create a proposal, for example, in Word and embed a table of prices (from Excel) you cannot properly select the range of cells to embed. Sometimes it gets the cells you need, other times it lops off random rows or columns. Other times large areas of the spreadsheet are completely blank–even when printing. I found this out the hard way when Office didn’t include the last few rows of my embedded spreadsheet–which happened to be critical notes.

Once an Excel spreadsheet is embedded in a Word document try adjusting its size or position–good luck. A former colleague was forced to open her files Mac Office documents on a PC just so that she could resize a spreadsheet embedded in Word.

Ever try working with Word’s headers and footers? Clicking out to de-select the header or footer jumps you back to the first page of the document. Why?

The Find functionality in both Word and Excel is horrible. You have to click the button or hit the return key to Find Next (there’s no command-G like most Mac apps) and if you leave the Find dialog open, it ties up the application so that other applications can’t communicate with it.

Microsoft-Excel-Busy

Even the basic “Save As…” feature doesn’t have a keyboard shortcut in Office:mac 2004. I use this feature about 50 times per day necessitating grabbing the mouse and clicking on the file menu. While I’m at it: Office Mac 2008 desperately needs keyboard shortcut preferences with full customization for every function of the application. Why do I need to buy a piece of shareware to do this?

One thing that Mac Office 2008 needs to learn from iWork ‘08 is the simple but incredibly handy “Paste and Match Style” feature. When pasting text into any of Apple’s iApps (Pages, Numbers, iWeb) holding down the control key gives you the option to paste the copied text in the style of the existing text, saving you a trip to the font panel. There’s even a keyboard command. This is a huge time saver for me.

Microsoft Mac Office 2008

The new Mac Office 2008 looks promising, but with only six weeks to go before its announcement at Macworld Expo SF in January I’m concerned. The Mac Business Unit (BU) hasn’t offered a public (or private) beta version of their flagship Mac software so no one knows what it fixes.

If some of these core features aren’t already baked into the new software, it’s not happening by Expo. I hope that some basic functionality is added to Mac Office 2008 or I’m headed to the hills of iWork and never looking back.

What bugs you about Office:mac 2004?

Kick off your day with ZDNet's daily e-mail newsletter. It's the freshest tech news and opinion, served hot. Get it.

Topics

Jason O'Grady is a journalist and author specializing in mobile technology. He has published six books on Apple and mobile gadgets and his PowerPage blog has been publishing for over 15 years.

Disclosure

Jason D. O'Grady

Jason D. O'Grady is the creator and editor of O'Grady's PowerPage, which has been publishing mobile technology news since 1995. He maintains an advertising relationship with the following legacy advertisers on the PowerPage:

  • Amazon Associates
  • Google Adsense
  • Tekserve
  • Advertising on the PowerPage is brokered by a third-party agency (BackBeat Media) and he recuses himself from these negotiations.

Biography

Jason D. O'Grady

Jason D. O'Grady developed an affinity for Apple computers after using the original Lisa, and this affinity turned into a bona-fide obsession when he got the original 128 KB Macintosh in 1984.

He started writing one of the first Web sites about Apple (O'Grady's PowerPage) in 1995 and is considered to be one of the fathers of blogging. He has been a frequent speaker at the Macworld Expo conference and a member of the conference faculty. He also co-founded the first dedicated PowerBook User Group (PPUG) in the United States.

After winning a major legal battle with Apple in 2006, he set the precedent that independent journalists are entitled to the same protections under the First Amendment as members of the mainstream media.

O'Grady is the author of The Nexus One Pocket Guide, The Droid Pocket Guide, The Google Phone Pocket Guide, and The Garmin nuvi Pocket Guide (Peachpit Press), the author of Corporations That Changed the World: Apple Inc. (Greenwood Press), and a contributor to The Mac Bible (Peachpit Press). In addition, he has contributed to numerous Mac publications over the years, including MacWEEK, Macworld, and MacPower (Japan).

When he's not writing about Apple for ZDNet at The Apple Core, he enjoys spending time with his family in New Jersey.

Talkback Most Recent of 56 Talkback(s)

  • Wow, that's crazy.
    I have never used Office for Macs. I was stunned that this functionality doesn't exist in it.

    Every single item you listed is present in the Windows versions of Office, at least in 2007, most of them in earlier versions as well (yes, including "Paste and Match Style"..it's just worded differently).

    The one that made me really start wondering is the "Save As". Are you telling me that you really can't Ctrl+F+A and save as? That's insane.

    The only feature you complained about that I don't understand is the inability to use cmmd+g for find next. Unless I'm just reading it wrong, isn't hitting the return button easier than hitting multiple keys...and than remembering the shortcut? Maybe that's just me. But it seems that hitting enter is more intuitive than a keyboard shortcut. But perhaps I'm the odd one here....

    Is that the only issue you have with the find function, because I've never managed to stump the the feature, personally, and I'm also a "power user" (based on your definition of 8+ daily hours of use). I use it all the time in documents that you aren't supposed to use pronouns in, or when searching for specific transaction amounts in excel I don't really think that a counter-intuitive (from your perspective) is call to call something "horrible" but I wonder if it doesn't work as well in your version.

    It is amazing to me that the program has lost so much in translation.
    ZDNet Gravatar
    laura.b
    29th Nov 2007
  • Edit
    It's not Ctrl+F+A, it's Alt+F+A. Ctrl+F opens Find. My bad.

    So, if you hit Cmmd+F+A...well, fill in the blank. happy

    I typo'd and didn't notice until I went to "save as" a document I'm working on. LOL.
    ZDNet Gravatar
    laura.b
    29th Nov 2007
  • Answers
    Office mac has no keyboard shortcut of Save As.

    On of the reasons that people have used macs is that all apps, from all suppliers, use the same shortcuts for common functions. They are shown on the Menu commands when you open a menu. Save As is command-shift-S. It you hit Command F-A you get the Find/Replace window.

    Office Mac is very short on keyboard shortcuts. It has the basics like New, Open, Save, Undo.

    The Find (command F) is fine. It brings up the Find/Replace window with Find next as teh active button so hitting Return or Enter takes you to the next one. That is actually how most apps work. just finished with iot in Indesign
    ZDNet Gravatar
    j.m.galvin
    29th Nov 2007
  • Wow
    Thanks, I learned something today - and that is definately a negative for that particular version of Office.

    Sucks.

    I hope they fix it in the next one. Save As is pretty basic and heavily used...there should be a shortcut.

    One thing I've always wanted is to have the same keyboard shortcuts from app to app, but then different companies do things differently. Prime example is the Save As. In MS Office, it's Alt+F+A. In Corel WordPerfect (which I use at work everyday) It's Alt+F+S, or F3. That's not the only example, though.

    Perhaps someday, all the companies will get together and determine standard keyboard shortcuts that can be used by all programs. That would definately improve the learning curve when switching apps or platforms.

    Or maybe that's a pipe dream.

    In any case, thanks for the info!

    Have a nice day! happy
    ZDNet Gravatar
    laura.b
    29th Nov 2007
  • Mac Guidelines
    Apple does make an effort to suggest standards for key combinations. Cmd-S,
    Save. Cmd-X, Cut. Cmd-V, Insert from clipboard, Cmd-P, Print, Cmd-H, Hide.

    The standard for Save As is Cmd-Shift-S.

    Individual applications can use or ignore these standards. One that always trips me
    up is Adobe's choice to maintain Cmd-H's pre-OS X meaning in Photoshop. They
    chose their user base over application compatibility, which is a value to new Mac
    customers. I understand why they made their choice, and I still go Cmd-H, undo
    what that did, and reach for the mouse to choose Hide from the Apple menu, and
    mutter something about Adobe once per PhotoShop use.

    It is an interesting wrinkle to the problem as to whether Windows-savvy users
    should just be able to substitute Cmd for Ctrl and be right at home in Mac/Office,
    or does Microsoft adapt the menus and shortcuts to be consistent with Apple
    guidelines.

    What does Ctrl-Shift-A mean in Word/Windows and could this explain the
    omission of a key combo shortcut for the functionality?
    ZDNet Gravatar
    DannyO_0x98
    29th Nov 2007
  • I am fairly sure
    That Ctrl+Shift+A is spelling and grammar check. It would make sense that this particular shortcut was not included in the Mac version because Macs have inherent spelling and grammar check, right?
    ZDNet Gravatar
    laura.b
    29th Nov 2007
  • I was wrong
    I should have thought harder before I replied.

    Ctrl+Shift+A capitalizes the text that you have selected, or, um....un-capitalizes it if it already was.

    Cool, huh? Very handy, if I do say so myself.

    Spell check is F7.

    My bad. happy
    ZDNet Gravatar
    laura.b
    29th Nov 2007
  • Wow
    Thanks, I learned something today - and that is definately a negative for that particular version of Office.

    Sucks.

    I hope they fix it in the next one. Save As is pretty basic and heavily used...there should be a shortcut.

    One thing I've always wanted is to have the same keyboard shortcuts from app to app, but then different companies do things differently. Prime example is the Save As. In MS Office, it's Alt+F+A. In Corel WordPerfect (which I use at work everyday) It's Alt+F+S (I think..I don't have it open), or F3 (I know for sure). That's not the only example, though.

    Perhaps someday, all the companies will get together and determine standard keyboard shortcuts that can be used by all programs. That would definately improve the learning curve when switching apps or platforms.

    Or maybe that's a pipe dream.

    In any case, thanks for the info!

    Have a nice day! happy
    ZDNet Gravatar
    laura.b
    29th Nov 2007
  • ZDNet Blogger

    It' a Mac thing...
    laura b.-

    Regarding your comment about Cmd-G, it's a Mac thing. Most Mac apps use Cmd-G for Find Next. True, hitting return isn't the worst thing in the world, it's just not very Mac-like.

    Find has other problems too. For example, if you forget that you have a cell selected and try to search, well, nooooooo sir! That text can't be found in that cell. Technically, this is user error, I know. But it's poorly implemented.

    It seems that OM'04 is bogged down by too many trips to the mouse and menus when it should be an efficiency tool.

    - Jason
    ZDNet Gravatar
    Jason D. O'Grady
    29th Nov 2007
  • I have to agree there
    For example, if you forget that you have a cell selected and try to search, well, nooooooo sir! That text can't be found in that cell. Technically, this is user error, I know. But it's poorly implemented.

    It's the same way in the Windows version.

    I understand it. The find can be refined to only search one cell, one row, one column, the entire worksheet, or the entire workbook. But that doesn't make it necessarily clear for the user. One may ask "Why would I need to search through one cell?" Well, formulas can be very long, and each cell can contain, I believe 225 characters, so sometimes it's handy.

    But just because I understand it doesn't mean I like it. That particular function messes me up all the time. But, like you said, technically it's a user error.
    ZDNet Gravatar
    laura.b
    29th Nov 2007
  • Office is poor on all platforms.
    We get some weirdness on the Mac.

    The Windows version of Word especially has different bugs. Resizing tables, trying to be a page layout app and failing miserably, trouble handling large docs, graphics wrap nightmares, etc.

    It's really just a matter of pick your poison.
    ZDNet Gravatar
    itguy08
    29th Nov 2007
  • Too high expectations
    Sure, Office has shortcomings, but let's keep things in perspective. For the intended user-base (Office / Business people) you don't need page layout down to the millimeter. If something shifts slightly, it's likely to make no difference. The same with "large documents". I've worked with 200-300 page files full of graphics without issues.

    IF you are expecting Word to really be a hybrid of the features in Word + Adobe Indesign then I think you answered your own question. Buy the right tools for the job and do the job right.
    ZDNet Gravatar
    croberts
    29th Nov 2007
  • ZDNet Blogger

    I disagree...
    I'm not looking for "page layout down to the millimeter" for that I use InDesign.

    I use Word for basic 2-page proposals every day and I can't embed a *simple* 10 row Spreadsheet that totals the prices (no macros or funny stuff). Try it some time (on a Mac)!

    You can't get basic than that.

    iWork's Pages app lets you edit the embedded SS inline (without having to open it in another app).

    Also, have you ever tried placing a scanned signature onto a Word doc. OMG! Fiasco!

    - Jason
    ZDNet Gravatar
    Jason D. O'Grady
    29th Nov 2007
  • See, that's a Mac thing
    That's what I was trying to say above. These features are not a problem in Word. I think that the "too high expectations" was aimed at the OP, not the article.

    I don't have to open Excel to embed a spreadsheet. I also don't have any problems resizing it once you do. As a matter of fact, I don't know if you can do this or not, but you can edit the spreadsheet from the word document in 2007.

    I don't have any problem inserting signatures (scanned or digital).

    All of the problems you talked about don't exist (at least not like you described them) in the Windows version.

    So, that's a Mac thing. I hope they fix it. What a pain it sounds like.

    But, if I were you I'd hold out some hope. The difference between 2003 and 2007 for Windows is quite remarkable. I would look forward to similarly major changes for the Mac versions (and crossing your fingers might not hurt. happy ).
    ZDNet Gravatar
    laura.b
    29th Nov 2007
  • Edit:
    These features are not a problem in Word.

    Should read:

    These features are not a problem in Windows

    I just can't type today.
    ZDNet Gravatar
    laura.b
    29th Nov 2007

Talkback - Tell Us What You Think

Formatting +
BB Codes - Note: HTML is not supported in forums
  • [b] Bold [/b]
  • [i] Italic [/i]
  • [u] Underline [/u]
  • [s] Strikethrough [/s]
  • [q] "Quote" [/q]
  • [ol][*] 1. Ordered List [/ol]
  • [ul][*] · Unordered List [/ul]
  • [pre] Preformat [/pre]
  • [quote] "Blockquote" [/quote]
Click Here

The best of ZDNet, delivered

ZDNet Newsletters

Get the best of ZDNet delivered straight to your inbox

Facebook Activity

White Papers, Webcasts, & Resources