RE: Excel/gnumeric function compat test sheet.

[Uri David Akavia <uridavid netvision net il>]

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