EditorsAbout the SiteComes vs. MicrosoftUsing This Web SiteSite ArchivesCredibility IndexOOXMLOpenDocumentPatentsNovellNews DigestSite NewsRSS

03.19.08

Microsoft’s Excel Fails at Maths Again, New Warnings About OOXML Defects

Posted in ECMA, Formats, Microsoft, Office Suites, Open XML at 1:59 am by Dr. Roy Schestowitz

GNOME CalcA couple of nice items, one of which is a blog post and another one an article, have just been published. Together they illustrate both the ‘bugginess’ of OOXML and the office suite around which it’s actually modeled.

Let’s start with Rob Weir’s latest post, It sheds light on the huge amount of defects already found in OOXML. They remain largely unresolved while Microsoft rushes the process, breaking and bending the rules, as usual.

DIS 29500, Office Open XML, was submitted for Fast Track review by Ecma as 6,045 page specification. (After the BRM, it is now longer, maybe 7,500 pages or so. We don’t know for sure, since the post-BRM text is not yet available for inspection.) Based on the original 6,045 page length, a 5-month review by JTC1 NB’s lead to 48 defect reports by NB’s, reporting a total of 3,522 defects. Ecma responded to these defect reports with 1,027 proposals, which the recent BRM, mainly through the actions of one big overnight ballot, approved.

In case you believe that Microsoft’s OOXML is enough provided that you use Microsoft Office, question your beliefs again. For the third time in just months, a bug is find in the calculations done by Microsoft Excel. Watch in disbelief the outcome of poor quality control.

A bug in this week’s MS08-014 patch causes Excel to return zeroes instead of the correct number when certain types of macros are run within the program.

Depending on the domain in which Excel gets used, this could be critical. In some cases, such bugs can lead to death.

It was only days ago that we last identified a similar bug. Below we append several more, some of which may have expired for copyrights reasons for which only/mainly Associated Press is renowned.

Other incidents and reports of interest:

[1] Trouble In Microsoft World Over Calculator

The calculator post seems to be a reaction to a MS KnowledgeBase article titled Incorrect Calculator Results When You Use the Percent Key which implies the percent function screws up your results when you use it along with + or – in any combination. Way to go Microsoft!

[2] Microsoft Excel fails math test

Microsoft Corp.’s Excel 2007 spreadsheet program is going to have to relearn part of its multiplication table.

[3] Microsoft: Excel Bug Doesn’t Add Up

If you’ve been depending on your Microsoft Excel software to do your number crunching for you, you might want to grab a calculator and review your spreadsheets before you send the document out the door. That’s because the latest version of Excel is housing bugs that are dead set on ruining your reports.

[4] Mathematically Incorrect

So when it comes to comparing MSOOXML and ODF v1.0 on the basis of the inclusion of “Formula Definitions”, it becomes clear that the anti-ODF folk have not much to shout about. In fact MSOOXML’s “Formula Definition” is deficient and inaccurate.

[5] The Formula for Failure

As I’ve shown, in the rush to write a 6,000 page standard in less than a year, Ecma dropped the ball. OOXML’s spreadsheet formula is worse than missing. It has incorrect formulas that, if implemented according to the standard may cause loss of life, property and capital. This standard is seriously messed up. And shame on all those who praised and continue to praise the OOXML formula specification without actually reading it.

If you are aware of more such incidents and error, please shout out and share the knowledge.

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. Shamim said,

    March 19, 2008 at 3:42 pm

    Gravatar

    Thanks for including my article of Microsoft calculator confusion.

