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 22/12/2014: GNU/Linux at Sky News, Another Tizen Camera

    Links for the day



  2. IRC Proceedings: November 30th, 2014 – December 20th, 2014

    Many IRC logs



  3. Links 21/12/2014: China and Linux, GNOME Shell 3.15.3

    Links for the day



  4. The New Age of Games for UNIX/Linux But Not for Windows, Microsoft is Openwashing Windows-Only Games

    The world is moving to GNU- and Linux-powered platforms, so Microsoft withdraws GNU/Linux support from games it buys and starts openwashing its Windows-only games



  5. Microsoft Essentially Sends Malware to Windows and Bricks It

    Microsoft is once again bricking Vista 7, demonstrating lack of reliability or very low quality programming



  6. Microsoft Lays Off Staff, Cheapens Labour as More Companies Are Dumping Microsoft's Lock-in, NSA-Friendly Services, and Windows

    A look at some of Microsoft's latest woes, including an appeal for cheaper labour amid decrease in business



  7. Links 19/12/2014: Robolinux 7.7.1 LXDE, Red Hat Thriving

    Links for the day



  8. Another Microsoft Partner Markets Linux FUD Using Logo, Name, and Lies

    Microsoft's partner Alert Logic is trying to label a feature of Linux a security flaw and even makes marketing buzz for it



  9. Redmonk is Spreading Black Duck's Anti-GPL Talking Points After Payments From Black Duck, Microsoft

    CBS' ZDNet spreads the GNU-hostile narrative which comes from Redmonk, funded by Microsoft and Black Duck, citing Black Duck, which also comes from Microsoft and is a partner of Microsoft



  10. 'Good' Software Patents From EA Show Cases Where DRM is a Patent Infringement

    Where two evils collide the public benefits, or how some software patents discourage the use of DRM



  11. Richard Stallman: What Does It Mean for Your Computer to Be Loyal?

    New article from Richard Stallman



  12. Links 18/12/2014: LinuxQuestions.org Polls, Fedora for POWER

    Links for the day



  13. Links 16/12/2014: Google and ODF, Civilization: Beyond Earth Comes to GNU/Linux

    Links for the day



  14. Bill Gates' Pet Troll Intellectual Ventures is Collapsing as Founder Quits

    Intellectual Ventures founder leaves after an exceptionally large round of layoffs, despite [cref 77299 recent subsidies from Sony and Microsoft]



  15. Keeping Software Patents Out of Europe Following the Demise of Software Patents in the US

    Instability in the EPO seemingly prevents further expansion of patent scope, which is the subject of scrutiny of EPO staff



  16. Links 15/12/2014: OSI 2014 Annual Report, GPLv2 Court Test

    Links for the day



  17. Links 14/12/2014: Calligra 2.9 Beta, Krita 2.9 Beta

    Links for the day



  18. Software Patents Are Dying in the US, But Patent Lawyers Refuse to Admit It

    Patent lawyers continue to distort the reality of software patents' demise in the United States



  19. Links 13/12/2014: Android Wear “Lollipop”, European Commission and FOSS

    Links for the day



  20. Time to Take Microsoft Out of British Aviation Before Planes Crash Into Buildings

    London's mighty Heathrow Airport among those affected by a Microsoft-reliant air traffic control system which is not being able to properly recover from an outage, and not for the first time either



  21. News From France and Germany: Battistelli Under Fire, But Not Fired Yet, Just Firing His Opposition

    The régime headed by Benoît Battistelli and his criminal deputy continues to overthrow or pressure out everyone who is not 'loyal' to the régime



  22. Links 12/12/2014: Linux++, KDE Frameworks 5.5.0, Calligra 2.8.7

    Links for the day



  23. The USPTO is Broken: New Evidence Presented

    The scope of patents, as evidenced by some statistical figures and individual patents, shows that the USPTO is broken and must be reformed or dismantled



  24. US Patent Reform (on Trolls Only) More or Less Buried or Ineffective

    An update on efforts to reform the patent system in the United States, including the possibly imminent appointment of Michelle Lee to USPTO leadership role



  25. Software Patents in Canada Not Dead Yet

    Canada's patent status quo increasingly like that of the United States and Canadian giants like BlackBerry now pose a threat to software developers



  26. Dreaming of a Just Christmas: When a Third of EPO Walks Out to Revolt and European Judges Attack the EPO Over Abuses

    Information about the abuses of Battistelli et al. at the EPO are finally receiving wider coverage and increasing the strain on Battistelli's authoritarian reign



  27. Links 11/12/2014: Red Hat Enterprise Linux 7.1 Beta, Firefox 35 Plans

    Links for the day



  28. Ubuntu Core Announcement is Not About Microsoft and Hosting Ubuntu on Azure is Worse Than Stupid

    The power of media spin makes the idea of hosting Free software under the control of an NSA PRISM and back doors partner seem alluring



  29. France Gets Involved in Battistelli's Abuses in the EPO - Part XII (Updated)

    The EPO scandal has officially spilled over to France, where a French Senator got involved and starts asking serious questions



  30. Rolling of Heads Likely Imminent at EPO

    The European patent system is shaking as management breaks the rules, staff is protesting against the management every week, and charges of corruption resurface


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