[GLLUG] More Excel accuracy woes

Michael George george at idealso.com
Tue Sep 25 08:15:31 EDT 2007


yup, I just read that.  My error...

I'm sure this isn't a bug.  I figure M$ is just looking toward the future.
 I mean, anyone who is calculating numbers that big is *surely* working
their way to 100,000.  So M$ just takes you there faster.  Predictive
branching.  Where do you want to go today?  We bring you the future... 
You know, all that brilliant stuff that they do.

On Tue, September 25, 2007 8:13 am, Clay Dowling wrote:
> Michael,
>
> If you read the original post, you'll see that the problem is indeed fixed
> in Office 2003.  It resurfaces in Office 2007.
>
> Clay
>
>
> Michael George wrote:
>> Huh, dunno...  I have Office 2003 here at work and Excel displays 65535
>> for those calculations.  Maybe a faulty MPU or an older version of Excel
>> is at fault.
>>
>> On Tue, September 25, 2007 2:44 am, Michael Rudas wrote:
>>> Michael Corral of the MDLUG list posted this information.  The linked
>> thread is VERY interesting... I wonder if this behavior is OOXML
>> compliant-- heh.
>>> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
>>> Last year I posted about Excel 2002 (and earlier versions) not being
>> able to calculate standard deviations correctly. Excel 2003 fixed that
>> particular problem.  But it looks like Excel 2007 has an even more
>> serious accuracy issue.  Take a look here:
>>> <http://groups.google.com/group/microsoft.public.excel/browse_thread/thread/2bcad1a1a4861879/2f8806d5400dfe22?hl=en#2f8806d5400dfe22>
>>>
>>> Apparently, a lot of calculations that come out to 65,535 will show
>> 100,000 to be the answer!  For example, 850*77.1.  Man, I sure hope no
>> one is depending on Excel for accurate calculations.
>>>
>>> I can confirm that StarOffice 7 does *not* have that bug. Even with the
>> easter eggs it still calculates accurately! :-)
>>> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
>>> This reminds me of that old saying about bureaucracy: " A camel is a
>> horse designed by a committee."
>>>
>>> -- Mikey
>>> _______________________________________________
>>> linux-user mailing list
>>> linux-user at egr.msu.edu
>>> http://mailman.egr.msu.edu/mailman/listinfo/linux-user
>>>
>>
>>
>> -Michael George
>>  Ideal Solution, LLC
>>
>>
>>
>> -Michael George
>>  Ideal Solution, LLC
>>
>> -Michael George
>>  Ideal Solution, LLC
>> _______________________________________________
>> linux-user mailing list
>> linux-user at egr.msu.edu
>> http://mailman.egr.msu.edu/mailman/listinfo/linux-user
>>
>
>
> --
> Lazarus Registration
> http://www.lazarusid.com/registration.shtml
>


-Michael George
 Ideal Solution, LLC


More information about the linux-user mailing list