Computer ForumsComputers  

Go Back   Computer Forums > PC Technology Zone > Windows Operating Systems and Software

Closed Thread
 
LinkBack Thread Tools Display Modes
Old 09-26-2007, 03:48 PM   #1 (permalink)
superdave1984
Repeat Offender
 
superdave1984's Avatar
 
Join Date: Aug 2006
Location: Union City, TN
Posts: 1,733
Default Excel 2007 bug

Interesting for those of us who use Excel at work.

Excel 2007 Stricken with Bizarre Calculation Bug : Christopher Null : Yahoo! Tech

Excel 2007 Stricken with Bizarre Calculation Bug
Wed Sep 26, 2007 11:38AM EDT
See Comments (0)
Front and center in any "working guy" software arsenal is Microsoft Excel, the spreadsheet that's become a de facto industry standard. Earlier this week, reports surfaced of a strange error in Excel 2007 which caused calculations involving the number 65,535 (and thereabouts) to return wildly inaccurate results.

You can try it for yourself in Excel by multiplying 850 by 77.1. Excel will return 100,000 instead of 65,535. Similar operations that should return 65,535 will also come back incorrect, and there's a problem with 65,536, too. The problem is only present in Excel 2007; earlier versions of Excel are not affected.


Microsoft has traced the problem back to a floating point issue and how results are displayed within a cell in Excel. Microsoft says the calculation is actually done correctly, it's just that when it comes time to show the result on screen, Excel chokes. For example, if you multiply that "100,000" above by 2 and put the answer in a new cell, you'll get 131,070, not 200,000. However, this isn't reliable either: Try adding one and you get 100,001, not 65,536.

Microsoft says a fix is on the way and is in the final stages of testing. I'll update this post when the patch is available; hopefully Windows Update will also push it down automatically. We'll see.

LINK: Calculation Issue Update
__________________
superdave1984 is offline  
Closed Thread

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Students: Get Microsoft Office Ultimate 2007 for $59 Osiris Windows Operating Systems and Software 3 09-13-2007 05:17 PM
How do I remove all traces of NIS 2007? paco joe Virus - Spyware Protection / Detection 1 06-24-2007 09:53 AM
office 2002 to office 2007 wc000 Windows Operating Systems and Software 1 05-04-2007 07:40 AM
MS Offers Free Trial of Exchange Server 2007 Osiris Windows Operating Systems and Software 1 04-20-2007 04:51 PM
Exchange Server 2007 SP1 Beta Now Available Osiris Windows Operating Systems and Software 1 04-17-2007 08:00 PM


All times are GMT. The time now is 04:24 AM.


Powered by vBulletin® Version 3.7.1
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Content Relevant URLs by vBSEO 3.0.0 RC8