• Welcome to TechPowerUp Forums, Guest! Please check out our forum guidelines for info related to our community.
  • The forums have been upgraded with support for dark mode. By default it will follow the setting on your system/browser. You may override it by scrolling to the end of the page and clicking the gears icon.

Microsoft Excel 2007 Calculation Issue Fix Available

M

malware

New Member
Joined
Nov 7, 2004
Messages
5,422 (0.72/day)
Location
Bulgaria
System Specs
Processor Intel Core 2 Quad Q6600 G0 VID: 1.2125
Motherboard GIGABYTE GA-P35-DS3P rev.2.0
Cooling Thermalright Ultra-120 eXtreme + Noctua NF-S12 Fan
Memory 4x1 GB PQI DDR2 PC2-6400
Video Card(s) Colorful iGame Radeon HD 4890 1 GB GDDR5
Storage 2x 500 GB Seagate Barracuda 7200.11 32 MB RAID0
Display(s) BenQ G2400W 24-inch WideScreen LCD
Case Cooler Master COSMOS RC-1000 (sold), Cooler Master HAF-932 (delivered)
Audio Device(s) Creative X-Fi XtremeMusic + Logitech Z-5500 Digital THX
Power Supply Chieftec CFT-1000G-DF 1kW
Software Laptop: Lenovo 3000 N200 C2DT2310/3GB/120GB/GF7300/15.4"/Razer
Two weeks ago, an issue involving the calculation of numbers around 65,535 and 65,536 has been found in Microsoft Excel 2007. If you try to calculate "=850*77.1" in Excel 2007, it will display an incorrect value, but if you then multiply the result by 2, you will get the correct answer. As of today, fixes for this issue in Excel 2007 and Excel Services 2007 are available for download here. Microsoft is in the process of adding this fix to Microsoft Update so that it will get automatically pushed to users running Excel 2007 or Excel Services 2007. Additionally, the fix will also be contained in the first service pack of Office 2007 when it is released. The release date has not yet been finalized.

View at TechPowerUp Main Site
 
Oh my goodness, such a simple math bug in Excel. That is EXTREMELY embarrassing for MS. How can this happen? Don't they use the same math libraries as previous Excel products. Do all Excel versions have the same problem?

The problem could be much bigger than the example shown. Is it just the "display-number" function bug, or is the bug in the variables/maths themselves? If so, ouch!
 
Duh! That happens to be tha maximim value of integers for a 16-bit OS!;)
Ever try to see what the default value for the last cell in Excel is? I'll give you two guesses...

I have to chuckle every time I see that one dudes sig that has the faux dictionary entry for Windows:

win-does: A 32-bit extention and graphical interface for a 16-bit patch for an 8-bit OS from a 2 bit company that can't stand one bit of competion.


...or something along those lines, I'm quoting from memory!

Just goes to show how much effort they actually put into futhering their software. Just making the "pig" prettier!

Cheers,

Bryan
 
"win-does: A 32-bit extention and graphical interface for a 16-bit patch for an 8-bit OS from a 2 bit company that can't stand one bit of competion."

win-does: A 32-bit extention and graphical interface based on a 16-bit patch of an 8-bit OS built for a 4-bit microprocessor coded by a 2 bit company that can't stand one bit of competion.

Correct version :toast:
 
Yes, even more appropriate!:laugh:
 
Bah, who cares- they fixed it. We can't expect software to be perfect. I personally love Excel 2007. I hated Excel before I use this version and found it tiresome to use. Now I find it far more intuitive and easy to work with. What can I say, I'm a fan of Office 2007.
 
No, I'm serious. We use Excel and VBA for doing all sorts of stuff, incl. financial analysis. I truely hope this is just a "display bug" and not a calc bug.
 
Im glad they got it fixed. one of the cool things about Office (not sure if openoffice.org or any of the others do this) is the calculator function in the program (word, excel, etc)
 
You must log in or register to reply here.
Back
Top