[odf-discuss] Formula for Disaster

[Yoon Kit Yong]

On 11/07/07, Andreas J. Guelzow <aguelzow at pyrshep.ca> wrote:
> > http://www.openmalaysiablog.com/2007/07/mathematically-.html
> Interesting but unfortunately wrong.
>
> for the moment. The mathematical ceiling function also has always only a
> single argument so even OpenFormula/OOs differ from teh definition
> usually used in Mathematics. In fact Gnumeric may be the only program of
> those listed that implements the mathematical ceiling function

Hi Andreas,

Perhaps my description was not clear enough. What I tried to convey in
the blog post was that
1) OOo takes in minimum 2 params CEILING ( 2; 1 )
2) Gnumeric and KSpread allows for single params CEILING ( 2 )
3) OOo can take in 3 params for legacy support CEILING (2;1;1)

The good thing about a consensus based and inclusive standards
development process is the ability for the TC to cherry pick the best
of all worlds.

OpenFormula can call CEILING with one, two or three parameters,
depending on the requirements with consistent and mathematically
accurate results.

Its an example of how much more "superior" OpenFormula will ultimately
become over the MSOOXML's "copy 'n paste" effort in "Formula
Definition"

> Andreas J. Guelzow, Professor
> Dept. of Mathematical & Computing Sciences
> Concordia University College of Alberta


Regards!


yk.