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. Patent Scope Recognised as Essential For Patent Quality, But Software Patents Continue to be Granted

    Patents that are toothless, clawless lions are being accumulated by companies that should know various courts would scrutinise these enough to rule them invalid



  2. Litigation and Patenting Versus Research and Development

    reminder of who's 'stealing' jobs from engineers and who it is done for (who benefits from mass taxation rather than actual production)



  3. The Federal Circuit Has Become the Go-To Place For Patent Appeals Arising From USPTO Errors

    Patent appeals that come to CAFC as a result of bad Patent Office decisions now outnumber the appeals coming from district courts (an extraordinary situation)



  4. The Truly Odd Concept of Design Patents, Which the US Supreme Court Might Crush Very Soon

    The epidemic of shallow patents, which has already resulted in patents on mere designs, be soon end; but not before an unprecedented gold rush for such patents



  5. Quality of European Patents Has Sunk, Value Diminished

    The trouble associated with declining patent quality at the European Patent Office and early warnings about it from the staff union



  6. The Notorious 1-Click Buying Patent Expired Rather Than Invalidated

    As proof of the fact that many bogus patents (typically on software) are worthless but not invalidated, we now have Amazon's patents reaching their end of life



  7. PTAB Crushes Software Patents and Patent Extremists Are Not Happy About It

    The Patent Trial and Appeal Board (PTAB), a legal facility which invalidates many software patents, still faces opposition from those who profit from software patents (not software developers)



  8. Software Patents and Patent Trolls Are Almost the Same Problem (Still)

    Apple just got sued again, Microsoft-connected patent trolls continue serial litigation against Microsoft's competitors, and a bike shop gets sued using software patents



  9. Links 20/8/2017: KStars 2.8.1, Fedora Design Interns

    Links for the day



  10. Lack of Independent Judiciary Under the Unitary Patent (Like Boards of Appeal Under Battistelli, in Defiance of the EPC) Will Possibly Kill the Unified Patent Court

    Germany, a key player in UPC negotiations (most patents at stake), cannot proceed to ratification and Britain's expected exit from the European Union further restricts any progress



  11. The Staff Union of the EPO Has Long Warned About Declining Patent Quality

    The quality of granted European Patents (EPs) has been declining sharply and the EPO's staff representatives have warned about it for a long time, only to find themselves severely reprimanded for telling the truth



  12. The EPO's Management Needs a Perception of Security Crisis

    The EPO follows that familiar pattern of writing about every Islamic terror attack in Europe (and in the US too) while media in Munich tells a story where facts are yet uncertain



  13. Links 18/8/2017: Wallpaper of Plasma 5.11, Oracle Liberates Java EE a Bit

    Links for the day



  14. Links 17/8/2017: Krita 3.2.0, New Raspbian GNU/Linux OS

    Links for the day



  15. Corruption at the European Patent Office and Systematic Bullying That Leads People to Suicide/Bankruptcy

    A look back at 3 years of intensive EPO coverage and what's coming up next (suppression of truth behind closed doors in the courtrooms)



  16. Supreme Court Decision on TC Heartland v Kraft Food Brands Group Already Vacates the Eastern District of Texas

    Patent trolls are losing their mojo as patent lawsuits drop 21% in the Eastern District of Texas and this collapse is expected to accelerate



  17. Media Dominated by the Patent Microcosm Spreads Myths and Defends Patent Trolls, Collectors

    Popular culture myths, such as Edison being a prolific inventor, and what we all ought to know about an actual patent epidemic (vast increase in the number of patents granted, bringing the total to over 10 million in the US)



  18. The Patent Trial and Appeal Board Squashes Many Software Patents (Abstract) and §101 Seems Safe From Lobbying by the Patent Microcosm

    The Patent Trial and Appeal Board (PTAB), together with the Alice-inspired §101, is an efficient eliminator of bogus patents on software and there is no end to that in sight



  19. Ericsson Hired From the World's Largest Patent Troll and Became a Massive Troll in Europe

    Ericsson's patent aggression campaign (even in Europe) carries on; it turns out the person behind this strategy came from Intellectual Ventures



  20. Links 16/8/2017: Ardour 5.11, 24th Birthday of Debian

    Links for the day



  21. Links 15/8/2017: New LibreELEC and More

    Links for the day



  22. The Collapse of Patent Quality at the EPO is Inviting to Europe Some of the World's Worst Patent Trolls

    As troll litigation soars in Europe we must take a careful look at the sorts of patents granted by the EPO these days and the policies that support such grants



  23. The EPO is Paying Journalists For Trips Abroad and May be Buying Fake Twitter Followers (Still)

    The EPO's media strategy -- a nefarious strategy which is costing many millions of euros and is corrupting the media -- explained in light of recent activity and reporting (in German)



  24. 'US Inventor' is an Extremist Group Created by Watchtroll (Not Inventors) to Troll the USPTO for Patent Maximalism

    The face behind so-called 'US Inventor' (an anti-PTAB group) which enlists, apparently, a handful of people and does not actually represent American inventors



  25. Links 14/8/2017: Linux 4.13-RC5, PostgreSQL 10 Beta 3, GCC 7.2

    Links for the day



  26. Links 13/8/2017: DebConf 2017 and GUADEC 2017 Wrapups

    Links for the day



  27. The Farce Which is Nokia's Patent Portfolio, a Ripoff of Other People's Ideas (and Patents)

    The untold story about Nokia's alleged ripoff (plagiarism) of other people's patents, which are now being used aggressively in a shakedown campaign even against OEMs that distribute Linux



  28. Software Patents Help Neither Software Developers Nor Society in General. It's Time to Bury Them All.

    The idea that patents for the sake of patents (or increasing the overall number of patents) is somehow beneficial to everything these patents touch is misguided and detrimental not only to practitioners but also to the public whose work contributes to



  29. The Latest Evidence of the Demise of Software Patents in the United States

    Even though some software patents continue to be granted, courts in the U.S. almost always reject these, signaling the end of software patents as a potent tool (unless there's an out-of-court settlement, usually because the defendant is too poor)



  30. Growing Unrest Over Patent Trolls Goes Political

    Encouraging signs for scientists and technologists: The push for the end of patent trolling (patent assertion by parasitic opportunists against vulnerable people who cannot afford legal defense)


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