Office 2007 SP2 is released, can indeed save ODF by default

By Scott M. Fulton, III | Published April 28, 2009, 4:11 PM


Download Microsoft Office 2007 Service Pack 2 from Fileforum now.

Now all Office users will have the option to load and save OpenDocument files, with today's distribution of Service Pack 2 of Office 2007. In something of a surprise -- contrary to what many at Microsoft led us to believe -- upon installing SP2 on our test systems, we immediately located an option for saving files in ODF by default. That means you don't have to "Save As" and export to ODF if you don't ever want to use Microsoft's OOXML or Office 2003 "compatibility mode;" you can at least try to use Word, Excel, and PowerPoint as substitutes for OpenOffice.

Not that Microsoft won't give you a little heck for it along the way, in classic Microsoft fashion. For example, after changing our default format to ODF, we tried saving a simple Word file that had nothing more than a single sentence of placeholder text, nothing else. Immediately we saw the first security warning, "Document1 may contain features that are not compatible with this format. Do you want to continue to save in this format?" The check box at the bottom of the dialog suggested to us that we would see such a dialog each and every time, unless and until we checked "Don't show this message again." That's Microsoft's little way of saying, don't blame us if your documents don't turn out 100% the way you expect them to.

The little warning that Microsoft gives you when you try to save an Office 2007 file as ODF.

The next little surprise is that the default save format is not the same as the default load format. So after you've saved your Word document as an ODT, clicking on the Office button and selecting Open gives you the usual list of files saved in Microsoft formats. In the file selector box, under Files of type, you have to scroll to the middle to see OpenDocument Text (*.odt) -- the list is not in alphabetical order, so that entry falls below XML but above WordPerfect.

Here's how to set the default save format in SP2: Click on the Office button (the big round logo in the upper left corner) and from the bottom of the menu, select Word Options. In the dialog box, from the left pane, choose Save. Then from the list box marked Save files in this format, choose OpenDocument Text (*.odt) (in Word 2007, or its equivalent in Excel or PowerPoint). Then click on OK.

We expected to see OpenDocument given equal treatment along with PDF, the portable document standard created by Adobe and now treated as vendor-neutral. While you cannot "open" a PDF document in Word (that's to be expected, Word and Acrobat aren't exactly in the same category), you can use Save As to export an open document to a .PDF file. If you're an Adobe Acrobat Professional user, you've already had an easier option added to your Office menu by Acrobat itself: Save As -> Adobe PDF. However, for non-Acrobat users who may only have Adobe Reader, this extra step does save you the hassle of installing something like "PDF Writer" as a printer driver, and printing as a means of exporting.

Office Live services have been obviously boosted in priority with SP2. Up to now, using the Office Live add-in has resulted in adding an extra place to your Save As dialog box, enabling you to directly load and store your Office documents to your personal storage space in Microsoft's cloud. Now with SP2, Open from Office Live and Save to Office Live become prominent selections in the Office menu, and the controls for signing into your online workspace are embedded into the menu -- no shoving off to IE just for the sign-in screen.

UPDATE 5:42 pm EDT April 28, 2009 - Or maybe not. Upon further testing, we learned that the Office Live functionality does not come with SP2 right away. Rather, in our first tests earlier today, the functionality showed up on virtual systems where Office Live had been installed before, and then uninstalled. But on systems where Office Live had never been installed before, we noticed no such new functions. So evidently the SP2 package updates systems where Office Live has been registered before by way of the Office Live add-in -- which, by the way, Microsoft now also offers through Automatic Updates.

Service Pack 2 rolls up a truckload of security-related attachments and bug fixes since December 2007 -- the release date of SP1 -- and also fills an important gap in Word's and PowerPoint's functionality.

Users of Microsoft Update this afternoon noticed "The 2007 Microsoft Office Suite Service Pack 2," complete with the "The," as a high-priority or important update along with Internet Explorer 8, which is now being pushed as an operating system update for the first time.

Here's some advice for you: Download Office 2007 SP2 either from our Fileforum page or using Automatic Updates, and not from a link you find on Microsoft.com. The latter is what we did, and that choice prompted us to download the latest version of Microsoft Internet Download Manager, whose performance -- at least we hoped -- was not a foreboding of things to come. First, it crashed our Firefox browser, taking with it the active session (for that reason alone, you may want to just use IE to download SP2). But when the browser was restored, we were shown a page that merely asked us to execute the just-downloaded installer file before proceeding. Not a kind way to give us the message.

