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. Outline/Index of the Alexandre Benalla/Battistelli Scandal

    Our writings about the scandals implicating Benalla and the European Patent Office (EPO)



  2. Reading Techrights on a Mobile Device Running Android

    A new Android app for reading this site is being tested



  3. Links 14/2/2019: “I Love Free Software Day” and Mesa 19.0 RC4 Released

    Links for the day



  4. “EPO Lawlessness Again”

    Blackberry uses bogus European Patents (on software) for lawsuits; "all of them pure software patents. Patents on programs for computers as such," as Müller puts it



  5. Unitary Patent (UPC) is All About Imposing Patent Maximalists' Ideology of Greed and Self Interest on Courts in the Name of 'Unification' or 'Consistency' or 'Community'

    Pushers of the Unified Patent Court (UPC) are upset that they don’t always get their way when independent judges get to decide; as it turns out, many European Patents are just fake patents, more so under António Campinos



  6. Battistelli's Bodyguard, Part V: Mediapart Explains the 'Raid' Attempt, Reporters Without Borders Involved

    Mediapart, an investigative site that unearths a lot of incriminating things about Battistelli's former bodyguard Alexandre Benalla, was the target of a raid attempt some weeks ago



  7. Links 13/2/2019: Tails 3.12.1, MongoDB Being Dumped

    Links for the day



  8. Battistelli's Bodyguard, Part IV: Suspected Offenses of Forgery and Possible Falsification

    In a very underworld fashion, Benalla continues to break the law and create yet more scandals



  9. Battistelli's Bodyguard, Part III: Mars, France Close Protection (Benalla's Family), and Russian Oligarchy

    An article which examines the business background of Benalla, the outrageous salaries, the severance indemnity pay, and contract with a Russian oligarch close to Vladimir Putin



  10. Links 13/2/2019: Plasma 5.15.0 and a Look at Linux Mint Debian Edition Cindy

    Links for the day



  11. Battistelli's Bodyguard, Part II: Fishing Expedition for Sources in the Alexandre Benalla 'Underworld' Scandal

    An utter lack of respect for the privacy of the media and of its sources, in the name of protecting the privacy of those convicted of crimes, as seen in France just like the European Patent Office



  12. Innovating the Idea That Software Patents (Monopolies on Algorithms) Are Covering 'Artificial' 'Intelligence' (AI and ML as Loopholes)

    Patent law firms around the world love this new trick, which is framing software that makes decisions as "AI" (magically rendering it patent-eligible only in offices but not in courts, which the EPO hopes to replace/override anyway)



  13. Battistelli's Bodyguard, Part I: Destruction of Evidence by Alexandre Benalla

    The Alexandre Benalla scandal carries on, deepening even further than before and causing raids of the media; will the EPO be implicated and held accountable too?



  14. Links 12/2/2019: PyPy 7.0.0, HHVM 4.0.0 and CVE-2019-5736

    Links for the day



  15. USPTO Director Iancu Works for Anti-SCOTUS (Against Section 101) Lobbyists

    The United States Patent and Trademark Office Director Andrei Iancu is becoming to the patent system what Ajit Pai is to the FCC or to the broadband industry; there appears to be intentional vandalism and total disregard for the rule of law



  16. Gross Violations of the EPC at the European Patent Office as Principal Priority Turns Against Science and Technology

    What good is the law if violation of the European Patent Convention (EPC) is so routine at today’s European Patent Office (EPO), which exploits its immunity to operate outside the rule of law and pursue nothing but cash (selling patents/monopolies that are invalid in courts)?



  17. European Patent Office's Exploitation of the 'AI' Catchphrase/Buzzword to Grant Patents on Algorithms in Defiance of the Rules, the Law, and Common Sense

    In clear violation of the EPC (i.e. more of the same from the EPO) software patents are being actively promoted and law being bypassed or worked around



  18. Microsoft's Patent Trolls Are Still Suing Microsoft's Rivals to Help Sell Microsoft

    The ‘new’ Microsoft boils down to the patent equivalent of the copyright case of SCO (funded by Microsoft)



  19. The American Software Patents Lobby Has Died

    Voices of US law firms (i.e. patent maximalists) have become quieter and rarer; applications for US patents have decreased in number, patent litigation numbers have collapsed entirely, and patent maximalists have moved on



  20. Links 10/2/2019: Linux 5.0 RC6, Project Trident 18.12 Reviewed

    Links for the day



  21. Corrupt Battistelli Paid a Fortune (EPO Budget) for Outlaw/Rogue 'Bodyguards' From Firm Linked to Russian Oligarch Iskander Makhmudov

    Mediapart continues to shed more light on the shady firm behind Alexandre Benalla, whom Battistelli hired to break the law and secretly bring firearms to the EPO



  22. Which Microsoft?

    The inconsistencies between public statements of Microsoft and private discussions/actions



  23. António Campinos Will Never Hold Battistelli Accountable for His Crimes Because He Too Profits From These

    The EPO isn't just Europe's second-largest institution but also quite possibly Europe's largest criminal enterprise, whose ringleaders have enjoyed and exploited diplomatic immunity to escape prosecution



  24. 25,000 Blog Posts and Record Traffic

    At a pace of nearly 2,000 posts per year (since 2006) we continue to grow and can use readers' help



  25. Jim Zemlin's PAC Keeps Raising Money From Microsoft

    The Open Source Definition's author as well as various Free/Open Source software (FOSS) luminaries warn of an attack on FOSS ("efforts to undermine the integrity of open source”); it's not too hard to see who participates in it or enables such attacks



  26. Links 9/2/2019: Linux 4.4.174 and GTK+ No More (Now Just GTK)

    Links for the day



  27. Number of Patent Applications, Not Just Number of Patent Grants, Continues to Slide in the United States

    The attractiveness of US patents appears to have eroded, seeing that many US patents are simply not enforceable in courts



  28. EPO President Campinos Works With Patent Trolls and With Team UPC to Promote Software Patents

    The EPO has taken another tumble by collaborating with '4iP Council', a patent extremists' lobby; it is moreover becoming apparent that a lot of European Patents are bogus (not valid) and the management of the EPO is eager to grant yet more of these



  29. Links 8/2/2019: Things to Look For on Linux in 2019, Fedora Logo Redesign

    Links for the day



  30. Teff is Not an Invention. Teff is Nature.

    The absurdity of 'owning' nature or things that are found in nature (and can reproduce) demonstrated again in Europe


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