> HEADS UP for Excel 2007
jaclaz
post Sep 29 2007, 09:56 AM
Post #1


Finder
***

Group: Advanced user
Posts: 1,379
Joined: 14-July 06
Member No.: 2


Italy


If you are using Excel 2007, there is a nasty bug in it for a certain range of numbers:
http://www.msfn.org/board/EXCEL_2007_CALCU...OR_t105089.html

http://bink.nu/news/microsoft-confirms-exc...lation-bug.aspx

http://www.accountingweb.co.uk/cgi-bin/ite...1023&f=1026

Though I don't think anyone uses Excel for vital calculations, I am surprised at the type and seriousness of the error. (IMG:http://www.boot-land.net/forums/style_emoticons/default/w00t.gif)


And yet another (if needed) confirmation to my theory:
QUOTE
This issue only exists in Excel 2007, not previous versions.


Latest does not always equate to "better". (IMG:http://www.boot-land.net/forums/style_emoticons/default/whistling.gif)

A technical analysis on the problem:
http://www.joelonsoftware.com/items/2007/09/26b.html

Of the various comments here:
http://blogs.msdn.com/excel/archive/2007/0...sue-update.aspx

this one struck me as being simple and to the point:
QUOTE (Thursday @ September 27, 2007 5:24 AM by Jerome)
That's why most of us are staying with Office 2000 and Windows XP.

Remember my boss was so mad when his wireless keyboard missed a key stroke. One hundred thousand became ten thousand could be a very serious mistake.

If you send out an Excel order form to order 850 pieces of $77.1 parts. The recipient open it with Excel 2007 and charge you $100,000. This is no fun.



For the record, OpenOffice.org is NOT affected by this bug, and since AFAIK it uses floating point math as well, the bla-bla-bla about this BUG being implicit in the way calculations are made appears like pure nonsense. (IMG:http://www.boot-land.net/forums/style_emoticons/default/unsure.gif)

jaclaz
Go to the top of the page
 
+Quote Post

Posts in this topic
- jaclaz   HEADS UP for Excel 2007   Sep 29 2007, 09:56 AM
- - Nuno Brito   I'm also a happy Open Office user. The latest...   Sep 29 2007, 11:30 AM
- - jaclaz   FYI, bugfix issued: http://www.msfn.org/board/EXCE...   Oct 16 2007, 09:47 AM
- - Nuno Brito   I already tried it last month - it took a loooong ...   Oct 16 2007, 12:21 PM

« Next Oldest · Websites · Next Newest »
 

Fast ReplyReply to this topicStart new topic

Members Who Viewed Topic Today ()

 

Display Mode: Switch to: Standard · Switch to: Linear+ · Outline

Track this topic · Email this topic · Print this topic · Subscribe to this forum

RSS Lo-Fi Version Time is now: 23rd January 2008 - 07:11 AM

MKPortal ©2003-2006 mkportal.it