What Else is New


  1. Links 20/8/2014: Linux Event, GNOME Milestone

    Links for the day



  2. Corruption Watch: Microsoft Lobbying Designed to Kill Chile's Free Software Policy and Promote Microsoft With Subsidies, More Dirty Tricks Emerge in Munich

    icrosoft is systematically attacking migrations to GNU, Linux and Free software, using dirty tricks, as always



  3. Vista 8 Such a Disaster That Even Microsoft Cannot Cope With It, Vapourware Tactics Start Early

    Microsoft's Windows-powered services are failing and Windows gets bricked by Microsoft patches, whereupon we are seeing yet more of Microsoft's vapourware tactics (focusing in imaginary, non-existent versions of Windows)



  4. On BlackBerry and Other Patent Trolls

    A roundup regarding patent trolls, starting with the bigger and latest joiner, BlackBerry's new patents apparatus



  5. Links 19/8/2014: Humble Jumbo Bundle 2 Betrayal, Mercedes-Benz Runs GNU/Linux

    Links for the day



  6. BlackBerry -- Like Microsoft Nokia -- Could be the Next Patent Proxy Troll

    BlackBerry is restructuring for patent assertion (i.e. trolling) in the wake of some alliances with Microsoft



  7. After Microsoft's Soft Bribe Some Non-Technical Deputy Does Not Like Free Software, Microsoft-Linked Media Responds to This Non-News by Making Bogus Claims of Munich Leaving GNU/Linux (Updated)

    The subversive forces that have secretly been attacking Munich over its migration to GNU/Linux (Microsoft press, Gartner, and even HP) are back to doing it while China and Russia follow Munich's lead



  8. Gates Foundation CFO Quits and Debate About Revolving Doors Recalled Amid Systematic and Shrewd Bribery of Public Officials

    More officials step out of the Gates Foundation and their destination is not known yet; Gates continues to corrupt the public sector with his money so as to increase personal gain at taxpayers' expense



  9. Links 19/8/2014: GNU/Linux Raves and Alternative to Proprietary Voice Chat

    Links for the day



  10. Links 18/8/2014: Linux 3.17 RC1, Escalation in Ferguson

    Links for the day



  11. Gartner Group Advocates Using Defective Software With Back Doors

    Despite strong evidence that Microsoft has been complicit in illegal surveillance, Gartner continues to recommend the use of Windows and other espionage-ready Microsoft software



  12. The Microsoft Patent Trolls: Android Extortion, Vringo Versus Google, and Intellectual Ventures

    Roundup of news about patent aggression by Microsoft and some of its proxies



  13. Links 16/8/2014: Microsoft Linux, US Government Turns to Free Software

    Links for the day



  14. Links 15/8/2014: Reiser4 in Headlines Again, GNOME and KDE Events Finish

    Links for the day



  15. Links 14/8/2014: Kernel Summit Coming, KMix on KDE Frameworks 5

    Links for the day



  16. Shameless Microsoft Spin is Blaming China for Microsoft's Misconduct and Back Doors While Justifying Massive Losses in Hardware (Made in China)

    A new look at how Microsoft-friendly media takes negative Microsoft news and turns that news into some kind of scandals where Microsoft is the victim



  17. Microsoft Spin in the Media Evokes 'New Microsoft' and New Back Doors

    Some new examples of Microsoft boosters rewriting history, characterising Microsoft as a FOSS champion, and generally weak/shallow reporting on Microsoft's audio/video surveillance software



  18. Links 13/8/2014: GNU/Linux as Winner, New Snowden Interview

    Links for the day



  19. Reader's Article: Skype Spying Reaches New Levels of Blatant

    Forced 'upgrades' of Skype give useds [sic.] of Skype more than they asked for



  20. The Problem is Software Patents (and Scope), Not Patent Trolls Who Abuse Them Just Like Large Corporations

    Reminder of the dangers of losing sight of the real patent problem, which is the patents themselves, not necessarily those who use them



  21. Fraud in the USPTO and CAFC Helped Apple Launch Frivolous Patent Lawsuits Against Linux/Android, Based on New Withdrawals

    Inherent corruption in the US system has aided Apple's assault on east Asian electronics giants that use Linux at the core of their products



  22. Investigation Reveals That USPTO is Corrupt, Time to Abolish It or Annul Nearly a Million Patents

    Corruption is found at the heart of the USPTO and the USPTO works hard to hide it, despite attempt by whistleblowers to bring this corruption to light



  23. Links 13/8/2014: Red Hat Enterprise Linux 6.6 Beta, Tizen in Watches

    Links for the day



  24. Links 12/8/2014: Chromebooks Surge, OpenGL in the Headlines

    Links for the day



  25. Bill Gates is Profiting By Diverting Public Money to His Own Pocket and Reducing Wages

    Gates' lobbying for companies he is an investor of and for lower salaries inside companies he is investing in (and managing) comes as no surprise



  26. Microsoft is Still Attacking Open Standards, So Khronos Does Not Need the Microsoft Moles

    Having attacked the industry's document standard OpenDocument Format (ODF) while pretending to have 'embraced' ODF Microsoft is now pretending that it is eager to support OpenGL



  27. Another Depressing Look at the Patent Systems in the US and in Europe

    A roundup of news about patent monopolies and in particular the immense power wielded by giant multi-national corporations that steer the debate and acquire trans-Atlantic monopolies on ideas, always against citizens' interests



  28. Links 11/8/2014: DEFT 8.2, Linux Mint on Debian Stable

    Links for the day



  29. Links 9/8/2014: Knoppix 7.4.0, GNU Linux Libre 3.16

    Links for the day



  30. Links 8/8/2014: Qt a Separate Company Again, KDE Frameworks 5.1 Released

    Links for the day


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