RE: Excel/gnumeric function compat test sheet.

[Phillip Shelton <shelton usq edu au>]

If it is truly not finished then by all means finish it.

I must admit that I have not tried to open it in gnumeric lately.  And
having just down-loaded it and looked at it in XL, it does look damaged.

Jody, Is it damaged when you try to use it?  Or is it just the way it gets
mangled as it is down-loaded off LXR?  If I left it in that state when I
gave it to you then I am sorry.  Unfortunately I do not think I can fix it
as I no longer have the bitwise extension to XL. 

Uri David, please feel free to clean up any file that is damaged.

For the corner conditions on the trig functions I would start with
0,Pi/2,Pi,3pi/2 and 2pi.  We are just as interested in what these functions
do with bad input as with real numbers. Do not forget string numbers.  Have
a look at the file functions.xls to see how I tried to test two of the trig
fuctions.

Phill

-----Original Message-----
From: Uri David Akavia [mailto:uridavid netvision net il]
Sent: Monday, 15 July 2002 5:07 AM
To: Phillip Shelton
Cc: Gnumeric Mailing list
Subject: RE: Excel/gnumeric function compat test sheet.


Hello,
I was under the impression that it was unfinished because each cell in
gnumeric 1.0.6 says "=bitor(..)". Sorry about that.
I then noticed that the numeric values are different. Switching to
excel, I noticed that each cell says "bitwise.xls!BITOR(...)", so this
isn't gnumeric's fault. I just don't understand how the cells (in every
sheet) can say exacly the same but give different functions. Could you
tell me how?
(BTW, is the fact that gnumeric says only bitor a bug?)

Since it is apparently finished, I will start working on mathematical
functions, starting with trigonometry. I am not going to do intensive
testing of the mathematical behavior (unless you guys think I should)
since I believe the basic algorithm has been checked rigidly.
However, if someone has special values and/or general tips about
hyperbolic functions (I'm not very familiar with them) I'd be happy to
hear them. (you can send just to me, I'm not sure the list would care
about this). This may take a while, but I'll do my best.

Yours,
Uri David Akavia

On Fri, 2002-07-12 at 03:11, Phillip Shelton wrote:
> As you noticed from the bitwise.xls file, even our simple two single cell
> input functions need a lot of care when looking for edge conditions.
>
> What exactly were you going to do to 'finish' this file?
>
> Phillip 
>
> -----Original Message-----
> From: Uri David Akavia [mailto:uridavid netvision net il]
> Sent: Friday, 12 July 2002 6:26 AM
> To: Gnumeric Mailing list
> Subject: RE: Excel/gnumeric function compat test sheet.
>
>
> 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?
> _______________________________________________
> gnumeric-list mailing list
> gnumeric-list gnome org
> http://mail.gnome.org/mailman/listinfo/gnumeric-list