• Welcome to TechPowerUp Forums, Guest! Please check out our forum guidelines for info related to our community.

Microsoft Excel 2007 Calculation Issue Fix Available

M

malware

New Member
Joined
Nov 7, 2004
Messages
5,422 (0.74/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
 
lemonadesoda

lemonadesoda

Joined
Aug 30, 2006
Messages
7,221 (1.08/day)
System Specs
System Name ICE-QUAD // ICE-CRUNCH
Processor Q6600 // 2x Xeon 5472
Memory 2GB DDR // 8GB FB-DIMM
Video Card(s) HD3850-AGP // FireGL 3400
Display(s) 2 x Samsung 204Ts = 3200x1200
Audio Device(s) Audigy 2
Software Windows Server 2003 R2 as a Workstation now migrated to W10 with regrets.
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!
 
D

Dr. Spankenstein

Joined
Feb 15, 2007
Messages
1,925 (0.30/day)
System Specs
Processor Intel C2D E8500 @ 4.25GHz (1.36V)
Motherboard Gigabyte GA-X38-DQ6
Cooling (Temporary) Tuniq Tower 120
Memory 2GB Transcend aXeram 1200+
Video Card(s) HIS HD3870 CF Volt modded
Storage 3 Seagate 320Gb Barracuda in an Intel Matrix Raid array
Display(s) Sony GDM-FW900 24" Widescreen CRT (a.k.a "The Shiznotch")
Case Ultra Aluminus Full Tower
Audio Device(s) onboard Intel HD audio
Power Supply PC Power & Cooling Silencer 750
Software XP MCE + Vista (HP) dual-boot
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
 
KennyT772

KennyT772

New Member
Joined
Dec 21, 2005
Messages
3,572 (0.52/day)
System Specs
System Name Raptor
Processor Intel E8400 Wolfdale @3600
Motherboard Asus P5Q-Pro LGA775
Cooling Zalman CNPS9700
Memory 1024mbx2 Crucial Ballistix DDR800
Video Card(s) XFX 9600GT
Storage Seagate 7200.11 500GB
Display(s) Acer AL2216Wbd and Acer AL1717
Case Gigabyte 3DAurora Black
Audio Device(s) Creative X-Fi Extreme Gamer Faitality
Power Supply OCZ GameXStream 500w
"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:
 
D

Dr. Spankenstein

Joined
Feb 15, 2007
Messages
1,925 (0.30/day)
System Specs
Processor Intel C2D E8500 @ 4.25GHz (1.36V)
Motherboard Gigabyte GA-X38-DQ6
Cooling (Temporary) Tuniq Tower 120
Memory 2GB Transcend aXeram 1200+
Video Card(s) HIS HD3870 CF Volt modded
Storage 3 Seagate 320Gb Barracuda in an Intel Matrix Raid array
Display(s) Sony GDM-FW900 24" Widescreen CRT (a.k.a "The Shiznotch")
Case Ultra Aluminus Full Tower
Audio Device(s) onboard Intel HD audio
Power Supply PC Power & Cooling Silencer 750
Software XP MCE + Vista (HP) dual-boot
Yes, even more appropriate!:laugh:
 
T

theonetruewill

Joined
Nov 12, 2006
Messages
2,996 (0.45/day)
System Specs
System Name COLOSSUS-MK4
Processor E8400 @4.4 GHz - FSB @550 MHZ
Motherboard Asus P5K Premium (Black Pearl)
Cooling Xigmatek HDT-S1283
Memory 2x1GB Geil BlckDrgn 800 @1158 5-5-5-18
Video Card(s) 8800GT 512MB @740/1782/2080
Storage Hitachi T7K250 250GB & 7200.10 Seagate 250GB
Display(s) Gateway FPD1975W 19" Widescreen
Case Antec 1200
Audio Device(s) Xi-FI Xtreme Audio
Power Supply CoolerMaster IGreen 500W
Software XP Home SP3
Benchmark Scores SuperPi: 10.563 Sciencemark: 2563.14
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.
 
lemonadesoda

lemonadesoda

Joined
Aug 30, 2006
Messages
7,221 (1.08/day)
System Specs
System Name ICE-QUAD // ICE-CRUNCH
Processor Q6600 // 2x Xeon 5472
Memory 2GB DDR // 8GB FB-DIMM
Video Card(s) HD3850-AGP // FireGL 3400
Display(s) 2 x Samsung 204Ts = 3200x1200
Audio Device(s) Audigy 2
Software Windows Server 2003 R2 as a Workstation now migrated to W10 with regrets.
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.
 
WarEagleAU

WarEagleAU

Bird of Prey
Joined
Jul 9, 2006
Messages
10,812 (1.61/day)
Location
Gurley, AL
System Specs
System Name Pandemic 2020
Processor AMD Ryzen 5 "Gen 2" 2600X
Motherboard AsRock X470 Killer Promontory
Cooling CoolerMaster 240 RGB Master Cooler (Newegg Eggxpert)
Memory 32 GB Geil EVO Portenza DDR4 3200 MHz
Video Card(s) ASUS Radeon RX 580 DirectX 12 DUAL-RX580-O8G 8GB 256-Bit GDDR5 HDCP Ready CrossFireX Support Video C
Storage WD 250 M.2, Corsair P500 M.2, OCZ Trion 500, WD Black 1TB, Assorted others.
Display(s) ASUS MG24UQ Gaming Monitor - 23.6" 4K UHD (3840x2160) , IPS, Adaptive Sync, DisplayWidget
Case Fractal Define R6 C
Audio Device(s) Realtek 5.1 Onboard
Power Supply Corsair RMX 850 Platinum PSU (Newegg Eggxpert)
Mouse Razer Death Adder
Keyboard Corsair K95 Mechanical & Corsair K65 Wired, Wireless, Bluetooth)
Software Windows 10 Pro x64
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.
Top