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


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


    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. Team Battistelli and Team UPC Are Both Very Deep in Denial

    The perpetrators of a terrible patent system that permits patents on abstract ideas (which sometimes aren't novel, either) and litigation as a priority refuse to let go of their dream -- a distant, runaway fantasy which may soon cost over a thousand examiners their careers

  2. Guest Post: Battistelli's Former “Padrone” Facing Corruption Charges in France

    Battistelli's former "padrone" made the headlines this week when he was taken into police custody in France and charged with corruption and other breaches of law

  3. Links 23/3/2018: Fedora 28 Beta Delayed, Mintbox Mini 2 is Out

    Links for the day

  4. The Enemies of the Patent System Are Patent Maximalists, Not Those Pursuing Saner Patent Policy

    Taking stock of some recent news and remarking (yet again) on the danger the patent system faces if it allows patent lawyers rather than inventors to steer/influence policy (as seen in Europe with the failed UPC bid)

  5. The European Patent Office’s (EPO) Declining Patent Quality 'Tackled' by Making Appeals/Oppositions Harder and More Expensive

    The so-called 'System Battistelli' is proving to be a disaster which makes both examiners and patents obsolete; Making applications cheaper while making appeals/oppositions harder and more expensive is a recipe for disaster, assuring nothing but more litigation and more workloads for courts, where fees rise to extraordinary levels (in effect externalising the costs/toll of EPO to the public, primarily for gains of patent law firms)

  6. Ericsson, Acting Directly Rather Than Via the Patent Trolls It Habitually Uses, in a Patent War Against Linux/Android

    LG is the latest company to be sued by Ericsson, which doesn't just harass the competition (which actually sells something) through patent trolls but also directly, having won a case in the notorious Eastern District of Texas (EDTX/TXED)

  7. The Federation of International Civil Servants' Association: Frenchman “Campinos is Known for Having Close Ties to Mr. Battistelli Who Strongly Supported His Candidacy.”

    Readers find little or no room for optimism as Battistelli's final day at the Office approaches; FICSA is not optimistic either and the general consensus is that Battistelli's so-called 'reforms' will soon yield layoffs

  8. Links 22/3/2018: Mesa 17.3.7, Mesa 18.0.0 RC5, RawTherapee 5.4, Krita 4

    Links for the day

  9. Japan is Becoming Firmer on Patents, Whereas China Goes in the Opposite Direction

    Japan has become less tolerant of patent aggressors and more conscious/concerned about patent quality, which is why the patent microcosm would rather hail China as a role model (even when China's overall share of patents in Europe, for example, is about the same as tiny South Korea and a lot smaller than Japan's)

  10. Aggressive New Activities of Microsoft-Connected Patent Trolls: Finjan, Intellectual Ventures, and Dominion Harbor

    The extensive group of Microsoft-connected patent trolls is still very much active; Microsoft funds them, arms them, and gives them instructions while offering people 'protection' from them (if and only if they choose Azure)

  11. Battistelli's Ongoing Attacks on the Boards Are Helping Unitary Patent (UPC), Which in Turn Helps French Patent Trolls

    Battistelli will likely be remembered not only as the man who attacked justice (and judges) but also rendered staff redundant, issued a lot of highly controversial patents, and by doing so helped the insurgence of patent trolls in Europe

  12. Links 21/3/2018: Cutelyst 2, More on webOS

    Links for the day

  13. SUEPO: “Today May Be Your Last Chance to Demonstrate Against the Seriously Flawed Reforms That Mr Battistelli Has Imposed” on EPO Staff

    Benoît Battistelli will likely remain involved in EPO affairs for a long time to come (even through a fellow Frenchman, Campinos, whom he swaps two chairs with at the Office and CEIPI), but today is the last opportunity for EPO staff to march in protest against the Battistelli regime, which for the first time ever will result in major staff cuts and growing irrelevance for the Office

  14. Links 20/3/2018: GStreamer 1.14.0, Freespire 3.0, Endless OS 3.3.13

    Links for the day

  15. BIO, MDMA and PhRMA Are Pushing the PTAB-Hostile STRONGER Patents Act While IAM and Patently-O Continue to Bash PTAB

    The patent microcosm, which compares the Board to the above (crude analogy from Judge Rader and other patent extremists), is still trying to kill inter partes reviews (IPRs), in effect overlooking its own hypocrisy on the matter (they don’t want patent justice, they just want to metaphorically ‘shoot down’ the judges)

  16. 35 U.S.C. § 101 is Still Effectively Tackling Software Patents in the US, But Patent Law Firms Lie/Distort to 'Sell' These Anyway

    The assertion that software patents are still worth pursuing in 2018 is based on carefully-constructed spin which mis-frames several court decisions and underplays/downplays/ignores pretty much everything that does not suit the narrative

  17. Battistelli's EPO Became Extremely Reliant on China for Distraction and on Endless Supply of Applications (Supply Which Doesn't Exist)

    Discussion about the EPO granting machine (or patent-printing machine) and figures the way EPO management would rather the public won't ever see them; the concept that China means redemption for this patent system is as laughable as always

  18. The US International Trade Commission (USITC) Against Comcast, Courtesy of the Intellectual Ventures-Connected Rovi

    The USITC/ITC, which mostly serves to impose embargoes (sometimes in shocking defiance of PTAB decisions), is being invoked by a firm connected to the world’s largest patent troll, Intellectual Ventures

  19. Tinder/Match Group Uses Software Patents to Sue a Rival, Obviously Choosing to Sue in Texas

    Software patents are being used for leverage, but only those which were likely granted before Alice and only in courts at districts somewhere around Texas

  20. Links 19/3/2018: Linux 4.16 RC6, Atom 1.25, antiX 17.1, GNU Mcron 1.1

    Links for the day

  21. From PTAB Bashing to Federal Circuit (CAFC) Bashing: How the Patent 'Industry' Sells Software Patents

    The latest tactics of the patent microcosm are just about as distasteful as last month's (or last year's), with focus shifting to the courts and few broadly-misinterpreted patent cases (mainly Finjan, Berkheimer, and Aatrix)

  22. Patent Maximalists Keep Coming Up With New Terms and Buzzwords to Bypass the Practical Ban on Software Patents

    The fightback against Section 101 and the US Supreme Court (notably Alice) seems to concentrate on old and new buzzwords, such as "Software as a Medical Device" ("SaMD") or "Fourth Industrial Revolution" ("4IR"), which the EPO recently paid European media to spread and promote

  23. News About Patents is Often Just Advertisements Composed Directly or Indirectly by Companies That Sell Patents and Patent Services

    Infomercials are still dominant among news about patents, in effect drowning out the signal (real journalism) and instead pushing agenda that is detached from reality, pertinent facts, objective assessment, public interest and so on

  24. Blocks and Paywalls Won't Protect the Patent Trolls' Lobby From Scrutiny/Fact-Checking

    Joff Wild and Benoît Battistelli have much in common, including patent maximalism and chronic resistance to facts (or fact-checking)

  25. China Has Become Very Aggressive With Patents

    China now targets other Asian countries/firms -- more so than Western firms -- with patent lawsuits; we expect this to get worse in years to come

  26. UPC/Battistelli Booster IAM Blames Brexit Rather Than EPO Abuses

    While the EPO is collapsing due to mismanagement the boosters of Team Battistelli would rather deflect and speak about Brexit, which is itself partly motivated by such mismanagement

  27. European Commission Again Urged to Tackle Abuses at the European Patent Office (EPO)

    Rina Ronja Kari is the latest MEP attempting to compel the Commission to actually do something about the EPO other than turning a blind eye

  28. Links 18/3/2018: Wine 3.4, Wine-Staging 3.4, KDE Connect 1.8 for Android

    Links for the day

  29. TXED Courts Are Causing Businesses to Leave the District, Notably For Fear That Having Any Operations Based There is a Legal Liability

    A discussion about the infamous abundance of patent cases in the Eastern District of Texas (TXED/EDTX) and what this will mean for businesses that have branches or any form of operations there (making them subjected to lawsuits in that district even after TC Heartland)

  30. PTAB Hatred is So Intense Among the Patent 'Industry' That Even Scammers Are Hailed as Champions If They Target PTAB

    The patent microcosm is so eager to stop the Patent Trial and Appeal Board (PTAB) that it's supporting sham deals (or "scams") and exploits/distorts the voice of the new USPTO Director to come up with PTAB-hostile catchphrases


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


Recent Posts