AND fails because Gnumeric considers strings to be TRUE
Fixed. Gnumeric converted strings to truth values, not always
to TRUE, though. 0 would be FALSE, for example. Also
fixed the same issue for OR and XOR.
ATAN2 fails because Excel defines ATAN2(0,0) as #DIV/0! while Gnumeric
On Wed, Nov 30, 2005 at 12:51:31AM +, Nicholas Lamb wrote:
ADDRESS failed because Gnumeric always quotes sheet names
Interesting. I just did some work on ADDRESS to handle the special
case of
ADDRESS(-1,-1,,FALSE) // R[-1]C[-1]
being ok but
ADDRESS(-1,-1,,TRUE)
not being ok.