Interesting.... I got this piece of news that Microsoft Excel 2007 has a calculation bug from The Age as I was scouring for news from OZ-land. Anyway, I did try out the test and it did offer a glitch!!
Give it a go.
Test as follows,
- 77.1 * 850
- 10.2 * 6425
- 20.4 * 3212.5
According to David Gainer's latest blog entry, this bug is being fixed and should be available as a patch, downloadable later. I'm not sure if it would be bundled with the normal "Patch Tuesday" round of patches, but we'll see. ;-)
And just to show you that I wasn't kidding, here's the screenshot I took a while ago...
Click on the image for a larger pic...Looks like someone needs to teach Excel 2007 some maths? (^ ^)
I tested it just now. Yup.. that's a bug.
ReplyDeleteHere are some of the results. The first & second are wrong, the third is correct:
=(77.1*850) >> Result :100000
=(77.1*850)+1 >> Result :100001
=(77.1*850)-1 >> Result :65534
Hahaha
Hi Vincent,
ReplyDeleteWow.. Thanks for the interesting results too. Kekeke.. (^ ^)
My Excel program is four years behind time, which means the bugs have died of old age by now.
ReplyDeleteHi cirnelle,
ReplyDeleteLOL!! I think your current Excel program didn't suffer from this bug. Apparently, this only affects the new version. ;-)
It's probably due to the new code base or something.
there are many other bugs in word too... some are really interesting.
ReplyDeleteAnother interesting thing, but not a bug, the whole Office 2007 file system is now based on XML (and the new interface is called the RibbonX interface, which is much easier to manipulate and customize using XML.... easier than the old VBA method mah)
ReplyDeleteTry to rename any Excel 2007 file to ZIP. Example: abc.xlsx >> abc.zip
Then open it in Winzip and you'll be able to see all the XML files inside. Drag and drop any of the XML file to a text editor and you can see the contents. :)
So basically the new Office file is just a bunch of archived/compressed XML text files huh :D
ReplyDeletehi zewt,
ReplyDeleteyeap.. hehehehehe. care to share? (^ ^)
i like the spellcheck whenever i type someone's name as "Teh", it becomes "The" until I disable the item in the spellcheck. which is not a bug per se...
hi vincent,
ReplyDeleteyeap, office 2007 is so cool because of that. unfortunately, it's still not rolled out across the company as a whole just yet and so, we can't enjoy that flexibility.
so, i'm still saving my docs in compatible format. :-P
i'm a fan of XML for its portability, not for processing it. Hehehe.. Find me a faster parser!!
Interesting!! LOL at the microsoft excel thing! If students use that to do their assignments and fail to get the right answer, sure gonna sue microsoft till pok kai! hahahaha
ReplyDeleteHi Sabrina,
ReplyDeleteYep, those students working on their accounting, statistics and some spreadsheet-related assignments may run into some slight problems.
However, not to worry, am sure that there'll be a patch out soon. (^ ^)