Anyway, we did that and restarted Firefox. Then we noticed that the Download Manager failed to properly register itself; had it been registered properly, it would have detected that it was supposed to handle the automatically triggered download. As it turned out, the Registry triggered Visual Studio 2008 instead, which doesn't make for a very good download platform. We exited out of that and patched the Registry manually. Then and only then were we able to make the download properly, except that for a reason we can't fathom, the Download Manager downloaded the file twice. Remind us to give Download Manager 5.17 a low Fileforum score when we get a minute.

We're continuing to dig into the new features of SP2, including the long-awaited addition of the module that adds the same new charting functionality introduced in Excel, to Word and PowerPoint. We're also looking forward to seeing whether a window updating bug that's peculiar to Nvidia drivers has been addressed. We're only moments into our examination of SP2, and we'll let you know more when we do.

Comments

View comments by with a score of at least

Microsoft software is so s***ty, and has caused me so many serious problems - so many times, that I don't even think it's worth paying for.

07 is just the same crap stupidly repacked for another upgrade cycle.

What? 280M for the service pack, AND the removal tool is a separate download.....

What was so wrong with it that it took 280 Meg of EXTRA data to fix it?

The WHOLE of Open Office (.org) is about 120meg.... and it's the ENTIRE software suit - and it's free, and it's way plenty good enough for pretty much everything.

There is NONE of this bulls*** "basic, home, academic, small business, corporate and enterprise" crippled and rip off versions either - the Perpetual Microsoft Bulls*** Trip.

Score: 0

|

Did someone force you to buy Office 2007?

Are you saying that other options just not are available for word processors and email clients?

Score: 0

|

I guess most of the users haven't noticed yet but in their wisdom MS have broken Outlooks ability to correctly connect to Exchange 2003 with this new SP. Once installed if you check your connections you will see that you have no sockets to the Directory elements of Exchange 2003. This means you cannot send an email to anyone new or utilise things like digital signitures etc. If you are unfortunate enough to have to reset up your Exchange account whilst in SP2 then you will not be able to. Well done MS you ballsed it up again!!!!
Oh by the way, the MS solution to this is to uninstall SP2 and hide it from updates, they dont see it as a fault. :/

Score: 1

|

Downloaded direct from Microsoft, using Firefox 3.5 B4 and no download manager. Download went ok. Install went really well.
Performance notably increased in Outlook. Great update and well worth downloading.

Score: 0

|

Important! After installation of the SP2, when I save to PDF the word documents with embedded Visio drawings that contain gradient color fills, the result is that the drawings in the PDF file are corrupted. The gradient fills are misplaced in a weird way.

Now I do not know what to do to fix it. Can anybody help me?

Score: 1

|

Having read the comments here, I closed Outlook before installing the SP2.
Outlook has not crashed on me yet after the install.

Score: 0

|

I think SP2 adds better i7 support, I noticed SP2 runs MUCH faster than SP1 did on my i7, especially on my huge 2GB archive file!

Score: 0

|

I heard it is pretty much a universal speedup, doesn't have to do with the processor you are using. Read some of the comments in fileforum as well.

Score: 0

|

MS borked this by not making a version of Office free ages ago. I hate dealing with ODF, ODT files and DOC, EXL, XML. I don't know what the hell to save in anymore so that people will be able to open the files! So I end up using RTF.

At Xmas, MS made Office available for like $89 (S&T version). Closest to free yet...but really..just make it free and be done with it. At least the Student and Teacher pack.

Score: -1

|

...and just how is a free Office going to give you any better insight into what format to save it?

Score: 0

|

Save as Doc and all the idiots in the land can deal with it, and anyone else can convert it to what they want.

Score: -2

|

Why save it in a patent encombered, proprietary, closed format which requires you to pay Microsoft for the pleasure of having access to your content? No thanks.

Score: 1

|

@fatty: clearly you've never had to deal with sending out a document to the pudgy-fingered contingent of society who find operating simple word processing applications beyond them. .doc is the only format where you're fairly guaranteed that the user can fill it out, save it, and send it back without stabbing all the keys in a fit of rage.
I'm not saying it's a good format, but one that it is necessary to use if you have to send stuff out to people who don't quite understand computers.

Score: 0

|

I've been saving in RTF for a while now. With some places even using Office2K and Office 97 still, it's the only thing that's guaranteed to be opened by everything.

Score: 1

|

OP: I agree. Many people recommend PDF so you get WYSIWYG, but that is not a good editable format, and it has become somewhat bas****ized by all the noncompliant pdf creation software out there.

I think .doc is a safe bet, since every WP in the past 5 years can read reliably, as well as many webapps like google doc.

Score: 0

|

"and not from a link you find on Microsoft.com. "

I had no download manager and I downloaded it from here. Then again I use Opera, so that may be the reason.

However, I have Outlook running at startup and for some reason SP2 has made it crash at every start now.

Score: 1

|

Same here. After installing Office 2007 SP2, Outlook keeps crashing when it tries to start. Now SP2 has disabled my Outlook completely. If anyone has found a solution, please let me know. Before then, I will see if I can uninstall SP2.

Score: 1

|

It should be rebuilding the OST files on first use, which may take some initial time, but thereafter, it will be faster.

Score: 0

|

outlook crash too. I open and try to get to my pst file with a crash. i have repaired and reloaded the pst several times. used my pst on a known good system and mail is fine. Has to be a conflict of interest between 2007 outlook and IE8.
**on a weird note** my unread mail link will work. i can read and reply to mail in only that area (favorites menu) if i click on the inbox or any of my folders other than unread mail.. it crashes.
ideas? is there a bug fix out for ie8 or 2007 sp2 yet? how do i determine which it is? i have rolled back to 2007 sp1; problem still exists.

Score: 1

|

I just gave SP2 a second try. Outlook still crashed every time it started. Out of the blue, I tried starting Outlook in safe-mode (by starting it while pressing the ctrl key) and, viola, it started fine. It proceeded to update all of my folders and it is working ok now.

Score: 0

|

Won't install for me.

Running Vista Ult with Office 07. Errors out at end with this: Windows Update error 80070643

Supposedly has to do with the Office Service Engine.

I followed M$ instructions to fix it and it doesn't fit it.

Score: 1

|

ODF compliance in Office 2007 SP2 is poor, see here:
http://www.robweir.com/b...on-odf-spreadsheet.html

Score: 1

|

PDC 2009: What have we learned this week?

There was the freebie that no one will forget, the heebie-jeebies courtesy of Scott Guthrie, and a teensy bit clearer picture of how this cloud thingie should work.

Live report: Will Google Chrome OS change Linux?

The mysteries of just what Chrome OS is, and how much of an operating system it truly is, may be resolved today.

PDC 2009: Microsoft cares about Web browser performance

The effort to give users of the world's dominant Web browser the impression of quality, is a personal one for the man who leads that battle.

Nokia re-affirms its commitment to Symbian, sort of

Maemo won't necessarily be replacing Symbian in the Nokia N-Series, but that's definitely a place where it will be found.

E-book readers will be in short supply this holiday season

E-readers are hot this year, and a lot of compelling new products have been released, but are there enough electrophoretic displays to go around?

Sony looks to finally open a single storefront for downloads

Sony has had many different download portals for movies, music, e-books, and games, and now it's looking to make a single shop for all of it.

Tuning out the tablet: Time to give the endless speculation a rest

Wide Angle Zoom: Wishing and hoping and thinking and praying....won't put an iTablet on the market.

Five improvements for IT managers in 2010

If businesses are to improve their efficiency for next year, they need to stop and reassess the basic tenets of their job.

AOL's spinoff from Time Warner to shed 2,500 jobs

As AOL moves toward become an independent company again, it will cut nearly a third of its workforce.

Gartner: SMS-based money transfer will be bigger than mobile browsing, search

Gartner issues its predictions for the 10 things our phones will be doing in 2012.

Don't forget to upgrade to Firefox 3.6 beta 3 today

Mozilla has released the latest beta its Firefox 3.6 browser software, just over one week after beta 2.