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 sale Yet 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.

Permalink Mail Send this to a friend

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

PeterKraus said,

May 21, 2008 at 5:26 am

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

More Media Reports About Decline in Quality of European Patents (Granted by the EPO)

What the media is saying about the letter from Grünecker, Hoffmann Eitle, Maiwald and Vossius & Partner whilst EPO communications shift attention to shallow puff pieces about how wonderful Benoît Battistelli is
Beware Team UPC's Biggest Two Lies About the Unitary Patent (UPC)

Claims that a Unified Patent Court (UPC) will commence next year are nothing but a fantasy of the Liar in Chief, Benoît Battistelli, who keeps telling lies to French media (some of which he passes EPO money to, just like he passes EPO money to his other employer)
Diversity at the EPO

Two decades of EPO with 16-17 years under the control of French Presidents (and nowadays predominantly French management in general with Inventor Award held in France almost half the time) is "diversity at the EPO"
Orrin Hatch, Sponsored the Most by the Pharmaceutical Industry, Tries to Make Its Patents Immune From Scrutiny (PTAB)

Orrin Hatch is the latest example of laws being up for sale, i.e. companies can 'buy' politicians to act as their 'couriers' and pass laws for them, including laws pertaining to patents
Links 17/6/2018: Linux 4.18 RC1 and Deepin 15.6 Released

Links for the day
To Keep the Patent System Alive and Going Practitioners Will Have to Accept Compromises on Scope Being Narrowed

35 U.S.C. § 101 still squashes a lot of software patents, reducing confidence in US patents; the only way to correct this is to reduce patent filings and file fewer lawsuits, judging their merit in advance based on precedents from higher courts
The Affairs of the USPTO Have Turned Into Somewhat of a Battle Against the Courts, Which Are Simply Applying the Law to Invalidate US Patents

The struggle between law, public interest, and the Cult of Patents (which only ever celebrates more patents and lawsuits) as observed in the midst of recent events in the United States
Patent Marketing Disguised as Patent 'Advice'

The meta-industry which profits from patents and lawsuits claims that it's guiding us and pursuing innovation, but in reality its sole goal is enriching itself, even if that means holding science back
Microsoft is Still 'Cybermobbing' Its Competition Using Patent Trolls Such as Finjan

