EditorsAbout the SiteComes vs. MicrosoftUsing This Web SiteSite ArchivesCredibility IndexOOXMLOpenDocumentPatentsNovellNews DigestSite NewsRSS

05.19.08

OOXML: Bugs as an International Standard

Posted in ISO, Microsoft, Office Suites, Open XML at 10:48 pm by Dr. Roy Schestowitz

Profit or loss in finance, life or death in healthcare

Over the past couple of years we have highlighted cases where OOXML gets its math wrong or witnessed incidents where its tight and correspondent (but not OOXML-compliant) Microsoft Excel got its math wrong too (e.g. Office 2007, other versions which received bad patches). This says a lot about quality assurance at Microsoft and also about sloppiness at ISO.

Examples that are worth bringing attention to again:

The only news is that Rob Weir has just added another problem to the pile. It’s a very detailed post and as we mentioned very briefly the other day, Microsoft et al continue to hide OOXML from the public, thus leaving little or no time for scrutiny while it is crucial (a further delay seems possible).

So Excel is off by 2% or so. Do we really care. It’s just money, right?

The problem is that the function in OOXML is defined incorrectly, from the financial perspective. The discount rate is the discount from the redemption value, not the discount from the purchase price. So the first term in the formula should be (redemption-par)/redemption, not (redemption-par)/par. If you make this change, then the calculated value matches the value Excel gives.

[...]

What would be normal practice would be to take the definitions, as given in the OOXML text, and to calculate the values according to the definition provided in the text, and then to compare the resulting values with what Excel returns. That would provide a useful double-check of the definitions in the text. But OOXML doesn’t do that. The example here are mere fluff and provide no additional assurance to the implementor.

The discrepancy here also indicates that no one has actually reviewed these formulas for accuracy. Errors like this are immediately evident, but only if you look. The fact that things like this have escaped the notice of Microsoft, Ecma TC45, their Project Editors, 80 NB reviews, the BRM experts, and the eagle eyes of ITTF, should make one have considerable concerns over the the sufficiency of the Fast Track review and approval process.

ISO standards for saleYet another bug as a standard? Does anyone even care? Does anyone care to actually implement this bug to ensure validation, which does not (and never will) ensure compatibility and inter-operability with Microsoft Office? Does Microsoft care? Hardly. As Tim Bray said quite recently, “what Microsoft really wanted was that ISO stamp of approval to use as a marketing tool. And just like your mother told you, when they get what they want and have their way with you, they’re probably not gonna call you in the morning.”

Bill Gates: “No! There are no significant bugs in our released software that any significant number of users want fixed.”

“FOCUS: Oh, my God. I always get mad at my computer if MS Word swallows the page numbers of a document which I printed a couple of times with page numbers. If I complain to anybody they say “Well, upgrade from version 5.11 to 6.0″.

Bill Gates: “No! If you really think there’s a bug you should report a bug. Maybe you’re not using it properly. Have you ever considered that?”

FOCUS: “Yeah, I did…”

FOCUS Magazine, 1995

Share this post: These icons link to social bookmarking sites where readers can share and discover new web pages.
  • Digg
  • del.icio.us
  • Reddit
  • co.mments
  • DZone
  • email
  • Google Bookmarks
  • LinkedIn
  • NewsVine
  • Print
  • Technorati
  • TwitThis
  • Facebook

If you liked this post, consider subscribing to the RSS feed or join us now at the IRC channels.

Pages that cross-reference this one

A Single Comment

  1. PeterKraus said,

    May 21, 2008 at 5:26 am

    Gravatar

    This is hilarious, honestly. Thanks to this, I have had a funny morning.

    Now, I only hope, that my payroll is NOT calculated using excel.

