https://issues.apache.org/ooo/show_bug.cgi?id=114981
Rob Weir <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|UNCONFIRMED |RESOLVED Resolution|--- |WONTFIX --- Comment #5 from Rob Weir <[email protected]> --- 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.
