Take some old bugs out, put some fresh ones in

This is a discussion on Take some old bugs out, put some fresh ones in within the A Brief History of Cprogramming.com forums, part of the Community Boards category; http://www.theregister.co.uk/2007/09/26/excel_2007_bug/ "It was working, honest guv, but we've since improved it."...

  1. #1
    and the hat of wrongness Salem's Avatar
    Join Date
    Aug 2001
    Location
    The edge of the known universe
    Posts
    32,340

    Take some old bugs out, put some fresh ones in

    http://www.theregister.co.uk/2007/09/26/excel_2007_bug/
    "It was working, honest guv, but we've since improved it."
    If you dance barefoot on the broken glass of undefined behaviour, you've got to expect the occasional cut.
    If at first you don't succeed, try writing your phone number on the exam paper.
    I support http://www.ukip.org/ as the first necessary step to a free Europe.

  2. #2
    Cat without Hat CornedBee's Avatar
    Join Date
    Apr 2003
    Posts
    8,892
    In the linked MSDN blog post, commenters are falling over each other complaining about IEEE floating point inaccuracies. It's rather funny to watch.
    All the buzzt!
    CornedBee

    "There is not now, nor has there ever been, nor will there ever be, any programming language in which it is the least bit difficult to write bad code."
    - Flon's Law

  3. #3
    Unregistered User Yarin's Avatar
    Join Date
    Jul 2007
    Posts
    1,534
    Only MS is this inventive.
    A class that doesn't overload all operators just isn't finished yet. -- SmugCeePlusPlusWeenie
    A year spent in artificial intelligence is enough to make one believe in God. -- Alan J. Perlis

  4. #4
    S Sang-drax's Avatar
    Join Date
    May 2002
    Location
    Göteborg, Sweden
    Posts
    2,072
    It's only six numbers out of almost 10^19 that don't work. Good enough, I say.
    Last edited by Sang-drax : Tomorrow at 02:21 AM. Reason: Time travelling

  5. #5
    Ethernal Noob
    Join Date
    Nov 2001
    Posts
    1,901
    Least they didn't xray anyone to death.

  6. #6
    Anti-Poster
    Join Date
    Feb 2002
    Posts
    1,399
    And the bug doesn't affect any formulas; it's just the display. Sure, it's a bug, but a fairly benign one. I just can't imagine how such a bug could pop up unless the display code is unnaturally convoluted.
    If I did your homework for you, then you might pass your class without learning how to write a program like this. Then you might graduate and get your degree without learning how to write a program like this. You might become a professional programmer without knowing how to write a program like this. Someday you might work on a project with me without knowing how to write a program like this. Then I would have to do you serious bodily harm. - Jack Klein

  7. #7
    Cat without Hat CornedBee's Avatar
    Join Date
    Apr 2003
    Posts
    8,892
    Which I wouldn't at all put past them. But I'm very puzzled, too.
    All the buzzt!
    CornedBee

    "There is not now, nor has there ever been, nor will there ever be, any programming language in which it is the least bit difficult to write bad code."
    - Flon's Law

  8. #8
    l'Anziano DavidP's Avatar
    Join Date
    Aug 2001
    Location
    Plano, Texas, United States
    Posts
    2,738
    yeah that seems like a very odd bug to come up unless the person who programmed the code was drunk....I mean....how hard is it to say:

    Code:
    product = a * b;
    output = product;
    Rather...they want to say:

    Code:
    product= a * b;
    if ( product== 65535 ) output = 100000;
    ....etc....
    Last edited by DavidP; 09-28-2007 at 07:12 PM.
    My Website

    "Circular logic is good because it is."

  9. #9
    S Sang-drax's Avatar
    Join Date
    May 2002
    Location
    Göteborg, Sweden
    Posts
    2,072
    The bug has to do with conversion from binary to decimal for printing. If the binary result ends up being very, very close to 65535, but smaller, the conversion will fail. Maybe it has to do with lots of carried 1s?
    Last edited by Sang-drax : Tomorrow at 02:21 AM. Reason: Time travelling

Popular pages Recent additions subscribe to a feed

Similar Threads

  1. North Carolina's (not so) fresh produce
    By Sebastiani in forum General Discussions
    Replies: 4
    Last Post: 07-01-2009, 11:43 PM
  2. Where to put local auxiliary functions?
    By draugr in forum C++ Programming
    Replies: 10
    Last Post: 03-17-2009, 08:46 PM
  3. Where to put files to be read in on a Mac
    By bassist11 in forum C Programming
    Replies: 3
    Last Post: 03-12-2009, 09:39 AM
  4. How to put a string in a 2 dimensional character array?
    By atif7865 in forum C Programming
    Replies: 2
    Last Post: 12-05-2008, 09:26 PM
  5. God
    By datainjector in forum A Brief History of Cprogramming.com
    Replies: 746
    Last Post: 12-22-2002, 11:01 AM

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21