It would be nice if the LO wiki link
http://help.libreoffice.org/Calc/Error_Codes_in_Calc had some
information about how error 502 is caused by sqrt(-1). Marking
Confirmed.
** Changed in: libreoffice (Ubuntu)
Status: New => Confirmed
--
You received this bug notification because you are a
NoOp, this bug is that Wishlist bug. As well, because this is still in
upstreams hands, and remains open, this bug should as well. If you want
to help, deal with the problem I already mentioned. Please stop Status
jockeying this bug.
** Changed in: openoffice.org (Ubuntu)
Status: Invalid =>
NoOp, this bug is that Wishlist bug. As well, because this is still in
upstreams hands, and remains open, this bug should as well. If you want
to help, deal with the problem I already mentioned. Please stop Status
jockeying this bug.
--
You received this bug notification because you are a member
Sigh... then file an RFE/Wishlist bug.
This is *not* a bug, but instead a documented action of both OOo and
LibreOffice. Further it is similar to the action of Microsoft Excel:
http://office.microsoft.com/en-us/excel-help/sqrt-HP005209269.aspx
Remark
If number is negative, SQRT returns the #NUM!
NoOp, regarding OOo, this is already upstreamed and being handled there,
hence your marking this Invalid is in error. Reversing.
** Changed in: openoffice.org (Ubuntu)
Status: Invalid => New
--
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed
NoOp, thank you for addressing this bug. Regarding LibreOffice, what is
fair is that the reasons why one gets the esoteric error err502 are
placed on the LibreOffice wiki
http://help.libreoffice.org/Calc/Error_Codes_in_Calc For example, this
can be caused because one places a negative number under
** Changed in: libreoffice (Ubuntu)
Status: New => Invalid
** Changed in: openoffice.org (Ubuntu)
Status: New => Invalid
--
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
https://bugs.launchpad.net/bugs/656575
Title:
Ca
Please see: Help|LibreOffice Help|Index|SQRT function:
SQRT
Returns the positive square root of a number.
Syntax
SQRT(Number)
Returns the positive square root of Number.
Number must be positive.
Example
=SQRT(16) returns 4.
=SQRT(-16) returns an invalid argument error.
if you wish to find the sq