RE: Excel/gnumeric function compat test sheet.

[Phillip Shelton <shelton usq edu au>]

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