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

Cool Tech

Toys for Boys

Family Friendly

Stocking Stuffer

SmartLens - Clip on Phone Camera Lens Set of 3

Learn more >

Christmas Gift Guide

Click for more ›

Brand Post

Most Popular Reviews

Latest Articles


PCW Evaluation Team

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!

Cathy Giles

Brother MFC-L8900CDW

The Brother MFC-L8900CDW is an absolute stand out. I struggle to fault it.

Luke Hill


I need power and lots of it. As a Front End Web developer anything less just won’t cut it which is why the MSI GT75 is an outstanding laptop for me. It’s a sleek and futuristic looking, high quality, beast that has a touch of sci-fi flare about it.

Emily Tyson

MSI GE63 Raider

If you’re looking to invest in your next work horse laptop for work or home use, you can’t go wrong with the MSI GE63.

Featured Content

Product Launch Showcase

Don’t have an account? Sign up here

Don't have an account? Sign up now

Forgot password?