Hi Niklas, On Thursday, 2008-06-26 14:30:11 +0200, Niklas Nebel wrote:
> Eike Rathke wrote: >> On Wednesday, 2008-06-25 23:42:16 +0200, Regina Henschel wrote: >>> I'm working on BETADIST. For certain inputs my version of that >>> function returns a value, which is near to 1. The formula in the >>> cell is =BETADIST(B$3;$B$1;$A8) with B3=0,999 and B1=1e-9 and >>> A8=1,5. The result should be shown as 1,00000000000000E+000 but it >>> is shown as 10,00000000000000E+000. >> >> I couldn't reproduce that, using a number format code >> 0.00000000000000E+000 >> >> Did you do something different? > > I don't see it with BETADIST either, but with "=1-7E-16" and that format > code, on Windows and Solaris/Sparc, but not Linux. Lovely :-( I filed http://www.openoffice.org/issues/show_bug.cgi?id=91100 Thanks for reproducing. Eike -- OOo/SO Calc core developer. Number formatter stricken i18n transpositionizer. SunSign 0x87F8D412 : 2F58 5236 DB02 F335 8304 7D6C 65C9 F9B5 87F8 D412 OpenOffice.org Engineering at Sun: http://blogs.sun.com/GullFOSS Please don't send personal mail to the [EMAIL PROTECTED] account, which I use for mailing lists only and don't read from outside Sun. Use [EMAIL PROTECTED] Thanks.
pgpSWrnJ44cEB.pgp
Description: PGP signature