Close
  • Latest News
  • Big Data and Analytics
  • Cloud
  • Networking
  • Cybersecurity
  • Applications
  • IT Management
  • Storage
  • Sponsored
  • Mobile
  • Small Business
  • Development
  • Database
  • Servers
  • Android
  • Apple
  • Innovation
  • Blogs
  • PC Hardware
  • Reviews
  • Search Engines
  • Virtualization
Read Down
Sign in
Close
Welcome!Log into your account
Forgot your password?
Read Down
Password recovery
Recover your password
Close
Search
Menu
Search
  • Latest News
  • Big Data and Analytics
  • Cloud
  • Networking
  • Cybersecurity
  • Applications
  • IT Management
  • Storage
  • Sponsored
  • Mobile
  • Small Business
  • Development
  • Database
  • Servers
  • Android
  • Apple
  • Innovation
  • Blogs
  • PC Hardware
  • Reviews
  • Search Engines
  • Virtualization
More
    Home Applications
    • Applications
    • IT Management
    • Servers

    Are Microsoft and OpenDocument Getting on the Same Page?

    By
    Jason Brooks
    -
    May 28, 2009
    Share
    Facebook
    Twitter
    Linkedin

      File format compatibility for common applications such as word processors and spreadsheets is worthwhile for everyone, whether you’re perfectly happy with Microsoft Office or you’re hankering for a freer or more Web-connected alternative.

      After all, the more people who are able to not only consume but use and participate in the creation of our documents and spreadsheets, the more valuable those documents can be to us.

      Fortunately, the state of file format compatibility across a range of different applications has come a long way in the past few years, as vendors have made progress toward addressing the two major pieces of the compatibility puzzle.

      First, while no two applications ever will match up completely in functionality, applications meant to interoperate need to provide a core of common features-if there’s no analog in Suite A to your personal favorite Suite B feature, then you can forget about using the feature in your documents or expecting it to survive any round-trip editing scenario.

      Second, there should be common ways to record the output of these core features, with standards clear enough-and broadly adopted enough-so that people can work together from the applications and platforms of their choice, with documents moving around with relatively little friction.

      On the features front, OpenOffice.org has steadily blurred the lines between itself and Microsoft Office by adding and enhancing core features. For instance, OpenOffice.org’s recent 3.1 release boosts PowerPoint presentation compatibility significantly just by sharpening the on-screen graphics rendering of Impress.

      On the format standardization side, Microsoft’s recent Office 2007 SP2 release represents a major step toward bridging file format compatibility gaps by adding support for OpenOffice.org’s default OpenDocument format. Microsoft’s maiden ODF support effort checked out well in the initial tests I put it through, but significant issues exist in Microsoft’s ODF implementation, such as in its handling of spreadsheet formulas.

      Microsoft based its ODF work on current, ISO-blessed Version 1.1 of the standard, which didn’t go far enough in specifying formula handling to ensure the formulas would work the same as they moved from one ODF-based spreadsheet application to another.

      Microsoft chose to deal with the lack of clarity around formulas in ODF 1.1 by stripping formulas out of ODF spreadsheets opened in Excel 2007 SP2. On the positive side, this tactic preserves whatever values inhabited the spreadsheet’s cells when they were last calculated, but that comes at the cost of being able to use the formulas-a major negative.

      ODF adherents are claiming that Microsoft’s choices must have been the result either of incompetence or of ill will, and Microsoft is firing back with sort of an Eddie Haskell response about sticking to the letter of the standard.

      It might have been helpful if Microsoft had targeted instead ODF 1.2, which is what OpenOffice.org uses by default (with 1.1 as an option) and which includes a great deal more detail concerning formulas. It’s understandable, however, that Microsoft would have preferred to target the current 1.1 standard over the as-yet-unratified Version 1.2.

      Alternatively, I would have expected Microsoft to deal with confusing bits of the ODF specification by referring to existing implementations. How did OpenOffice.org deal with formulas in ODF 1.1? If nothing else, I would have liked to see the Excel team provide users with a pop-up dialog advising that their ODF spreadsheet formulas had been stripped out.

      I intend to judge the success of ODF, and of Microsoft’s participation, by the code that comes out of it. ODF support in Office 2007 SP2 was a promising start, and I look forward to seeing what bug fixes Microsoft sends down its patching pipe and what Office 2010 will bring regarding ODF.

      Executive Editor Jason Brooks can be reached at [email protected]

      Jason Brooks
      As Editor in Chief of eWEEK Labs, Jason Brooks manages the Labs team and is responsible for eWEEK's print edition. Brooks joined eWEEK in 1999, and has covered wireless networking, office productivity suites, mobile devices, Windows, virtualization, and desktops and notebooks. Jason's coverage is currently focused on Linux and Unix operating systems, open-source software and licensing, cloud computing and Software as a Service. Follow Jason on Twitter at jasonbrooks, or reach him by email at [email protected]

      MOST POPULAR ARTICLES

      Android

      Samsung Galaxy XCover Pro: Durability for Tough...

      Chris Preimesberger - December 5, 2020 0
      Have you ever dropped your phone, winced and felt the pain as it hit the sidewalk? Either the screen splintered like a windshield being...
      Read more
      Cloud

      Why Data Security Will Face Even Harsher...

      Chris Preimesberger - December 1, 2020 0
      Who would know more about details of the hacking process than an actual former career hacker? And who wants to understand all they can...
      Read more
      Cybersecurity

      How Veritas Is Shining a Light Into...

      eWEEK EDITORS - September 25, 2020 0
      Protecting data has always been one of the most important tasks in all of IT, yet as more companies become data companies at the...
      Read more
      Big Data and Analytics

      How NVIDIA A100 Station Brings Data Center...

      Zeus Kerravala - November 18, 2020 0
      There’s little debate that graphics processor unit manufacturer NVIDIA is the de facto standard when it comes to providing silicon to power machine learning...
      Read more
      Apple

      Why iPhone 12 Pro Makes Sense for...

      Wayne Rash - November 26, 2020 0
      If you’ve been watching the Apple commercials for the past three weeks, you already know what the company thinks will happen if you buy...
      Read more

      eWeek has the latest technology news and analysis, buying guides, and product reviews for IT professionals and technology buyers. The site’s focus is on innovative solutions and covering in-depth technical content. eWeek stays on the cutting edge of technology news and IT trends through interviews and expert analysis. Gain insight from top innovators and thought leaders in the fields of IT, business, enterprise software, startups, and more.

      Facebook
      Linkedin
      RSS
      Twitter
      Youtube

      Advertisers

      Advertise with TechnologyAdvice on eWeek and our other IT-focused platforms.

      Advertise with Us

      Menu

      • About eWeek
      • Subscribe to our Newsletter
      • Latest News

      Our Brands

      • Privacy Policy
      • Terms
      • About
      • Contact
      • Advertise
      • Sitemap
      • California – Do Not Sell My Information

      Property of TechnologyAdvice.
      © 2021 TechnologyAdvice. All Rights Reserved

      Advertiser Disclosure: Some of the products that appear on this site are from companies from which TechnologyAdvice receives compensation. This compensation may impact how and where products appear on this site including, for example, the order in which they appear. TechnologyAdvice does not include all companies or all types of products available in the marketplace.

      ×