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

Microsoft Excel 2007 Calculation Issue Fix Available

Discussion in 'News' started by malware, Oct 12, 2007.

  1. malware New Member

    Joined:
    Nov 7, 2004
    Messages:
    5,476 (1.52/day)
    Thanks Received:
    956
    Location:
    Bulgaria
    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.

    Source: MSDN blog
     
  2. lemonadesoda

    lemonadesoda

    Joined:
    Aug 30, 2006
    Messages:
    6,252 (2.12/day)
    Thanks Received:
    963
    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!
     
  3. Dr. Spankenstein New Member

    Joined:
    Feb 15, 2007
    Messages:
    1,920 (0.69/day)
    Thanks Received:
    275
    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
     
  4. KennyT772

    KennyT772 New Member

    Joined:
    Dec 21, 2005
    Messages:
    3,585 (1.12/day)
    Thanks Received:
    103
    "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:
     
    Dr. Spankenstein says thanks.
  5. Dr. Spankenstein New Member

    Joined:
    Feb 15, 2007
    Messages:
    1,920 (0.69/day)
    Thanks Received:
    275
    Yes, even more appropriate!:laugh:
     
  6. theonetruewill New Member

    Joined:
    Nov 12, 2006
    Messages:
    2,996 (1.04/day)
    Thanks Received:
    240
    Location:
    London - Close your eyes and you'll see me
    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.
     
  7. lemonadesoda

    lemonadesoda

    Joined:
    Aug 30, 2006
    Messages:
    6,252 (2.12/day)
    Thanks Received:
    963
    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.
     
  8. WarEagleAU

    WarEagleAU Bird of Prey

    Joined:
    Jul 9, 2006
    Messages:
    10,797 (3.61/day)
    Thanks Received:
    546
    Location:
    Gurley, AL
    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)
     

Currently Active Users Viewing This Thread: 1 (0 members and 1 guest)

Share This Page