In the "cybersecurity" space, a sub-domain where many software patents have been granted by the US patent office, the patent extortion by Microsoft-connected trolls (and Microsoft's 'protection' racket) seems to carry on; but Microsoft continues to insist that it has changed its ways
Links 16/6/2018: LiMux Story, Okta Openwashing and More

Links for the day
The EPO's Response to the Open Letter About Decline in Patent Quality as the Latest Example of Arrogance and Resistance to Facts, Truth

Sidestepping the existential crisis of the EPO (running out of work and issuing many questionable patents with expectation of impending layoffs), the PR people at the Office choose a facts-denying, face-saving 'damage control' strategy while staff speaks out, wholeheartedly agreeing with concerned stakeholders
In the United States the Patent Trial and Appeal Board, Which Assures Patent Quality, is Still Being Smeared by Law Firms That Profit From Patent Maximalism, Lawsuits

Auditory roles which help ascertain high quality of patents (or invalidate low-quality patents, at least those pointed out by petitions) are being smeared, demonised as "death squads" and worked around using dirty tricks that are widely described as "scams"
The 'Artificial Intelligence' (AI) Hype, Propped Up by Events of the European Patent Office (EPO), is Infectious and It Threatens Patent Quality Worldwide

Having spread surrogate terms like “4IR” (somewhat of a 'mask' for software patents, by the EPO's own admission in the Gazette), the EPO continues with several more terms like “ICT” and now we’re grappling with terms like “AI”, which the media endlessly perpetuates these days (in relation to patents it de facto means little more than "clever algorithms")
Links 15/6/2018: HP Chromebook X2 With GNU/Linux Software, Apple Admits and Closes a Back Door ('Loophole')

Links for the day
The '4iP Council' is a Megaphone of Team UPC and Team Battistelli at the EPO

The EPO keeps demonstrating lack of interest in genuine patent quality (it uses buzzwords to compensate for deviation from the EPC and replaces humans with shoddy translators); it is being aided by law firms which work for patent trolls and think tanks that propel their interests
Grünecker, Hoffmann Eitle, Maiwald and Vossius & Partner Find the Courage to Express Concerns About Battistelli's Ugly Legacy and Low Patent Quality

The astounding levels of abuse at the EPO have caused some of the EPO's biggest stakeholders to speak out and lash out, condemning the Office for mismanagement amongst other things
IAM Concludes Its Latest Anti-§ 101 Think Tank, Featuring Crooked Benoît Battistelli

The attack on 35 U.S.C. § 101, which invalidates most if not all software patents, as seen through the lens of a Battistelli- and Iancu-led lobbying event (set up by IAM)
Google Gets Told Off -- Even by the Typically Supportive EFF and TechDirt -- Over Patenting of Software

The EFF's Daniel Nazer, as well as TechDirt's founder Mike Masnick, won't tolerate Google's misuse of Jarek Duda's work; the USPTO should generally reject all applications for software patents -- something which a former Commissioner for Patents at the USPTO seems to be accepting now (that such patents have no potency after Alice)
From the Eastern District of Texas to Delaware, US Patent Litigation is (Overall) Still Declining

Patent disputes/conflicts are increasingly being settled outside the courts and patents that aren't really potent/eligible are being eliminated or never brought forth at all
Links 13/6/2018: Cockpit 170, Plasma 5.13, Krita 4.0.4

Links for the day
When the USPTO Grants Patents in Defiance of 35 U.S.C. § 101 the Courts Will Eventually Squash These Anyway

Software/abstract patents, as per § 101 (Section 101) which relates to Alice Corp v CLS Bank at the US Supreme Court, are not valid in the United States, albeit one typically has to pay a fortune for a court battle to show it because the patent office (USPTO) is still far too lenient and careless
Buzzwords and Three-Letter Acronyms Still Abused by the EPO to Grant a Lot of Patents on Algorithms

Aided by Microsoft lobbying (with its very many patent trolls) as well as corrupt Battistelli, the push for software patenting under the guise of "artificial intelligence" ("AI") carries on, boosted by Battistelli's own "Pravda" (which he writes for), IAM Magazine
The United States is Far Better Off With the Patent Trial and Appeal Board (PTAB), So Why Do Lawyers Attack It?

The anti-PTAB lobby (which is basically the pro-troll or pro-litigation lobby) continues to belittle and insult PTAB, having repeatedly failed to dismantle it; in the meantime PTAB is disarming several more patent trolls and removing from the system patents which were granted in error (as well as the associated lawsuits)
Links 12/6/2018: Neovim 0.3 and Wine 3.10

Links for the day
Corrupt Benoît Battistelli Promotes Software Patents in IAM's Patent Trolls-Funded Event in the United States

With less than 3 weeks remaining for Battistelli's term he engages in gross revisionism, lobbying, and even looting of the patent office
The EPO's 'Expert' Georg Weber is Still Advocating Software Patents in Europe (But He Disguises Them Using Buzzwords)

The EPO's overzealous support for software patents continues unabated while the European Parliament looks the other way; this is part of the plan to expand patent scope in Europe and flood the continent with low-quality patents (causing a ruinous litigation boom like in China)
Battistelli's EPO is Outdoing North Korea When It Comes to Propaganda and Abuses Against Staff

Battistelli’s ‘scorched Earth’ approach — his sole legacy at the EPO — has left many workers in mental breakdowns (if not dead), but to celebrate the ‘Battistelli years’ three weeks before the end of his term the Office issues new propaganda material (pertaining exclusively to the Battistelli years, 2010 to 2018) while Battistelli-leaning media offers ‘cover’
IPBC, a Patent Trolls-Funded Event of IAM, is Advancing the Attacks on Section 101/Alice

Andrei Iancu preaches to the litigation 'industry' in an event (lobbying opportunity) organised by the patent trolls' lobby, IAM
PTAB Carries on Undeterred and Unabated, Courts Are Becoming Less Tolerant of Low-Quality Patents

With the shift away from the Eastern District of Texas (EDTX) and with PTAB applying growing levels of scrutiny to patents the likelihood that abstract patents will endure at the patent office or the courts is greatly diminished
Apple v Samsung Not Over, Hearing on a New Design Patent Trial Next Month

Apple's legal battles against phones that have Linux inside them simply aren't ending; meanwhile, there's more evidence that Apple would be wise to simply push for patent reforms, namely further restrictions on patent scope