[Bug 114981] openoffice.org calc err502=sqrt(-1)

[bu...@apache.org]

https://issues.apache.org/ooo/show_bug.cgi?id=114981

Rob Weir <ro...@apache.org> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|UNCONFIRMED                 |RESOLVED
         Resolution|---                         |WONTFIX

--- Comment #5 from Rob Weir <ro...@apache.org> ---
Tested in AOO 3.4.1

=sqrt(-1) returns Err:502

Online help for error codes says:

"502 Invalid argument Function argument is not valid, for example, a negative
number for the root function."

This is correct.  Although one could imagine, maybe in an engineering context,
where returning i might be appropriate, in the vast majority of real uses,
taking the square root of a negative number would indicate an error in the
logic of the user's calculations, and an error is the best way to indicate this
condition.

In the exceptional case where complex numbers are intended, one could enter
formulas like this:

=IMSQRT(COMPLEX(-1;0))

-- 
You are receiving this mail because:
You are on the CC list for the bug.