D&C GLug - Home Page

[ Date Index ] [ Thread Index ] [ <= Previous by date / thread ] [ Next by date / thread => ]

Re: [LUG] excell 2006.9999

 

On 25/09/2007, Pete Hatton <pete@xxxxxxxxxxxxx> wrote:
Quoting Tom Potts <tompotts@xxxxxxxxxxxxxxxxxxxx>:

> I've read there are problems with excel 2007
> Anyone have the misfortune to use it?
> =(8500 * 1) * 7.71 evaluates to 65535
>
> =850*(771/10) evaluates to 100000
>
> =850*(77.1) evaluates to 100000

I get 65535 for all 3 answers. Athough 100000 could be right if they
got some option on to round the number to the nearest 100000

It appears to be a buffer overflow error on x86-64 relating to the maximum value of an i386 integer.

--
Benjamin F. Goodger
~ design and ideas lab ~
-- 
The Mailing List for the Devon & Cornwall LUG
http://mailman.dclug.org.uk/listinfo/list
FAQ: http://www.dcglug.org.uk/linux_adm/list-faq.html