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. What Insiders Are Saying About the Sad State of the European Patent Office (EPO)

    Anonymous claims made by people who are intimately familiar with the European Patent Office (from the inside) shed light on how bad things have become



  2. The EPO Does Not Want Skilled (and 'Expensive') Staff, Layoffs a Growing Concern

    A somewhat pessimistic look (albeit increasingly realistic look) at the European Patent Office, where unions are under fire for raising legitimate concerns about the direction taken by the management since a largely French team was put in charge



  3. Patents Roundup: Accenture Software Patents, Patent Troll Against Apple, Willful Infringements, and Apple Against a Software Patent

    A quick look at various new articles of interest (about software patents) and what can be deduced from them, especially now that software patents are the primary barrier to Free/Libre Open Source software adoption



  4. Software Patents Propped Up by Patent Law Firms That Are Lying, Further Assisted by Rogue Elements Like David Kappos and Randall Rader (Revolving Doors)

    The sheer dishonesty of the patent microcosm (seeking to bring back software patents by misleading the public) and those who are helping this microcosm change the system from the inside, owing to intimate connections from their dubious days inside government



  5. Links 25/9/2016: Linux 4.7.5, 4.4.22; LXQt 0.11

    Links for the day



  6. Patent Quality and Patent Scope the Unspeakable Taboo at the EPO, as Both Are Guillotined by Benoît Battistelli for the Sake of Money

    The gradual destruction of the European Patent Office (EPO), which was once unanimously regarded as the world's best, by a neo-liberal autocrat from France, Benoît Battistelli



  7. Bristows LLP's Hatred/Disdain of UK/EU Democracy Demonstrated; Says “Not Only Will the Pressure for UK Ratification of the UPC Agreement Continue, But a Decision is Wanted Within Weeks.”

    Without even consulting the British public or the European public (both of whom would be severely harmed by the UPC), the flag bearers of the UPC continue to bamboozle and then pressure politicians, public servants and nontechnical representatives



  8. Released Late on a Friday, EPO Social 'Study' (Battistelli-Commissioned Propaganda) Attempts to Blame Staff for Everything

    The longstanding propaganda campaign (framing staff as happy or framing unhappy staff as a disgruntled minority) is out and the timing of the release is suspicious to say the least



  9. Links 23/9/2016: Latest Microsoft and Lenovo Spin (Now in ‘Damage Control’ Mode)

    Links for the day



  10. White Male-Dominated EPO Management Sinks to New Lows, Again

    Benoît Battistelli continues to make the EPO look like Europe's biggest laughing stock by attempting to tackle issues with corny photo ops rather than real change (like SUEPO recognition, diverse hiring, improved patent quality, and cessation of sheer abuses)



  11. Journalism 102: Do Not Become Like 'Managing IP' or IAM 'Magazine' (the Megaphones of the EPO’s Management)

    Another look at convergence between media and the EPO, which is spending virtually millions of Euros literally buying the media and ensuring that the EPO's abuses are scarcely covered (if ever mentioned at all)



  12. Journalism 101: Do Not Believe Anything That Benoît Battistelli and the EPO's Management Say (Also Don't Fall for the UPC Hype)

    A survey/review (or an overview) of recent articles about the EPO and why they're wrong (mostly because they parrot the official lies from Battistelli's department)



  13. Patent Law Firms, David Kappos, and IAM 'Magazine' Still Shelter Software Patents by Cherry-Picking and Lobbying

    Amid the gradual collapse of software patents in the United States there are disingenuous efforts to bring them back or maintain a perception that these patents are still potent



  14. Microsoft-Connected Patent Trolls Going Places and Suing Microsoft Rivals, Microsoft Wants More 'Linux Patent Tax'

    Microsoft-connected patent trolls like Larry Horn's MobileMedia are still attacking Microsoft rivals and Microsoft wants more money from Korea, after it attacked Linux with software patents over there (notably Samsung and LG)



  15. Links 22/9/2016: Linux Professional Institute Redesign, Red Hat Upgraded

    Links for the day



  16. Links 22/9/2016: Red Hat's Latest Results, GNOME 3.22 Released

    Links for the day



  17. The Patent Law Firms in the US Relentlessly Lobby for Software Patents Resurgence by Placing Emphasis Only on Rare Outcomes

    Decisions against software patents continue to be ignored or intentionally overlooked by patent law firms, which instead saturate the media with the few cases where courts unexpectedly rule in favour of software patents



  18. Links 21/9/2016: Lenovo Helps Microsoft Block GNU/Linux Installations

    Links for the day



  19. Like Big Tobacco Lobbyists, Benoît Battistelli and Team UPC Are Just Chronically Lying and Manipulating Politicians With Their Lies

    Benoît Battistelli and Team UPC continue to meddle in politics and mislead the public (through the press) about patent quality as well the UPC, which is now in effect sunk inside the ashtray of history



  20. The EPO's 'Investigative' Function is Totally Out of Control and Continues to Get Bigger, Whitewashed by So-called 'Review'

    An update on the situation which still causes great unrest at the European Patent Office (EPO), namely abuse of staff by the so-called Investigative Unit (Eponia's equivalent of unaccountable secret services)



  21. Microsoft and Patent Law Firms in the United States Can't Stop Writing About McRo in a Coordinated Push to Resurrect Software Patents

    Microsoft is pursuing more Linux 'patent tax' (using software patents) and patent law firms are preoccupied flooding the media with their shameless self-promotion which is also software patents promotion



  22. For Abuse Like Plagiarism and Malpractice, the US Patent System is Still World Champion

    Low patent quality, abusive litigation (e.g. by patent trolls) and various other elements that globally discredit the USPTO are only symptoms of a wider problem, which is a greedy system motivated by neo-liberal values rather than professionalism and servitude



  23. Links 20/9/2016: GNOME 3.22 Preview, Absolute 14.2 Released

    Links for the day



  24. Links 19/9/2016: Linux 4.8 RC7, KDevelop 5.0.1

    Links for the day



  25. Patents Roundup: Disclosure Requirements, Mobile Patents, Patent Lawyers' Plagiarism, USPTO Getting Sued, and Corporate Domination of the Patent System

    The unwanted elements of the patent system (as it stands at present) illuminated by very recent news and patent court cases



  26. With or Without the UPC (Which Will Probably Never Happen) Battistelli is Crushing the EPO and Ejects Experienced Staff, a Future Without Examination Possible

    A pessimistic but probably realistic take on what is happening at the European Patent Office (EPO), which is undergoing a silent transformation so wide-ranging that stakeholders deserve to know about it



  27. When EPO Liar-in-Chief Benoît Battistelli Defamed His Staff in Parliament, Comparing Them to Nazis and Criminals

    A reminder of the audacity of Benoît Battistelli, who in his capacity as a politician -- a problem in its own right -- slanders EPO staff



  28. After McRO v Namco Case (at CAFC) the Patent Microcosm Works Overtime to Produce Pro-Software Patents Propaganda, Smear the Supreme Court

    Increasingly desperate to convince people to pursue software patents and/or use their software patents to initiate growingly risky lawsuits (high risk of losing), the patent microcosm hugs McRO v Namco while distorting the complete record of the Court of Appeals for the Federal Circuit (CAFC) on this subject



  29. Poor Quality Control at the US Patent Office Gives Birth to 'Unpatent' and Gives a Voice to Critics

    The USPTO must up its game on patent quality (not relying on PTAB and the courts correcting its errors after the grants) or face growing backlash that tarnishes its public image



  30. Patent Trial and Appeal Board Under Attack by Law Firms, Which Will Soon Infiltrate It in the Form of 'Bar Association'

    The vultures that are patent law firms keep circling around PTAB and hoping to destroy it, if not from the outside then from the inside, potentially regressing and ruining great progress for US patent quality since Mayo and Alice


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