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. Links 26/6/2017: Lumina Version 1.3.0, Final Linux RC

    Links for the day



  2. EPO Strikes in All Four EPO Sites for Two Days This Month and Next Month, Under the “Respect Staff” Banner

    The impact of the strikes at EPO doubles, as two strikes in two months are scheduled, starting this week



  3. Latest EPO Caricature: Staff Committee Maintains Integrity

    Caricature about double failure of Battistelli last week -- a failure which shall result in a general strike fairly soon



  4. Voter Suppression Tactics by Team Battistelli Serve to Reaffirm View That the EPO is an Authoritarian Regime Which Loathes Voting

    In spite of the dirty tricks employed by Team Battistelli, staff managed to guard the integrity of the staff committee and vote for a strike; the dirty tricks, however, will not and should not be forgotten



  5. Leaked: Job Opening Advertised as Battistelli’s 'Mole' at the Administrative Council, Jesper Kongstad, Leaves in Shame

    Having disgraced the Administrative Council of the EPO, e.g. by protecting the person whom he is supposed to supervise, Jesper Kongstad will leave in 3 months



  6. As Electronic Frontier Foundation (EFF) Ramps Up Its Campaign Against Software Patent Trolls the Patent Microcosm Attacks the Messenger (EFF)

    In an effort to thwart Alice and the EFF (two birds, one stone) the patent microcosm goes behind the scenes and saturates the media with misleading articles, including attacks on the EFF itself



  7. In Sandoz v Amgen, the Federal Circuit is Again Found to Have Delivered Patent Injustice

    SCOTUS continues to disagree with CAFC on everything that it decides to reconsider, even the very latest decision (formally delivered earlier this month)



  8. The Supreme Court Can Reassert the Legitimacy of the Patent Trial and Appeal Board (PTAB) Later This Year or Next Year

    What lawyers-centric media characterises as a risk to PTAB may actually be an opportunity to silence critics of PTAB and help it carry on squashing bogus patents



  9. The US Patent Office (USPTO) Should Now be Headed by Drew Hirshfeld, a Patent Examiner Who Rose to the Top, Not a Lawyer Like Joseph Matal

    Donald Trump's Secretary of Commerce, Wilbur Ross, pushes to the top the patent microcosm rather than technical people who are equipped with the knowledge and experience to run the Office as well as Michelle Lee did



  10. After Latest Supreme Court Rulings on Patents, Including Impression v Lexmark, the Federal Circuit is Left Disgraced

    Hostility towards the patent microcosm's patent maximalism, as witnessed at the US Supreme Court (SCOTUS), culminated in another decision and will soon result in yet more decisions, as SCOTUS has since then picked more patent cases to look at



  11. IBM, Apple and Facebook Pursue Software Patents in India in Defiance of the Ban

    Multinationals from the United States, or digital colonisers with ambitions to spy on and control finance, continue to behave as though Indian law is not applicable to their operations in India and repeatedly attempt to patent software anyway



  12. Wouter Pors Under Fire for Lying or Manipulating in the Name of the Unitary Patent (UPC)

    The argument between Team UPC and other patent professionals (without a lot of eggs in the UPC basket) heats up as Wouter Pors resorts to desperate measures and Bristows belatedly admits constitutional problems in the UK



  13. Systemic Injustice at the International Labour Organisation (ILO) Causes Serious Harm to Complainants' Health, Including EPO Complainants

    The high human cost of ILO's failure to fulfill its stated mission while pretending that it has things under control (that is clearly no longer the case, especially as far as EPO cases go)



  14. Links 24/6/2017: GNOME Music Improves, FreeBSD 11.1 Beta 3

    Links for the day



  15. Microsoft and Bill Gates Become More Actively Involved in Their Biggest Patent Troll (and World's Biggest Troll), Intellectual Ventures

    The world's largest patent troll, which reportedly operates (litigates) through literally thousands of shells, has received yet more financial aid from Microsoft and Bill Gates



  16. The STRONGER Patents Act is One Among Several New Pushes for Patent Chaos in the United States

    US patent law is being 'massaged' again, with bills being pushed forth that propose a return to Armageddon, undoing much of the progress made possible by the Leahy-Smith America Invents Act (AIA)



  17. SUEPO and the EPO's Central Staff Committee Condemn Battistelli's Latest Attempt to Change the Rules in Defiance of Laws

    Staff representatives at the EPO voice opposition to so-called 'reforms' which are neither desirable nor legal



  18. The Tide Has Turned Against the Unified Patent Court (UPC) and It Finally Looks as 'Alive' as TPP

    The UPC is now stuck if not dead because officials are realising -- however belatedly -- that this entire charade was from start to finish just a coup d'état of the patent 'industry'



  19. Potential Targets of European Patent Office (EPO) Whistleblowing

    Priorities for whistleblowing at the European Patent Office (EPO), which operates secretly and occasionally illegally, too



  20. Links 23/6/2017: Wine 2.11 Released, HPC Domination by GNU/Linux

    Links for the day



  21. Primer to the Crisis and Scandals at the European Patent Office (EPO)

    An introduction to the chaotic state of what used to be the world's leading patent office and quickly became Europe's biggest embarrassment



  22. Workers of the European Patent Office (EPO) Are Going on Strike Again, Almost 90% Voted in Favour

    Thousands of brave EPO employees chose to cast a vote and make it known that they are in favour of another strike



  23. Benoît Battistelli Has Lost the Election at the EPO

    FFPE candidates (or moles from the yellow union) failed to enter the Central Staff Committee in spite of Battistelli's attempt to help them get in



  24. Emerging Threat to Patent Reforms at the USPTO

    Our plan of returning to coverage of US patent affairs in the wake of powerful lobbies that pursue patent maximalism



  25. You Know That the Unitary Patent (UPC) is in Huge Peril When Its Biggest Fans Admit It's Unlikely to Happen Even Next Year

    The tactics of Team UPC turn ugly as they personally target anyone who stands in their way, even a professor/judge who is courageous enough to state the obvious



  26. More Than Six Human Casualties Under Battistelli at the EPO, But the Human Toll Can Become a Lot Worse

    The bigger or much broader picture detailing the high cost of autocracy and mental torture at the EPO, where lives are ruined not only when these are ended and some key buildings pose severe threat to a lot of workers



  27. EPO's Elodie Bergot Calls Staff Suicide Just 'Passing Away', Pretends to Care

    How the EPO continues to mislead if not lie to staff, even when staff commits suicide -- a growing problem for Team Battistelli, whom some insiders hold accountable for these deaths



  28. The Administrative Tribunal of ILO Will Deliver EPO Judgments in Six Days

    Despite its old age (nearly a century), ILO's tradition when it comes to enforcing the law is anything but sterling, yet one can hope that it will stop its unproductive cat-and-mouse game with the EPO, where compliance is rare and actual judgments (not deferrals/referrals) are even rarer



  29. Links 21/6/2017: Red Hat's Numbers Are Up, New Debian Being Studied

    Links for the day



  30. Another Suicide Reported at the EPO While the Paid-for Media Focuses on 'European Inventor Award' Charade

    Puff pieces for Benoît Battistelli published aplenty while the European media refuses to deal with the reality -- not paid-for illusions -- at the European Patent Office


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