What Else is New


  1. MPEG-LA is Preparing New Patent Obstruction (Called DASH) Against Free Software, OIN Grows

    A new conspiracy against free multimedia software, set up by the MPEG cartel, is called DASH



  2. New Zealand's Media Gets History Wrong on Software Patents

    Setting the record straight on the fight against software patents in New Zealand



  3. Not Only Vista 10 Crashes a Lot, Any .NET Application Does Too

    Microsoft software is quickly becoming synonymous with crashes as any piece of software developed with Microsoft's tools, not just the underlying platform, crashes chronically



  4. The Government of Bulgaria Sells Out to Microsoft, Again

    Despite some promises and reassurances that Bulgaria will consider Free/libre software, the Bulgarian government hands out a lot more of taxpayers' money to the Mafia



  5. Corporate Media Finally Finds Out That Vista 10 Crashes a Lot

    Stability issues of Vista 10 are belatedly reported to be a major catastrophe, leaving it unusable for many early adopters



  6. Links 28/7/2015: Linux 4.2 RC4, New Logos and Bug 'Branding' for FUD

    Links for the day



  7. Patents Roundup: Technicolor, Alice, Voip-Pal, Fitbit, Marijuana Patents, and JDate

    A look at some of last week's patent news, with imperative responses that criticise corporate exploitation of patents for protectionism (excluding and/or driving away the competition using legal threats)



  8. Corporate Lobbyists Including Koch-Connected Front Groups Attack Real and Perceived Patent Reform in the United States

    Looking at some of the latest propaganda for and against a bill which is already too watered-down to actually fix the US patent system



  9. Patents in the Android World Further Complicate Freedom in This Linux-Powered Platform

    A survey of last week's news with special focus on Google and Android, which are trying to coexist and thrive in a world full of patent maximalists



  10. The 'Unitary' Patent Trojan Horse Rammed Down the Throat of Europe

    Under the guise of 'unification' or 'unity', existing patent systems are being abandoned and more power gets passed to corrupt EPO officials



  11. HEVC Cartel is Not News, Only the Names of Backers and the Costs Are New

    A few remarks on and a roundup of recent articles about HEVC, which we first wrote about in spring



  12. IRC Proceedings: July 12th, 2015 – July 25th, 2015

    Many IRC logs



  13. Links 26/7/2015: Purism Librem and Freedom, Akademy Updates

    Links for the day



  14. Vista 10 (Windows 10) Has NSA Back Doors and Front Doors

    Vista 10 to bring new ways for spies (and other crackers) to remotely access people's computers and remotely modify the binary files on them (via Windows Update, which for most people cannot be disabled)



  15. Vista 10 Not Ready, But Released Anyway

    Despite severe technical issues in the rushed-out-the-door Vista 10, Microsoft decides to stick with the deadline, only days after reporting billions of dollars in losses



  16. Links 25/7/2015: Plasma Mobile, Linux Mint 17.2 OEM

    Links for the day



  17. Links 24/7/2015: openSUSE Leap 42.1, Intel With Rackspace for OpenStack

    Links for the day



  18. Links 24/7/2015: GNOME 3.17.4, Mozilla Developer Network Turns 10

    Links for the day



  19. Microsoft Has Run Out of Attempts and Vista 10 Will Definitely Fail

    As Microsoft admits billions of dollars in losses just days before Vista 10 is pushed as a 'free' upgrade, there is no concrete sign that financial recovery is imminent, for the bigger cash cow (Office) suffers a similar fate



  20. GNU/Linux Circles Ought to Stop Promoting Visual Studio, Which is Neither Cross-Platform Nor Free Software

    Media carries on openwashing Visual Studio and perpetuating the illusion that it is not tied to Microsoft Windows



  21. Spinning Proprietary Software Dangers as Dangers of Free/Libre Software

    News sites mislead their readers, teaching them that the biggest dangers associated with proprietary software are in fact problems exclusive to Free/libre Open Source software



  22. Links 23/7/2015: New RHEL Release, Capital One Releases Code

    Links for the day



  23. Terminology of Patent Lawyers and Pro-Patents Media Serves to Mislead the Public

    An outline of stories where the language used to describe patents is grossly distorted so as to bias the reality and mislead the audience/readers



  24. Amid Billions in Losses, Microsoft Tries to Conquer the Competition (Which Already Wins)

    The 'Embrace, Extend, Extinguish' strategy goes a few steps further as Microsoft looks to dominate developers, devices and servers that are running Free/libre software



  25. Microsoft Losing Billions of Dollars is Not News

    Few remarks on Microsoft's latest admission that it is losing a lot of money



  26. Links 22/7/2015: Kodi 15.0, MKVToolnix 8.2.0

    Links for the day



  27. The Technology Sector in the US Has Gotten Fed Up With Apple's Patent Aggression Against Android/Linux

    Apple is desperately trying to stop Android from increasing its levels of dominance (in phones, tablets, watches, and so on), so Silicon Valley is lining up against Apple, antagonising its misuse/abuse of patents for anticompetitive purposes



  28. Patents Regime in Europe: Mixture of Greed, Competition Abuses, and Propaganda

    A roundup of the latest patent news from Europe, focusing on Italy, the UK, Germany, and Hungary



  29. Patent 'Reform' in US Congress Still Under Attack by Patent Lawyers and Corporate Lobbyists

    The latest instances of assault on changes to the US patent system, demonstrated through an elaborative survey of the media (two days' worth)



  30. Don't Ever Rely on Microsoft for Hardware, Hosting, Especially When it Comes to GNU/Linux

    Warning signs over Microsoft hosting, as well as reliance on Microsoft for maintenance of hardware


CoPilotCo

RSS 64x64RSS Feed: subscribe to the RSS feed for regular updates

Home iconSite Wiki: You can improve this site by helping the extension of the site's content

Home iconSite Home: Background about the site and some key features in the front page

Chat iconIRC Channel: Come and chat with us in real time

CoPilotCo

Recent Posts