On Mon, Aug 19, 2013 at 6:53 AM, Regina Henschel <[email protected]> wrote: > Hi Rob, > > Rob Weir schrieb: >> >> Moving this topic to its own thread. >> >> >> It should be possible to code a very thorough set of test cases in a >> spreadsheet, without using macros or anything fancy. Just careful >> reading of the ODF 1.2 specification and simple spreadsheet logic. >> > > Reading ODF1.2 specifications will not help for all functions. For example > the specification of the Bessel-functions rely on the fact, that interested > readers will find the definition other where, using the function names. [I > know you will say, write an issue and make a proposal ;)] >
That's fine. You rely on other sources that are more trusted than the standard or the implementations. Tables of special functions, for example, can be found in books like Abramowicz and Steugen. Also, the NIST's newer Digital Library of Mathematical Functions, which has a nice table of software applications that implement each function: http://dlmf.nist.gov/software/ The main point is that we should not rely on a self-referential definition of a function, automatically taking AOO behavior as the correct behavior. And I would not trust Excel in all cases, since there is ample published criticism of some of their numeric algorithms. So I'd rely more on specialized software. Regards, -Rob > Kind regards > Regina > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [email protected] > For additional commands, e-mail: [email protected] > --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
