Hello Eike, after a quick test it seems that excel allows values up to 1E10. I'm open for suggestions but 1E5 is definitely much too low. We should choose a value between 1E10 and 1E14 if we really want to add an upper limit. I'm open for any suggestions.
Regards, Markus 2011/7/20 Eike Rathke <o...@erack.de> > Hi Markus, > > On Wednesday, 2011-07-20 12:03:08 +0200, Markus Mohrhard wrote: > > > this patch removes the check for the upper bound of the second parameter > of > > TINV. I checked the algorithm of TINV but there seems to be no reason to > > limit this number. > > > > The only problem is that for values greater than 1E14 the rounding error > > dramatically increases but in my opinion everyone who uses such large > > numbers should know about problems related to rounding and floating point > > arithmetic. > > People tend to use and trust such functions anyway.. > Does Excel impose some upper bound on that parameter? If so, we should > compare its output near such value with Calc's, and if sufficiently > "equal" maybe raise the bound. Another approach would be to compare with > Mathematica, Regina is known to love such work ;-) > > Eike > > -- > PGP/OpenPGP/GnuPG encrypted mail preferred in all private communication. > Key ID: 0x293C05FD - 997A 4C60 CE41 0149 0DB3 9E96 2F1A D073 293C 05FD > > _______________________________________________ > LibreOffice mailing list > LibreOffice@lists.freedesktop.org > http://lists.freedesktop.org/mailman/listinfo/libreoffice > >
_______________________________________________ LibreOffice mailing list LibreOffice@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice
