[GLLUG] More Excel accuracy woes

[Clay Dowling]

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