RE: Excel/gnumeric function compat test sheet.

[Uri David Akavia <uridavid netvision net il>]

Well, looking at the bitwise.xls file, I can see that and, or, xor are
definently not trivial. I will try to finish this file, before starting
to write lists. It seems easy because the framework is there.

On Thu, 2002-07-11 at 18:54, Uri David Akavia wrote:
> What about totally trivial functions (like AND/OR)?
> What about functions in Gnumeric that are excel compliant?
>
> Uri David
>
> On Thu, 2002-07-11 at 05:14, Phillip Shelton wrote:
> > I am still happy to look after this for a while.
> >
> > Have a look at the xls files under this directory.
> >  http://cvs.gnome.org/lxr/source/gnumeric/samples/excel/ 
> > This will give you a feel for the sorts of things that have been tested
> > already, and how we are testing then.  Start by looking at the operator.xls
> > file to see one way of testing the functions. Then move to address.xls to
> > see how I started tring to break the address function.  functions.xls was my
> > first effort. Anything that was updated this year is stuff that I have done.
> >
> > When you write up a spread sheet, have the collumn that has the answers that
> > your copy of XL gives, marked with the version please.
> >
> > You only need to write up the test in XL. Jody will run the test against
> > Gnumeric for us. (I hope ;-} ).
> >
> > So please send in the list of functions, and the one you want to start on.
> > At the moment it is all fair game.
> >
> > Is it worth a page on the web site Jody?  I do not have web space for it
> > myself.
> >
> >
> > -----Original Message-----
> > From: Uri David Akavia [mailto:uridavid netvision net il]
> > Sent: Thursday, 11 July 2002 5:10 AM
> > To: Gnumeric Mailing list
> > Cc: Jody Goldberg
> > Subject: Re: Excel/gnumeric function compat test sheet.
> >
> >
> > I am definently willing to help on this. However, I would prefer that it
> > be organized (in a web page or something). My idea is to get a list of
> > all functions (am willing to send Excel97 this weekend) and people could
> > claim functions. That way we won't duplicate effort or neglect uncommon
> > functions. If I claim a function, I know I can invest the time to try
> > and write good test cases. Perhaps we need the excel version. (BTW, what
> > is the policy for changes in functions - to what version does gnumeric
> > match? And functions that are just plain wrong in excel?)
> >
> > Anyway, I am willing to invest the time in this, but I hope that it will
> > be organized. Even without a web page, tell me who to send to, and stuff
> > like that. What would you want me to do? Check the functions in Excel or
> > both Gnumeric and Excel?
> > (I'm thinking writing test cases in excel, and writing the value next to
> > them, but I'm not about adding the gnumeric value)
> >
> > Yours, 
> >
> > Uri David Akavia
> >
> > On Tue, 2002-07-09 at 04:56, Jody Goldberg wrote:
> > > On Tue, Jul 09, 2002 at 11:32:34AM +1000, Phillip Shelton wrote:
> > > > So much for optimisum. I have not been able to work anywere near as fast
> > as
> > > > I would have liked to on this.  I at the moment do not have much more
> > than
> > > > those three functions done.
> > > >
> > > > -----Original Message-----
> > > > From: Phillip Shelton [mailto:shelton usq edu au]
> > > > Sent: Monday, 7 January 2002 5:02 PM
> > > > To: gnumeric list
> > > > Subject: Excel/gnumeric function compat test sheet.
> > > >
> > > >
> > > > I am slowly putting together a workbook that tests each function that
> > Excel
> > > > has.  It will be used to see how close gnumeric is to being a clone.  So
> > > > far, with some feedback from Jody, I have 66 tests for the first three
> > > > functions alphabetically from Excel 97.
> > > >
> > > > Please feel free to e-mail the list with any of your favourite functions
> > and
> > > > more specifically, excel sheets that have a test case that you want
> > tested
> > > > or you know currently don't work.
> > >
> > > This is an extremely important project for gnumeric and is ideal for
> > > users who may not want to start programming in C.   Please contact
> > > the list if you can help here.  The faster we can break the
> > > functions the sooner we can get them finished.
> > > _______________________________________________
> > > gnumeric-list mailing list
> > > gnumeric-list gnome org
> > > http://mail.gnome.org/mailman/listinfo/gnumeric-list
> >
> >
> > _______________________________________________
> > gnumeric-list mailing list
> > gnumeric-list gnome org
> > http://mail.gnome.org/mailman/listinfo/gnumeric-list
> > _______________________________________________
> > gnumeric-list mailing list
> > gnumeric-list gnome org
> > http://mail.gnome.org/mailman/listinfo/gnumeric-list
>
>
> _______________________________________________
> gnumeric-list mailing list
> gnumeric-list gnome org
> http://mail.gnome.org/mailman/listinfo/gnumeric-list