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. The EPO's Media Partners Like Les Echos Already Produce EPO Puff Pieces (Marketing/Stenography)

    EPO promotion disguised as reporting or journalism, as seen in the media partners of the EPO well before these partnerships even begin



  2. Unitary Microsoft: EPO Excludes People Who Are Not Microsoft Customers From UPC Participation

    The EPO just can't help providing special treatment to Microsoft, not only when it comes to patent applications but also when it comes to rejecting stakeholders/applicants who dare not become Microsoft customers



  3. Links 30/5/2016: Linux 4.7 RC1, Best Linux Distros

    Links for the day



  4. Make Nothing, Sue Everybody: The Reality of Patent Trolls Increasingly Understood by the 'Mainstream'

    New patent stories and even extensive coverage at PBS, which dedicated a whole program to these matters but failed to address the core issue, which is software patenting



  5. [ES] Advertencia: La Vigilancia de la EPO Surveillance Puede Haberse Convertido en Más Intrusiva

    BlueCoat, que la EPO usa para oprimir a sus empleados en sus premisas Europeas, acaba de ajustar más y hacerse más intrusiva y los empleados pueden estar en riesgo



  6. [ES] Tarjeta de Victima Termina en Otra Torpeza para Battistelli Seis de su Guardia Pretoriana

    Battistelli esta destruyéndo lo que queda de la reputación de la EPO (después de las décadas que le costó a ella construírla) mientras los medios continúan escrutinando su desastroso régimen



  7. [ES] La EPO esta Excelente, Dice Sitio de ‘Noticias’ Conectado a Ella

    Los caraduras de la ‘revista’ IAM, viejo aliado de la EPO, da la impresión a la gente de que en la EPO todo esta bien y dandy aunque claramente ese no es el caso



  8. New EPO Caricature: Nouveaux Garde-Vélo (New Bicycle Guards)

    A new cartoon poking fun at Battistelli's bicycles and the perceived threat these are under



  9. Battistelli's 'Special Relationship' With Portugal and the 'Inventor of the Year' Charade

    What makes Portugal rather unique when it comes to Mr. Battistelli, who is allegedly desperate for support from smaller countries whose vote is easier to 'win'



  10. Patent Lawyers' Marketing Dominates and Marginalises Meaningful Analyses of Software Patenting in the US

    In an effort to create demand for software patents again, patent lawyers produce a huge heap of so-called 'analyses' which piggyback just one single decision (the exception, not the norm)



  11. A Mix of Patent Aggression and Sanctions/Raids (Using Controversial Patents) Against East Asian Companies

    New stories that demonstrate patent protectionism and show how Western industry, which barely makes anything anymore, relies on patents (software and design patents included) and this self-serving patent regime perpetuates itself even in Asia, where almost everything is actually being manufactured (and often/increasingly designed/developed too)



  12. Rumour: Battistelli Wants to Extend the Term of Topić's EPO Appointment in Spite of Criminal Charges Against Him

    The EPO's 'ringleader', Mr. Battistelli, is trying to keep his confidants (like Mr. Minnoye and Željko Topić) together for several more years to come, even defying rules regarding retirement age



  13. Links 29/5/2016: NetBSD 7.0.1, Genode OS 16.05

    Links for the day



  14. [ES] La Gerencia de la EPO Bajo Creciénte Estres por las Autoridades Legales Croatas, Políticas Alemanas, y los Medios Italianos

    Las cosas no son color rosa como la calma relativa sugiere, y esperamos en las próximas semanas mayores eventos otros que la protesta en todas las sedes de la EPO a través de Europa



  15. [ES] Los Medios de Comunicación Comienzan a Informar al Público Europeo Acercas de las Desventájas de la UPC Mientras que la EPO Acelera su Cabildeo por Ratificación

    La vergonzósa promoción de la UPC por parte de la EPO da otro paso adelánte mientras que venues de la prensa Europea (incluso canales de televisión) comienzan a explorar el arreglo secreto que es negociado por los abogados de patentes (con clientes corpórativos) y las oficinas de patentes, no el público o cualquier grupo que represente los intereses del público en general



  16. [ES] Algunos Detalles Acerca de ¿Cómo el Presidente de la EPO Es Rumoreado Estar Comprando Votos, y el Porqué es Suficientemente Base Para un Despido Inmediato?

    Algo de información tras las cortinas y una detallada explicación de la dependencia finánciera sistemática, creada por Battistelli a un costode €13 millónes o más, la cuál evita una efectiva supervisión de Battistelli



  17. Mishi Choudhary and Mike Masnick Explain Why India Should Reject Software Patents

    Both an Indian activist-lawyer and a widely-recognised author from the US explain to Indians why over-reliance on patents -- and acceptance of patents on software in particular -- is a very bad idea



  18. Microsoft Boosters Pretend Microsoft Fights for Privacy While the Company Uses Malware Tactics to Put Keyloggers on Everyone's Computers

    In spite of malware-inspired tactics that should land Microsoft in courts of law all around the world (as a defendant), Microsoft-friendly circles pretend that the company fights for people's rights like privacy -- all this when Microsoft installs keyloggers on people's PCs without their consent and obviously against their will



  19. Battistelli's Assault on EPO Staff's Right to Strike in Relation to French Politics and That 'Bicycle' Pretext for Crackdowns

    The latest bicycle 'gossip' and how it's being used, based on expectations from EPO staff, to introduce further crackdowns on human/labour rights



  20. Vice-President of the EPO Under Investigation: Treason, Abuse, Violations, Giving and Receiving Bribes

    An English translation of documents involving the Organised Crime Section of the Criminal Police Department in Zagreb, where the Vice-President of the EPO faces criminal charges



  21. EPO Management Warns People About Scams When the EPO's Management is Itself Falling for Scams

    Jesper Kongstad, the Chairman of the Administrative Council of the European Patent Organisation, helps demonstrate that not even the EPO is intelligent enough to spot an obvious scam



  22. Links 28/5/2016: Wine 1.9.11, New Gentoo

    Links for the day



  23. Links 27/5/2016: Android for Raspberry Pi, Google Beats Oracle in Court

    Links for the day



  24. Warning: EPO Surveillance May Have Just Gotten Even More Intrusive

    BlueCoat, which the EPO uses to enable oppression inside its European premises, has just gotten even nastier and staff may be at risk



  25. Victim Card Ends up in Another Blunder for Battistelli and His Six Bodyguards

    Battistelli is wrecking what's left of the EPO's reputation (after decades it took the Office to earn it) as the media continues to scrutinise his appalling regime



  26. Italian Report About EPO Now Available in English

    An English translation of a TV program which earlier this month documented some of the glaring problems at the EPO



  27. The EPO is Doing Great, Says EPO-Connected 'News' Site

    IAM 'magazine', a longtime ally of the EPO, gives people the impression that all is fine and dandy at the EPO even though that's clearly not the case



  28. Microsoft Has Killed Nokia (and Its Own Mobile Ambitions), But Watch What it Does With Patents

    Microsoft announces many more layoffs, having already caused tremendous damage to the Finnish economy, and patents are left astray for Microsoft's favourite patent trolls to pick



  29. EPO Management Under Growing Stress From Croatian Law Enforcement Authorities, German Politicians, Italian Media

    Things are not as rosy as the relative calm may suggest, and in the coming weeks we expect some major events other than the protest at all EPO sites across Europe



  30. Microsoft, a Dead Company Walking, Resorts to Malware Tactics, Now Truly Indistinguishable From Crackers

    Microsoft is essentially taking over people's PCs and installing on them a large piece of malware, complete with keyloggers, against the will of these PCs' owners


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