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 19/2/2017: GParted 0.28.1, LibreOffice Donations Record

    Links for the day



  2. The EPO is Becoming an Embarrassment to Europe and a Growing Threat to the European Union

    The increasingly pathetic moves by Battistelli and the ever-declining image/status of the EPO (only 0% of polled stakeholders approve Battistelli's management) is causing damage to the reputation of the European Union, even if the EPO is not a European Union organ but an international one



  3. Patent Misconceptions Promoted by the Patent Meta-Industry

    Cherry-picking one's way into the perception of patent eligibility for software and the misguided belief that without patents there will be no innovation



  4. As the United States Shuts Its Door on Low-Quality Patents the Patent Trolls Move to Asia

    Disintegration of Intellectual Ventures (further shrinkage after losing software patents at CAFC), China's massive patent bubble, and Singapore's implicit invitation/facilitation of patent trolls (bubble economy)



  5. Links 17/2/2017: Wine 2.2, New Ubuntu LTS

    Links for the day



  6. Bad Advice From Mintz Levin and Bejin Bieneman PLC Would Have People Believe That Software Patents Are Still Worth Pursuing

    The latest examples of misleading articles which, in spite of the avalanche of software patents in the United States, continue to promote these



  7. Patents Are Not Property, They Are a Monopoly, and They Are Not Owned But Temporarily Granted

    Patent maximalism and distortion of concepts associated with patents tackled again, for terminology is being hijacked by those who turned patents into their "milking cows"



  8. SoftBank Group, New Owner of ARM, Could Potentially Become (in Part) a Patent Troll or an Aggressor Like Qualcomm

    SoftBank grabbed headlines (in the West at least) when it bought ARM, but will it soon grab headlines for going after practicing companies using a bunch of patents that it got from Inventergy, ARM, and beyond?



  9. Technicolor, Having Turned Into a Patent Troll, Attacks Android/Tizen/Linux With Patents in Europe

    Technicolor, which a lot of the media portrayed as a patent troll in previous years (especially after it had sued Apple, HTC and Samsung), is now taking action against Samsung in Europe (Paris, Dusseldorf and Mannheim)



  10. Michelle Lee is Still “in Charge” of the US Patent System

    Contrary to a malicious whispering campaign against Lee (a coup attempt, courtesy of patent maximalists who make a living from mass litigation), she is still in charge of the USPTO



  11. Our Assessment: EPO Wants a Lot of Low-Quality Patents and Low-Paid Staff With UPC (Prosecution Galore)

    The European Patent Office seems to be less interested in examination and more interested in facilitating overzealous prosecution all across Europe and beyond; The Administrative Council has shown no signs that it is interested in profound changes, except those proposed by Battistelli in the face of growing resistance from staff and from ordinary stakeholders



  12. Links 16/2/2017: HITMAN for GNU/Linux, Go 1.8

    Links for the day



  13. Yet More Complaints About the European Patent Office in the Bavarian Regional Government

    Some German politicians do care about the welfare of EPO staff, a lot more so than the EPO's management that is actively crushing this staff



  14. EPO Staff Representatives to Escalate Complaint About Severe Injustices to the EPO's Secretive Board 28

    In a new letter to President Benoît Battistelli it is made abundantly apparent -- however politely -- that Battistelli's gross abuses could further complicate things for Battistelli, who is already embroiled in a fight with his predecessor, Roland Grossenbacher



  15. New Survey Reveals That High Patent Quality, or Elimination of Bad Patents, is Desirable to Patent Holders

    A new survey from Bloomberg BNA and AIPLA reveals that the Patent Trial and Appeal Board (PTAB), which still grows in prominence, is supported by people who have themselves gotten patents (not those who are in the bureaucracy of patents and self-serving politics)



  16. Open Patent Office is Not the Solution; Ending Software Patents is the Solution

    Our remarks about the goals and methods of the newly-established Open Patent Office and what is instead needed in order to combat the menace that threatens software development



  17. New Scholarly Paper Says “UK’s Withdrawal From the EU Could Mean That the Entire (Unitary Patent) System Will Not Go Into Effect”

    A paper from academics -- not from the patent microcosm (for a change) -- provides a more sobering interpretation, suggesting quite rightly that the UPC can't happen in the UK (or in Europe), or simply not endure if some front groups such as CIPA somehow managed to bamboozle politicians into it (ratification in haste, before the facts are known)



  18. Patent Trolls Update: Rodney Gilstrap Maintains His Support for Trolls, MPEG-LA Goes Hunting in China, and Blackberry Hits Nokia

    A roundup of the latest news about patent trolls and what they are up to in the United States, Europe, and Asia



  19. Guest Post: EPO, an Idyllic Place to Work

    The true face of the EPO as explained by an insider, recalling the history that led to the negative image and toxic work atmosphere



  20. Links 15/2/2017: Linux 4.9.10 and Linux 4.4.49

    Links for the day



  21. Claude Rouiller (ILOAT) and ILO Rulings Effectively Disregarded by the European Patent Office

    The compositions of kangaroo courts at the EPO continue to be absurd, in spite of a ruling from the International Labour Organisation (ILO), which insisted that change must be made following a lot of mistrials



  22. National Law Journal Believes That Gorsuch as Supreme Court Justice Would be Opponent of Patent Reform

    Whispering campaign surrounds Neil Gorsuch's alleged or perceived views on patents, and in particular the America Invents Act (AIA) which brought the Patent Trial and Appeal Board (PTAB), a serial invalidator of software patents, owing to Alice (a Supreme Court decision)



  23. Center for Intellectual Property Understanding (CIPU) is a Lobby Group for Software Patents and Patent Maximalism

    An introduction to what the Center for Intellectual Property Understanding really is, what it is for, and who is behind it



  24. The European Patent Office Looks More and More Like the Sicilian Mafia Every Day

    Battistelli has constructed or pulled together a Mafia-like family inside the EPO, where all those who protect the 'King' (or Don) are rewarded and the rest are removed with prejudice



  25. EPO-Connected Writers Are Using Alternative Facts or Fake News to Promote the Unitary Patent in British Media

    The misuse of publications for the purpose of lobbying by Battistelli and Team UPC (a small group of opportunists looking to exploit change that they themselves introduce) is worth noting, for its frequency is on the rise again



  26. Microsoft Has Not Managed to Blackmail Huawei Over Android and GNU/Linux, But Its Trolls/Satellites Are Trying

    The story of Huawei gets more complicated, even though software patents are losing their teeth and notorious patent trolls are altogether losing their patents



  27. IBM Has Become an Enemy of GNU/Linux and a Loud Proponent of Software Patents

    IBM's poisonous policy on patents, which has long been incompatible with Free/Libre software, has gotten even worse and the company now takes the lead in lobbying for patenting of software



  28. Leaked: European Patent Office a Fire Hazard Waiting to Cause Tragedy (Possible Deaths)

    The EPO has known for a while that is was not in compliance with regulations, but as usual -- flaunting immunity and impunity -- nothing happened



  29. For Valentine's Day, Battistelli Learns to Stop Worrying and Love to Lie

    Battistelli lies about patent quality once again, incidentally on the very same day that serious leaks regarding patent quality got published (and need distracting from)



  30. India Cites Public Interest in Patent Case Where Embargo Attempted Against Local Drugmaker

    India turns away a foreign corporation that attempts to use patents to shut down (or destroy the business model of) an Indian company


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