Pages
About Me
Links
Tags
PERSONAL 520
SPIRITUAL 416
LDS 312
BOOK OF MORMON 237
SCRIPTURES 154
STUDIO-JOURNEY 129
RELIGION 112
LINUX 79
COMPUTERS 65
LIFE 60
GENERAL CONFERENCE 46
GENTOO 39
MISCELLANEOUS 37
MUSIC 37
PROGRAMMING 33
CARS 29
MICROSOFT 23
FAMILY 23
AUDIO 21
I LOVE MY JOURNAL 18
FUN 15
CHILDREN 12
CURRENT EVENTS 10
NATURE'S WAY 10
VIDEO 9
DRM 9
CONEXM 7
BABBLINGS 7
PROVO CITY CENTER TEMPLE 6
FRIENDS 6
HEROD THE FINK 5
GAMES 5
COMPUTER HARDWARE 5
DRUMS 4
HAND OF GOD 3
ADVERSITY 3
KDENLIVE 3
AUDIO HARDWARE 3
GENERAL INSANITY 3
STUDIO 3
THANKS4GIVING 2
CATS 2
MY JOURNAL 1
POETRY 1
FOREVERGREEN 1
EVERYDAY THOUGHTS 1
GOSPEL 1
PARENTING 1
YOUTH CONFERENCE 1
CHURCH NOTES 1
POLITICS 1
RSS Feed
Subscribe!Tue - Sep 25, 2007 : 10:01 am
amazed
 |
|
|
|
|
rated 0 times |
Unbelievable Microsoft Excel Bug
Okay.
How long has Microsoft been in business? How long have they been the "best seller" of productivity suites? Oh yeah... and one last question: How many people have bought their Office software?
Yeah.... That's what I thought. LOADS, GRUNDLES, MILLIONS.
So.... I was reading my RSS feeds this morning when ran upon this slashdot article which basically tells a tale of Excel2003 not being able to multiply correctly.
From the article:
The example that first came to light is =850*77.1 — which gives a result of 100,000 instead of the correct 65,535. It seems that any formula that should evaluate to 65,535 will act strangely. One poster in the forum noted these behaviors: "Suppose the formula is in A1. =A1+1 returns 100,001, which appears to show the formula is in fact 100,000... =A1*2 returns 131,070, as if A1 had 65,535 (which it should have been). =A1*1 keeps it at 100,000. =A1-1 returns 65,534. =A1/1 is still 100,000. =A1/2 returns 32767.5."
This means the following:
Should you try to multiply 850 by 77.1, you will not get the correct answer, being 65,535, but instead you will get 100,000.
I feel sorry for anyone who has built their end-year revenue sheets in Excel and unwittingly graced themselves with an additional 34,465 dollars.
This bug is pretty freakin' crazy, if you ask me.
Makes me wonder what other bugs might be found in M$'s software, and also makes me very grateful I don't use any of it.
And yup, you bet yer bootie that openoffice.org doesn't have this bug.
How long has Microsoft been in business? How long have they been the "best seller" of productivity suites? Oh yeah... and one last question: How many people have bought their Office software?
Yeah.... That's what I thought. LOADS, GRUNDLES, MILLIONS.
So.... I was reading my RSS feeds this morning when ran upon this slashdot article which basically tells a tale of Excel2003 not being able to multiply correctly.
From the article:
The example that first came to light is =850*77.1 — which gives a result of 100,000 instead of the correct 65,535. It seems that any formula that should evaluate to 65,535 will act strangely. One poster in the forum noted these behaviors: "Suppose the formula is in A1. =A1+1 returns 100,001, which appears to show the formula is in fact 100,000... =A1*2 returns 131,070, as if A1 had 65,535 (which it should have been). =A1*1 keeps it at 100,000. =A1-1 returns 65,534. =A1/1 is still 100,000. =A1/2 returns 32767.5."
This means the following:
Should you try to multiply 850 by 77.1, you will not get the correct answer, being 65,535, but instead you will get 100,000.
I feel sorry for anyone who has built their end-year revenue sheets in Excel and unwittingly graced themselves with an additional 34,465 dollars.
This bug is pretty freakin' crazy, if you ask me.
Makes me wonder what other bugs might be found in M$'s software, and also makes me very grateful I don't use any of it.
And yup, you bet yer bootie that openoffice.org doesn't have this bug.