Microsoft OOXML spec 'dangerously flawed'

OOXML critic says the format fails the spreadsheet test

Microsoft's Office Open XML (OOXML) document format specification is fatally flawed where it comes to spreadsheets, with many functions filled with careless errors, according to a critic.

The criticism comes in the midst of a pitched battle between different document formats vying to be the industry's choice for an "open standard" -- one that, in theory at least, is unconstrained by any one vendor and could be used equally well in competing applications.

The issue is important for businesses and other organizations because it affects the ability to keep documents accessible over time and to choose amongst competing office software packages. Currently most organizations use Microsoft Office partly because they are tied to Microsoft's proprietary document formats.

Microsoft's entry into the "open standards" arena is OOXML, which has been approved by a body called Ecma and has been submitted to ISO. Its chief rival is Open Document Format (ODF), based on the native file format of StarOffice/, backed by Sun, IBM and others, and already implemented in many office programs -- with the critical exception of Microsoft Office.

OOXML has been criticized in the past as encumbered with Microsoft intellectual property and as too complex to be effectively implemented by anybody but Microsoft -- the specification is 6,000 pages long, with 324 pages devoted to spreadsheet formulas and functions alone.

Now Rob Weir, a systems architect for IBM and a member of various ODF technical committees -- has alleged that even if third parties did manage to implement OOXML, many spreadsheet formulae wouldn't work properly.

Weir documented seven specific problems in a blog post, and said there are others. The problems relate to ambiguities and mistakes in trigonometric and financial functions, a function relating to setting workdays, and others, including the AVEDIV, CONFIDENCE and CONVERT functions.

In each case there is something left undefined, or something as simple as a typo, that Weir said would make the function work improperly if implemented by a third party as written.

Weir said the errors might be a side-effect of a rush to standardize the format. "OOXML's spreadsheet formula is worse than missing. It has incorrect formulas that, if implemented according to this standard, will bring important health, safety and environmental concerns, aside from the obvious financial risks of a spreadsheet that calculates incorrect results. This standard is seriously messed up," he wrote.

ODF supporters have good reason to find fault with Microsoft's spreadsheet standard -- since ODF doesn't yet define spreadsheets.

Weir said ODF developers are taking right approach by using specialist groups to review various aspects of the upcoming ODF spreadsheet specification. "Rather than rush, we're doing careful, methodical work," he wrote.

Microsoft did not immediately respond to requests for comment.

Join the newsletter!


Sign up to gain exclusive access to email subscriptions, event invitations, competitions, giveaways, and much more.

Membership is free, and your security and privacy remain protected. View our privacy policy before signing up.

Error: Please check your email address.
Keep up with the latest tech news, reviews and previews by subscribing to the Good Gear Guide newsletter.

Matthew Broersma
Show Comments

Most Popular Reviews

Latest Articles


PCW Evaluation Team

Jack Jeffries


As the Maserati or BMW of laptops, it would fit perfectly in the hands of a professional needing firepower under the hood, sophistication and class on the surface, and gaming prowess (sports mode if you will) in between.

Taylor Carr


The MSI PS63 is an amazing laptop and I would definitely consider buying one in the future.

Christopher Low

Brother RJ-4230B

This small mobile printer is exactly what I need for invoicing and other jobs such as sending fellow tradesman details or step-by-step instructions that I can easily print off from my phone or the Web.

Aysha Strobbe

Microsoft Office 365/HP Spectre x360

Microsoft Office continues to make a student’s life that little bit easier by offering reliable, easy to use, time-saving functionality, while continuing to develop new features that further enhance what is already a formidable collection of applications

Michael Hargreaves

Microsoft Office 365/Dell XPS 15 2-in-1

I’d recommend a Dell XPS 15 2-in-1 and the new Windows 10 to anyone who needs to get serious work done (before you kick back on your couch with your favourite Netflix show.)

Maryellen Rose George

Brother PT-P750W

It’s useful for office tasks as well as pragmatic labelling of equipment and storage – just don’t get too excited and label everything in sight!

Featured Content

Product Launch Showcase

Don’t have an account? Sign up here

Don't have an account? Sign up now

Forgot password?