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. Time for the European Commission to Investigate EPO Corruption Because It May be Partly or Indirectly Connected to EU-IPO, an EU Agency

    The passage of the top role at the EU-IPO from António Campinos to Christian Archambeau would damage confidence in the moral integrity of the European Council; back room deals are alleged to have occurred, implicating corrupt Battistelli



  2. Links 17/7/2018: Catfish 1.4.6 Released, ReactOS 0.4.9, Red Hat's GPL Compliance Group Grows

    Links for the day



  3. Links 16/7/2018: Linux 4.18 RC5, Latte Dock v0.8, Windows Back Doors Resurface

    Links for the day



  4. Alliance for US Startups and Inventors for Jobs (USIJ) Misleads the US Government, Pretending to Speak for Startups While Spreading Lies for the Patent Microcosm

    In the United States, which nowadays strives to raise the patent bar, the House Small Business Committee heard from technology firms but it also heard from some questionable front groups which claim to support "startups" and "jobs" (but in reality support just patents on the face of it)



  5. 'Blockchain', 'Cloud' and Whatever Else Gets Exploited to Work Around 35 U.S.C. § 101 (or the EPC) and Patent Algorithms/Software

    Looking for a quick buck or some low-quality patents (which courts would almost certainly reject), opportunists carry on with their gold rush, aided by buzzwords and hype over pretty meaningless things



  6. PTAB Defended by the EFF, the R Street Institute and CCIA as the Number of Petitions (IPRs) Continues to Grow

    Patent Trial and Appeal Board (PTAB) inter partes reviews (IPRs) come to the rescue when patently-bogus patents are used, covering totally abstract concepts (like software patents do); IPRs continue to increase in number and opponents of PTAB, who conveniently cherry-pick Supreme Court (SCOTUS) decisions, can't quite stop that



  7. IAM/Joff Wild May Have Become a de Facto Media Partner of the Patent Troll iPEL

    Invitation to trolls in China, courtesy of the patent trolls' lobby called "IAM"; this shows no signs of stopping and has become rather blatant



  8. Cautionary Tale: ILO Administrative Tribunal Cases (Appeals) 'Intercepted' Under António Campinos

    The ILO Administrative Tribunal (ILO-AT) is advertised by the EPO's management as access to justice, but it's still being undermined quite severely to the detriment of aggrieved staff



  9. Asking the USPTO to Comply With 35 U.S.C. § 101 is Like Asking Pentagon Officials to Pursue Real, Persistent Peace

    Some profit from selling weapons, whereas others profit from patent grants and litigation; what's really needed right now is patent sanity and adherence to the public interest as well as the law itself, e.g. Supreme Court (SCOTUS) decisions



  10. BT and Sonos Are Still Patent Bullies, Seeing Patents as a Backup Plan

    The companies seeking to complement their business (or make up for their demise) using patents are still suing rivals while calling that litigation "research and development" (the same old euphemism)



  11. Jim Skippen, a Longtime Patent Troll, Admits That the Trolling Sector is Collapsing

    Canada's biggest patent troll (WiLAN) bar BlackBerry doesn't seem to be doing too well as its CEO leaves the domain altogether



  12. From East Asia to the Eastern District of Texas: XYZ Printing, Maxell, and X2Y Attenuators

    The patent aggression, which relies on improper litigation venues, harms innocent parties a great deal; only their lawyers benefit from all this mess



  13. Links 14/7/2018: Mesa 18.1.4, Elisa 0.2.1, More on Python's Guido van Rossum

    Links for the day



  14. Number of Oppositions to Grants/Awards of European Patents at the EPO Has Skyrocketed, Based on Internal Data

    The number of challenged patents continues to soar and staff of the EPO (examiners already over-encumbered by far too much work, due to unrealistic targets) would struggle to cope or simply be compelled to not properly deal with oppositions



  15. 'Transaction' Complete: Former EPO Executive From Belgium Takes the Seat of António Campinos at EU-IPO

    Rumours that Belgium made a back room deal with Battistelli may be further substantiated with the just-confirmed appointment of Archambeau



  16. EPO Abuses Against People With Disabilities Followed by Legal Bullying?

    The new President of the EPO is not (at least not yet) obeying court rulings from ILO; The above move seems like an attempt to derail ongoing cases at the ILO’s Administrative Tribunal (ILO-AT), i.e. yet more strong-arming



  17. Weeks Later António Campinos Still in Noncompliance With the Courts (ILO's Tribunal)

    'report card' for the ever-so-intransparent (or nontransparent) new President of the EPO, who does not even bother obeying court rulings



  18. Links 13/7/2018: Kube 0.7.0, Trisquel 8.0 LTS Reviewed

    Links for the day



  19. Constitutionality and CJEU as Barriers, the UPC Agreement (UPCA) is Already Moot in the United Kingdom

    The Unified Patent Court (UPC) isn't going anywhere and the UK merely "explores" what to do about it; for Team UPC, however, this means that the UK "confirms intention to remain in Unitary Patent system after Brexit" (clearly a case of deliberate misinformation)



  20. It's Not About EPO 'Backlog' But About Faking 'Production' by Lowering Standards

    Remarks on the EPO dropping all pretenses of genuine care for patent quality; it's all about speed now, never mind if wrongly-granted patents can cause billions in damages across Europe (a lot of that money flows towards patent law firms)



  21. Links 12/7/2018: GTK+ 4.0 Plans, OpenBSD Gains Wi-Fi “Auto-Join”

    Links for the day



  22. The Anti-35 U.S.C. § 101 Lobby Pushes Old News Into the Headlines in an Effort to Resurrect/Protect Software Patents

    The software patenting proponents (law firms for the most part) are still doing anything they can -- stretching even months into the past -- in an effort to modify the law in defiance of Supreme Court (SCOTUS) rulings



  23. Thomas Massie and Marcy Kaptur Are Promoting the Interests of Patent Trolls and Patent Lawyers While Calling That “Innovation”

    Remarks on the ongoing effort to promote patent trolls’ interests under the guise of “helping small businesses” — a very misleading propaganda pattern that we have been finding in Unified Patent Court (UPC) lobbying at the EPO



  24. Links 12/7/2018: Mesa 18.1.4 RC, Curl 7.61.0

    Links for the day



  25. Texas: When Trade Secret 'Damages' Are Almost 1,000 Times Higher Than Patent 'Damages'

    It's possible to deal with conflicts and disputes using means other than patents; a new trade secret misappropriation case and a new study from Ofer Eldar (Duke Law) and Neel Sukhatme (Georgetown Law) bring examples from Texas



  26. Cellspin Soft Will Likely Need to Pay the Accused Party's Lawyers Too After Frivolous Litigation With Patents Eliminated Under 35 U.S.C. § 101

    Pursuing bogus (questionable) patents and going even further by asserting them in court can be worse than a waste of time and money; it can actually cause the target of assertion to be compensated (legal fees) at the plaintiff’s expense — a critical fact largely ignored by the patent ‘industry’



  27. The Lack of Genuine, Honest Discussion About Patent Quality Means That Under António Campinos Software Patents Will Continue to be Granted, Campinos Strives to Make Them 'Unitary'

    The agenda of the litigation 'industry' is still being served by the existing EPO administration; this is a problem because not only do they grant patents on just about anything but they also attempt to broaden litigation jurisdiction



  28. Links 11/7/2018: Xen 4.11, Ubuntu Infographics, Lockbox and Notes

    Links for the day



  29. Links 10/7/2018: Wine 3.12, FreeNAS 11.2 Beta, GNU Helps Journalism

    Links for the day



  30. Patent Trolls Rally/Advertise Thomas Massie's Bill to Abolish PTAB and Promote Software Patents in the US

    Vocal patent maximalists (or think tanks of the litigation 'industry') want us to think that the US is too restrictive when it comes to patents (the opposite is true) and tries to change the law so as to plague/saturate the system with patent lawsuits they stand to gain from at the expense of practicing companies


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