September 28, 2007
— Purple Avenger You might want to consider using an abacus for a while until Microsoft gets this bug fixed...
...Yesterday evening we were alerted to an issue in Excel 2007 (and Excel Services 2007) involving calculation of numbers around 65,535. The first example that we heard about was =77.1*850, but it became clear from our testing as well as additional reports that this was just one instance where Excel 2007 would return a value of 100,000 instead of 65,535...65,535 100,000 pretty much the same in galactic terms I guess. Microsoft - "we enable your failure"
That's an incredibly odd bug. I can't imagine what warped code might accidentally cause that.
Posted by: Entropy at September 28, 2007 04:40 PM (HgAV0)
Nice going, guys.
Posted by: Dead Career Sketch at September 28, 2007 04:40 PM (NdG3x)
Posted by: buzzion at September 28, 2007 04:41 PM (TY0jZ)
Posted by: Kaitain at September 28, 2007 04:43 PM (4ep6C)
Cool! Maybe my bank uses Excel 2007. And I'll get an unexpected $34,465 windfall.
Awww.....who the fuck am I kidding? By the time I have $65,535 in the bank, milk will be $149.99 a gallon.
Posted by: Sticky B at September 28, 2007 04:50 PM (wkjFE)
Posted by: eman at September 28, 2007 04:50 PM (hc1YY)
I've never used excell, ever.
Everytime I ever found excell's options useful, I ignored excel, and I just linked it to a database in macro, because I know that there is more shit coming. Ain't done it in a number of years, but, really, anything that requires an excel template, will eventually be used in other ways.
Had a PC (fucking genius) and he said I should find my own answer, and he used excel for the batallion formats, but, it's more user friendly, and more easily managed in a DB. Not as efficient in terms of the 'puter, but less likely to be fucked up by stupid people.
Posted by: Wickedpinto at September 28, 2007 04:50 PM (QTv8u)
ABSOLUTE control through macro definition.
Posted by: Wickedpinto at September 28, 2007 04:51 PM (QTv8u)
Posted by: Um Yeeeeeaaaaahhhhhh at September 28, 2007 05:16 PM (voOdD)
I can. But then again I've looked at millions of lines of Microsoft code over the years and I know what they're capable of ;->
Usually its someone trying to be cute and get a little more performance out of something, but the elaborate scheme has certain cases where it doesn't work. I've seen them knowingly ship a "blue screen" generating operating system crash bug because the buggy code was faster than doing it right. I've heard their managers defend this in the past by saying "well, nobody would ever do ____ anyway". Of course, customers in the field do shit weirder and more retarded than programmers and testers would ever think of, so that sort of rationalization invariably fails in the field.
Posted by: Purple Avenger at September 28, 2007 05:29 PM (iuG/e)
Posted by: pajama momma at September 28, 2007 05:36 PM (Tbl5c)
When I was a Mudder, my specialty was breaking shit, Purple.
Everyone (most of the original wizzes, all of the "gods" and "demi-gods" had CS or EE histories,) knew what they were up to, but somehow this retarded lunatic was able to break that mud all the time.
Posted by: Wickedpinto at September 28, 2007 05:37 PM (QTv8u)
Programing by committee is just as bad a job as legislation by comittee, and for some reason they both have the same outcome.
Bigger committee's, bigger code/laws, bigger loopholes, that can do more damage.
I recommended, that an Alt mud be designed, and that the "gods" be reduced, and that the code be tested with people like me, and especialy one other person, who was a cheater, that cheats would worship, that guy found a way to turn a "joke" spell on the mud into a completely safe way of killing 99's. Fucking guy was VERY scientific as a player, and thats why he never became wiz, which is bullshit, that should be WHY he became wiz.
But hey, dorks have their own hierarchy too.
Posted by: Wickedpinto at September 28, 2007 05:41 PM (QTv8u)
Me too. I did a lot of development and performance work, but my true calling was breaking stuff. I have some unexplainable talent for sensing where bugs are. I would spend a short time (like 10 minutes) quickly inspecting the code for some module and develop a non-specific feeling about its general quality.
I don't know how to describe it, but in 10 minutes I could tell if there were going to be big problems in some module of thousands of lines of code.
I also have a very good hit ratio thinking "how might this fuck up?" and writing a quick test case to check out my suspicions. Usually I hit pay dirt about 60% of the time playing that game.
Posted by: Purple Avenger at September 28, 2007 06:16 PM (iuG/e)
It's a lousy display bug that doesn't change the calculated result, only the value shown in the cell.
Oh, and Bill Gates cock tastes like strawberry.
Posted by: Purple Fury at September 28, 2007 06:29 PM (G4KmV)
Which is no big deal because all spreadsheet users are of course blind, right?
Posted by: Purple Avenger at September 28, 2007 06:33 PM (iuG/e)
Posted by: Mike Z. at September 28, 2007 06:35 PM (GLMrI)
Posted by: wahhaw at September 28, 2007 06:39 PM (1UR5O)
Calm down. This is a floating point issue combined with a format conversion issue. Google IEEE floating point for more background.
Simply put, IEEE floating point numbers have, and have always had, a limited precision, which is a reasonable tradeoff for a larger dynamic range. It is inherent in the format to have some decimal real numbers that cannot be represented exactly in binary real number format.
When you convert the binary representation to text for display, the result you get depends upon the algorithm used to do the conversion. There are 16 values that give the display noted above. The numbers are (in hexadecimal double precision floating point notation) 40EF FFDF FFFF FFFA, 40EF FFDF FFFF FFFB, 40EF FFDF FFFF FFFC, 40EF FFDF FFFF FFFD, 40EF FFDF FFFF FFFE, 40EF FFDF FFFF FFFF, 40EF FFFF FFFF FFFA, 40EF FFFF FFFF FFFB, 40EF FFFF FFFF FFFC, 40EF FFFF FFFF FFFD, 40EF FFFF FFFF FFFE, and 40EF FFFF FFFF FFFF.
Posted by: Hank Rearden at September 28, 2007 06:57 PM (ES4Ca)
Posted by: eman at September 28, 2007 07:03 PM (hc1YY)
Posted by: 41EF FFFF FFFF FFFM at September 28, 2007 07:25 PM (uOvAE)
Posted by: Dennis P. Skea at September 28, 2007 08:44 PM (+WuRB)
Some sorta 16 bit binary somethingorother.
65,535 (decimal) = 1111111111111111 (binary) (16 "1"'s)
Posted by: Brendan at September 28, 2007 09:36 PM (2jQGY)
True, but I seriously doubt that's what's going on here.
My money is on some idiot code that's casting small integers to 16 bits when it shouldn't. The fact that this happens around 65,535 is highly suggestive.
Posted by: Dead Career Sketch at September 29, 2007 01:51 AM (NdG3x)
Therefore, it is broken.
Posted by: Dead Career Sketch at September 29, 2007 01:57 AM (NdG3x)
Undoubtedly. Microsoft compiler RTL guys figured out how to do this correctly 20+ years ago though. More like 25 years if you count the rebranded Lattice compiler MS was selling for a short while.
Posted by: Purple Avenger at September 29, 2007 03:20 AM (iuG/e)
None - the new standard is darkness.
Posted by: Purple Avenger at September 29, 2007 03:21 AM (iuG/e)
Posted by: No One of Consequence at September 29, 2007 03:59 AM (VZ3dS)
Posted by: not that ryan at September 29, 2007 06:18 AM (J3svr)
I use 2003 at home and am happy with it. I use 2007 at work because that's what came with the computer I bought from Dell, and Microsoft put in a goofy new interface for 2007 that I find pointless and annoying and makes it harder to do the stuff I want to do.
I'm guessing the new interface is more like how Vista does things.
BTW, if anyone can find the Excel 2007 equivalent for the Tools --> Options menu which was in every previous version of Excel I've ever used, I would appreciate you telling me what it is.
Posted by: OregonMuse at September 29, 2007 06:30 AM (dtQ3T)
I will never willingly upgrade to Vista, never, no never. I will use XP until either I die or Microsoft somehow makes it so it can't be sued, in which case I will then switch to some flavor of Linux, or a Mac.
Vista is a dog. It is basically a huge wad of DRM with bits of an operating system attached to it.
Posted by: OregonMuse at September 29, 2007 06:34 AM (dtQ3T)
should be: "so it can't be used"
Posted by: OregonMuse at September 29, 2007 06:35 AM (dtQ3T)
Posted by: OregonMuse at September 29, 2007 06:36 AM (dtQ3T)
I like Office 2007 better than previous versions, but that's just me. I use Excel, Word, and Access every day, and have for years. BTW, best deal evar: If you have an ".edu" email addy, you can get Office 2007 Ultimate for ~$60, which is considerably cheaper than any deal at my school. Check it out here:
Posted by: skh.pcola at September 29, 2007 07:26 AM (jFpwo)
Posted by: skh.pcola at September 29, 2007 07:27 AM (jFpwo)
Been running vista on my dev laptop for awhile. It is in no way "a dog".
The bullshit whining about Vista is the same exact shit that XP went through. Oh, its a resource hog. It spies on you. It sucks. Baaaaaaawwwwww. And it'll be the same shit five years from now when Vista is being superceded. "I'M NOT LEAVING VISTA FOR THIS NEW BLOATED SPYING OPERATING SYSTEMBAWWWWWW"
Posted by: mcgurk at September 29, 2007 07:53 AM (ajbe7)
Posted by: dave at September 29, 2007 08:07 AM (bGPt5)
Posted by: Purple Avenger at September 29, 2007 08:30 AM (77M+c)
Posted by: Christopher Taylor at September 29, 2007 09:31 AM (wmgz8)
"What a pointless upgrade, what was Mircrosoft thinking?"
That just like Apple, they could put out anything and the masses would flock to it whether it was better or not. I too will stick with Office 2003 until they pry my laptop from my cold, dead fingers.
Posted by: John F Not Kerry at September 29, 2007 11:07 AM (4gHqM)
MS is offering an XP downgrade for Vista users.
Is that true? I can hardly use any of my old programs anymore. Can't hardly download anythng off the internet. Nothing is compatible.
This may have been the same with XP, but that doesn't do me any good right now.
Posted by: pajama momma at September 29, 2007 11:17 AM (Tbl5c)
Posted by: chris edwards at September 29, 2007 11:21 AM (7Kaal)
You know what? Somehow a keystroke logger got onto my computer. I had over $3000 ripped off of me from paypal. While I was on the phone with paypal charges were going through. Paypal told me, huh, bummer for you, you shouldn't have given anyone your password.
Uh, I didn't. And I didn't open any phishing emails either.
Sister who's a mac user makes fun of me too. *sniff* *sob*
Posted by: pajama momma at September 29, 2007 11:48 AM (Tbl5c)
Posted by: Mike Z. at September 29, 2007 01:07 PM (GLMrI)
Posted by: Purple Avenger at September 29, 2007 01:50 PM (77M+c)
I pity all those game designers who are relying on Vista to run their new zowie games. Maybe they should have checked first.
Posted by: Christopher Taylor at September 29, 2007 03:50 PM (wmgz8)
I still run NT4, 3.5 and 3.51 server on some file servers in the Batcave.
Posted by: Purple Avenger at September 29, 2007 04:41 PM (77M+c)
No, it is not badly broken, since the calculation is correct within the limits of floating point limited precision math. The display problem will be fixed within days because it is the text output conversion which is slightly broken, and this is involves the office 2007 xml file format. How do I know this? The only values that give the error are the 16 IEEE floating point numbers listed. This can be verified by attaching a debugger to Excel 2007 and trapping the conversion function.
How many programmers read this blog? Am I the only one?
I have been a Microsoft beta tester for years. All of my computers, including my file server, run Vista without any trouble. I will say that Vista dislikes flaky hardware and/or flaky drivers. Oh yeah, I believe that most of the drivers supplied by Microsoft are not written by Microsoft.
Posted by: Hank Rearden at September 29, 2007 05:18 PM (ES4Ca)
Posted by: physics geek at September 29, 2007 06:18 PM (vKMFv)
through. Oh, its a resource hog. It spies on you. It sucks.
The only whining I recall about XP is that a good number of previously functioning devices no longer functioned -- which lasted about as long as it took the vendors to release upgraded drivers. Also, I don't recall any offers of "downgrading" Vista to XP, nor did Dell suddenly announce that they would sell you a new computer with NT or W2K instead of XP.
The fact is that Vista is getting rasberried up one side and down the other. I think it's going to be the new Windows ME
Posted by: OregonMuse at September 29, 2007 07:24 PM (dtQ3T)
Posted by: OregonMuse at September 29, 2007 07:26 PM (dtQ3T)
I've been writing assembler code for 30 years and am intimately familiar with IEEE 754.
It displayed egregiously wrong answers and you're trying to spin it like it didn't. We're not talking about a rounding/chop error way down in the fractional part.
The seriousness of a bug is related to how it can impact the customer, not how easy the code is to fix. This bug could cause people to make seriously wrong financial/engineering decision -- THAT means its serious.
Posted by: Purple Avenger at September 30, 2007 04:06 AM (bEmmq)
Posted by: Farmer Joe at September 30, 2007 09:53 AM (gDNGv)
62 queries taking 2.5406 seconds, 289 records returned.
Powered by Minx 1.1.6c-pink.