Results 1 to 16 of 16

Thread: Excel can't multiply - Major bug found

  1. #1
    HEXUS.admin
    Join Date
    Apr 2005
    Posts
    31,709
    Thanks
    0
    Thanked
    2,073 times in 719 posts

    Excel can't multiply - Major bug found

    It's a given that every major software release, being the complex things that they are, has a few bugs here and there... but this multiplication bug in Excel 2007 is a pretty big oversight on Microsoft's part.
    Read more.

  2. #2
    sneaks quietly away. schmunk's Avatar
    Join Date
    May 2004
    Location
    Wiki Wiki Wild West side... of Sussex
    Posts
    4,424
    Thanks
    40
    Thanked
    163 times in 121 posts
    • schmunk's system
      • Motherboard:
      • Abit NF7-S v2.0
      • CPU:
      • AMD Athlon-M 2500+
      • Memory:
      • 1GB of Corsair BH-5 and 512MB of something else
      • Storage:
      • 160GB Seagate Barracuda
      • Graphics card(s):
      • ATI Radeon X800Pro, flashed to XT
      • PSU:
      • Hiper Type-M ~400W
      • Case:
      • Antec cheapy
      • Monitor(s):
      • AG Neovo F19 LCD
      • Internet:
      • Virgin Media 4MB/s

    Re: Excel can't multiply - Major bug found

    Which is why I'm sitting here using Office 2003 (for a very large employer), and probably will be for the next several years, and why at my last (even very larger) employer we were using a 2 generation old version of Lotus Notes, as whilst cost is a factor, reliability is always the most important factor in a business environment.

  3. #3
    It's good to be bad pauldarkside's Avatar
    Join Date
    Oct 2006
    Location
    Cornwall
    Posts
    2,930
    Thanks
    295
    Thanked
    378 times in 259 posts
    • pauldarkside's system
      • Motherboard:
      • ASUS Maximus VI Hero
      • CPU:
      • Intel Core i7-4770K & Corsair Hydro H80i
      • Memory:
      • Corsair Vengeance 32GB (4x8GB) 1600MHz DDR3
      • Storage:
      • Corsair Force GS 128GB, Crucial M500 480GB, WD Black 4TB
      • Graphics card(s):
      • EVGA GeForce GTX 780 Ti Superclocked
      • PSU:
      • Corsair Professional HX850W
      • Case:
      • Corsair Graphite 780T (White)
      • Operating System:
      • Windows 8.1 Pro 64bit
      • Monitor(s):
      • Asus ROG Swift PG278Q
      • Internet:
      • BT Infinity @ 78Mbps

    Re: Excel can't multiply - Major bug found

    I was always taught never to rely solely on a calculator - use your noggin to at least estimate the result

    I'm really surprised that automated testing didn't flag this bug. I wonder if it was present in the beta versions or has crept in via subsequent patching?
    My only concern is should I hide my true identity? A costume maybe?

    0iD: Plus weeing in it every now & again does it good
    scaryjim: 10" is just a little large to hold comfortably in one hand, which makes it a lot harder to tap, swipe and generally interact with.

  4. #4
    SiM
    SiM is offline
    Senior Member
    Join Date
    Apr 2006
    Location
    London
    Posts
    7,787
    Thanks
    299
    Thanked
    630 times in 419 posts
    • SiM's system
      • Motherboard:
      • P5K Premium
      • CPU:
      • Q6600
      • Memory:
      • 8GB PC2-6400 OCZ ReaperX + Platinum
      • Storage:
      • 3 x 320gb HD322HJ single platter in Raid 0
      • Graphics card(s):
      • PNY GTX285
      • PSU:
      • Corsair TX650W
      • Case:
      • Antec 1200
      • Monitor(s):
      • 2407-HC

    Re: Excel can't multiply - Major bug found

    Microsoft like to release software when its not ready - people pay to beta test it!

    When will people learn that Microsoft software/OS's are only ready after at least a year of bug fixes...

    (patiently waiting for Vista to be ready...)

  5. #5
    Comfortably Numb directhex's Avatar
    Join Date
    Jul 2003
    Location
    /dev/urandom
    Posts
    17,074
    Thanks
    228
    Thanked
    1,026 times in 677 posts
    • directhex's system
      • Motherboard:
      • Asus ROG Strix B550-I Gaming
      • CPU:
      • Ryzen 5900x
      • Memory:
      • 64GB G.Skill Trident Z RGB
      • Storage:
      • 2TB Seagate Firecuda 520
      • Graphics card(s):
      • EVGA GeForce RTX 3080 XC3 Ultra
      • PSU:
      • EVGA SuperNOVA 850W G3
      • Case:
      • NZXT H210i
      • Operating System:
      • Ubuntu 20.04, Windows 10
      • Monitor(s):
      • LG 34GN850
      • Internet:
      • FIOS

    Re: Excel can't multiply - Major bug found

    you get what you pay for

  6. #6
    Senior Member
    Join Date
    Jul 2006
    Posts
    1,457
    Thanks
    33
    Thanked
    75 times in 71 posts

    Re: Excel can't multiply - Major bug found

    "...using Excel 2007 and they're now checking all their formulas as this could have a major impact on their clients' spreadsheets." You think! Can't wait for my next tax bill (you can just bet that all those wonderful people down at the revenue offices are using Office 2007)

  7. #7
    Registered+
    Join Date
    Jul 2007
    Location
    Barnet, London
    Posts
    43
    Thanks
    0
    Thanked
    0 times in 0 posts
    • Chimaera_5's system
      • Motherboard:
      • Shuttle SN95G5 V2
      • CPU:
      • AMD 64 3500+ Sck 939
      • Memory:
      • OCZ 1GB 3200
      • Storage:
      • 160Gb Seagate
      • Graphics card(s):
      • XFX 6600GT
      • PSU:
      • Shuttle 300w
      • Case:
      • Shuttle SN95G5
      • Monitor(s):
      • BenQ 17in LCD
      • Internet:
      • Virgin Media 2meg

    Re: Excel can't multiply - Major bug found

    Quote Originally Posted by schmunk View Post
    Which is why I'm sitting here using Office 2003 (for a very large employer), and probably will be for the next several years, and why at my last (even very larger) employer we were using a 2 generation old version of Lotus Notes, as whilst cost is a factor, reliability is always the most important factor in a business environment.

    Absolutely, we're currently undertaking the upgrade to 2003, i can see the new OXML format pushing 2007 forward a bit but i can't see it within the next few years.

    The Vista upgrade is an interesting one because so many large companies use remote login software that employees who buy a new PC find they can't use as they're not Vista compatable.

  8. #8
    Member
    Join Date
    Jul 2005
    Location
    Wymondham, Norwich, Norfolk
    Posts
    190
    Thanks
    0
    Thanked
    1 time in 1 post

    Re: Excel can't multiply - Major bug found

    slightly worrying

  9. #9
    Senior Member charleski's Avatar
    Join Date
    Jul 2006
    Posts
    1,586
    Thanks
    7
    Thanked
    52 times in 45 posts

    Re: Excel can't multiply - Major bug found

    1, 2, 3, lots
    What more do you need?

  10. #10
    sneaks quietly away. schmunk's Avatar
    Join Date
    May 2004
    Location
    Wiki Wiki Wild West side... of Sussex
    Posts
    4,424
    Thanks
    40
    Thanked
    163 times in 121 posts
    • schmunk's system
      • Motherboard:
      • Abit NF7-S v2.0
      • CPU:
      • AMD Athlon-M 2500+
      • Memory:
      • 1GB of Corsair BH-5 and 512MB of something else
      • Storage:
      • 160GB Seagate Barracuda
      • Graphics card(s):
      • ATI Radeon X800Pro, flashed to XT
      • PSU:
      • Hiper Type-M ~400W
      • Case:
      • Antec cheapy
      • Monitor(s):
      • AG Neovo F19 LCD
      • Internet:
      • Virgin Media 4MB/s

    Re: Excel can't multiply - Major bug found

    Quote Originally Posted by vinnyT View Post
    "...using Excel 2007 and they're now checking all their formulas as this could have a major impact on their clients' spreadsheets." You think! Can't wait for my next tax bill (you can just bet that all those wonderful people down at the revenue offices are using Office 2007)
    I'll bet you eleventy billion pounds that they're not.

  11. #11
    Senior Member
    Join Date
    Aug 2005
    Location
    Surrey
    Posts
    299
    Thanks
    3
    Thanked
    4 times in 4 posts

    Re: Excel can't multiply - Major bug found

    Damm that Office 2007 roll out we just completed.......better go tell finance!

  12. #12
    Senior Member
    Join Date
    Aug 2005
    Location
    Surrey
    Posts
    299
    Thanks
    3
    Thanked
    4 times in 4 posts

    Re: Excel can't multiply - Major bug found

    however it jsut seem to "display" incorrectly, for example if you times that cell by somthing it give the correct result.
    Intel i5 2500K
    Gbyte Z68mx-ud3
    2x 4GB Corsair Vengance
    NEC ND3540A BLACK DVDR
    1TB HDD
    Sony SDM-HS75P 17" TFT
    Logitech Cordless Mouse and Keyboard LX700

  13. #13
    Senior Member
    Join Date
    Mar 2005
    Posts
    4,944
    Thanks
    171
    Thanked
    387 times in 314 posts
    • badass's system
      • Motherboard:
      • ASUS P8Z77-m pro
      • CPU:
      • Core i5 3570K
      • Memory:
      • 32GB
      • Storage:
      • 1TB Samsung 850 EVO, 2TB WD Green
      • Graphics card(s):
      • Radeon RX 580
      • PSU:
      • Corsair HX520W
      • Case:
      • Silverstone SG02-F
      • Operating System:
      • Windows 10 X64
      • Monitor(s):
      • Del U2311, LG226WTQ
      • Internet:
      • 80/20 FTTC

    Re: Excel can't multiply - Major bug found

    I'm currently trying to work out how I can get our budget increased by more than finance want by installing Excel 2007 on their machines.
    "In a perfect world... spammers would get caught, go to jail, and share a cell with many men who have enlarged their penises, taken Viagra and are looking for a new relationship."

  14. #14
    Registered+
    Join Date
    Sep 2007
    Posts
    63
    Thanks
    0
    Thanked
    1 time in 1 post

    Re: Excel can't multiply - Major bug found

    Im starting to think microsoft do this so that it can be fixed with a update
    And so anyone with a illegal version will have a broken version
    Last edited by smugla; 25-09-2007 at 08:19 PM. Reason: wrong wording

  15. #15
    Seething Cauldron of Hatred TheAnimus's Avatar
    Join Date
    Aug 2005
    Posts
    17,168
    Thanks
    803
    Thanked
    2,152 times in 1,408 posts

    Re: Excel can't multiply - Major bug found

    yes smugla, because that would make business sense!

    I'm guessing this is a problem with the new xloper structure, its one of those hideous extensions of an extention type things, i'd imagine the blame is there.

    However, someone at testing should be dusting of their CV right now.
    throw new ArgumentException (String, String, Exception)

  16. #16
    Folding Flunkie Webby's Avatar
    Join Date
    Sep 2007
    Location
    Wiltshire
    Posts
    2,323
    Thanks
    12
    Thanked
    245 times in 229 posts
    • Webby's system
      • Motherboard:
      • Gigabyte G33M-DS2R, Swiftech MCW30 Northbridge Cooler
      • CPU:
      • Intel Core 2 Duo E6550 @ 3.5GHz, Cooling D-Tek Fuzion V2
      • Memory:
      • 2GB OCZ Flex DDR2 PC2-9200 5-5-5-15 @ 1000MHz 4-4-4-12
      • Storage:
      • 2x 250GB WD SataII
      • Graphics card(s):
      • Sapphire HD4870 512MB, Cooling Swiftech MCW60
      • PSU:
      • Corsair HX520w
      • Case:
      • Silverstone Tremjin TJ06 - Modded for Water Cooling Goodness
      • Operating System:
      • Windows XP Pro SP3
      • Monitor(s):
      • 22" Widescreen Cibox C2201 (with DVI input)
      • Internet:
      • 8Mb/s ADSL

    Re: Excel can't multiply - Major bug found

    On the plus side it can divide to get 65,535!

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Twins Found Outside Hospital
    By EvilMunky in forum General Discussion
    Replies: 11
    Last Post: 07-12-2005, 02:19 PM
  2. ATI Catalyst 5.8 released
    By =TcQi= in forum Graphics Cards
    Replies: 17
    Last Post: 18-08-2005, 12:35 AM
  3. Just Been Shopping (in shops) and Found...
    By muddyfox470 in forum Retail Therapy and Bargains
    Replies: 11
    Last Post: 29-12-2004, 05:36 PM
  4. Sealed container found in search
    By Bunjiweb in forum General Discussion
    Replies: 5
    Last Post: 07-05-2004, 02:41 PM
  5. Goldeneye 'Citadel' level found!!
    By Jonlad in forum Gaming
    Replies: 7
    Last Post: 22-02-2004, 10:45 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •