Apache OpenOffice (AOO) Bugzilla – Issue 94487
Spreadsheet doesn't handle odd root's of negative numbers
Last modified: 2008-09-30 18:13:37 UTC
This was initially reported at https://bugs.launchpad.net/ubuntu/+source/openoffice.org/+bug/264345 Entering the following formula in to a spreadsheet cell results in a #VALUE error: =(-8)^(1/3) The correct (and expected) result is '-2'.
It is not as simple as you think. Please see my comment in issue 37129. *** This issue has been marked as a duplicate of 37129 ***
closing duplicate