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. Microsoft-Connected Patent Trolls Are Increasingly Active and Microsoft is Selling 'Protection' (Azure Subscriptions)

    There are several indications that Microsoft-connected shells, which produce no products and are threatening a large number of companies, are inadvertently if not intentionally helping Microsoft sell "indemnification" ("Azure IP Advantage," which echoes the Microsoft/Novell strategy for collecting what they called "patent royalties" one decade ago)



  2. Yes, RPost is Definitely a Patent Troll and Its Software Patents Are at Risk Thanks to Alice

    The latest whitewashing (or reputation-laundering) pieces from Watchtroll, which tries to justify patent-trolling activities with software patents, typically in the Eastern District of Texas



  3. The Latest Scams in the Patent World

    Examples of 'dirty laundry' of the patent microcosm, which it understandably does not like covering (as it harms confidence in their services/advice)



  4. Patents Are Becoming a Welfare System for the Rich and Powerful

    A culture of litigation and more recently the patenting of broad industry standards may mean that multi-billion dollar corporations are cashing in without lifting a finger



  5. Unlike the Mobile Domain, When it Comes to Cars Patent Lawsuits Remain Rare

    An optimistic note regarding the relatively low-temperature legal landscape surrounding advanced automobiles, even though patents are being amassed on software in that domain



  6. The Federal Circuit Rules (Again) in Favour of Section 101/Alice, Koch-Funded CPIP Tries to Overturn Alice at the Supreme Court

    The US Supreme Court's decision on Alice continues to have a profoundly positive impact (except for trolls) and Koch-funded academics try hard to compel the US Supreme Court to reverse/override Alice (so far to no avail)



  7. Next Director of the USPTO Parrots Talking Points of Patent Extremists and Their Lobbyists

    The next USPTO boss (still subject to official confirmation) may be little more than a power grab by the litigation and patenting 'industry', which prioritises not science and technology but its own bottom line



  8. Raw: Three Years for 'Justice' (to be Disregarded by Benoît Battistelli) at ILO and Over a Decade at the EPO

    The delays associated with ‘justice’ at the EPO (usually neither justice nor compliance with rulings) have become so extraordinary that immunity should long ago have been stripped off and Battistelli et al been held accountable



  9. Raw: Scuttling of the General Advisory Committee and Battistelli Stacking the Deck to Have 'Yes Men' as Representatives

    How the EPO broke down resistance to Battistelli’s oppressive policies not only at the Council, disciplinary committees and auditory divisions but also staff representation (symptomatic of Battistelli’s notion of justice)



  10. The Patent Trial and Appeal Board Will Endure Supreme Court Test and Overcome the Tribal Immunity “Scam”

    The Patent Trial and Appeal Board (PTAB), based on the latest news, is still winning the argument and justifying its existence/importance



  11. Phones/Mobility (Trillion-Dollar Market) May Have Become Infested and Encumbered by Aggressive, Dying Companies

    The tough reality that new entrants/entrepreneurs are facing now that a few dying giants look to "monetise" their patents rather than create anything



  12. Links 9/12/2017: Mesa 17.3, Wine 3.0 RC1, New Debian Builds

    Links for the day



  13. Like the EPO, Taiwan/China (SIPO) Harm SMEs With a Policy of Patent Maximalism Which Fosters Litigation, Not Innovation

    A culture of patent maximalism breeds plenty of lawsuits in China (good for the legal ‘industry’), but small companies that are innovative lose focus and resources, just like in Europe where SMEs are discriminated against



  14. Bristows Continues to Lie About Unitary Patent (UPC) in Britain Only to Get Rebutted in Comments, As Usual (Criticism Not Deleted Yet)

    The latest wave of posts (typically from Bristows) which herald an arrival of UPC in Britain are not just delusional but also constitute terrible legal advice



  15. The European Union Now Repeats Paid Propaganda From the EPO (Regarding the Unitary Patent)

    The EPO's push for UPC, which has already involved payments to media and academia, is spreading to the EU, which unfortunately fails to uphold the Rule of Law and the spirit of the EPC



  16. European Media Covers the Latest EPO Scandal and the EPO's Refusal to Obey Orders of a Court

    European media is starting to catch up with the latest from ILO and the great importance not only of the rulings but also the EPO's response to these



  17. Antonius Tangena From the European Patent Institute (EPI) 'Aids' Željko Topić's Appointment at the European Patent Office (EPO)

    An E-mail from Antonius (Tony) Tangena reveals a degree of coordination between the EPI and the EPO -- a potentially inappropriate action that can be seen as a cover-up attempt



  18. SUEPO Announces Protest, EPO Distracts From the Scandal, and Readers Spill the Beans

    Readers have sent some additional details regarding the EPO "backstory" that we wrote about this morning



  19. EPO Scandal Spills Over to Irish Media, So It's Time for the Backstory

    A lot more is being revealed by the media this week (regarding the EPO's "war on judges") and now that it's a more 'mainstream' subject we can shed light on the background to it



  20. Battistelli's EPO is Once Again Caught in Very Gross Violation of the European Patent Convention (EPC)

    The tyranny of the EPO is made abundantly clear for all to see -- ILO included -- but will there be consequences for repeated violations by Team Battistelli?



  21. Links 7/12/2017: Qt 5.10, ReactOS 0.4.7, Guix and GuixSD 0.14.0

    Links for the day



  22. Less Than 24 Hours Later the EPO Already Refuses to Obey Court Orders From ILO (Updated)

    As expected by realists (or pessimists), the EPO continues to act as though it's above the law and even judges suffer miscarriage of justice against them



  23. ILO Said Give the Judge His Job Back, But Christoph Ernst's Administrative Council Will Likely Let Him Go (Unemployed)

    Another potential EPO scandal in the making, as after waiting for 3 years the illegally-suspended judge might get his job back for only 3 weeks



  24. Watchtroll, AIPPI, Bristows and Others Keep Pushing Software Patents Agenda (in Spite of the Ban)

    Pressure groups and front groups of the patent microcosm (e.g. AIPPI) -- sometimes even the patent microcosm acting directly -- are still trying to make software patents legitimate, usually behind closed doors, e.g. in private events where only the patent microcosm can debate the subject (no software developers allowed)



  25. Meanwhile in Eponia, Tyrant Battistelli Must be Seeking Advice on How to Refuse to Obey Court's Orders (Again)

    People already speculate about how Battistelli will attempt to come up with excuses for noncompliance (and ongoing violation of the EPC as well as ILO code)



  26. Battistelli's 'Mole' Lucy Neville-Rolfe is Still Trying to Push Unitary Patent (UPC) Through in the United Kingdom

    Lucy Neville-Rolfe is back only to tell a bunch of lies about the UPC in British Parliament and Team UPC -- the prosecution 'industry' which has been driving this entire monster -- could not be happier



  27. ILO is 'Forcing' Team Battistelli to Compensate the Banned Judge and Give Him Back His Job

    ILO has, for a change, done some justice, but it comes three years too late and the compensation level (after salary got halved) is laughable, especially considering costs associated with legal fees and moral/reputational damage



  28. International Labour Organisation/ILOAT for UPC Yet Another Problem for Unitary Patent-Style Regime

    Seeing systematic misuse and abuse of justice at the EPO, people come to realise that Europe cannot afford to create a structure like the Unified Patent Court (UPC)



  29. CEIPI and EPO: The Story So Far

    Battistelli's dubious French connection and Christoph Ernst's obvious need to step in (not that he would ever do that)



  30. The Electronic Frontier Foundation (EFF) is Calling for Greater Transparency at USPTO and US Patent Courts

    Digital rights groups such as the Electronic Frontier Foundation still insist that it is difficult to tackle patents, challenges (e.g. at PTAB) and legal actions given the current tools and publicly available data


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