[Upstream] =(-8)^(1/3)
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
LibreOffice |
Confirmed
|
Wishlist
|
|||
OpenOffice |
Unknown
|
Low
|
|||
libreoffice (Ubuntu) |
Fix Released
|
Medium
|
Unassigned | ||
openoffice.org (Ubuntu) |
Won't Fix
|
Low
|
Unassigned |
Bug Description
1) lsb_release -rd
Description: Ubuntu 11.04
Release: 11.04
2) apt-cache policy libreoffice-calc
libreoffice-calc:
Installed: 1:3.3.3-1ubuntu2
Candidate: 1:3.3.3-1ubuntu2
Version table:
*** 1:3.3.3-1ubuntu2 0
500 http://
100 /var/lib/
1:
500 http://
3) What is expected to happen is when one types in a cell:
=(-8)^(1/3)
one gets -2 as the answer.
4) What happens instead is one receives #VALUE! as the answer.
WORKAROUND: SIGN(X)
WORKAROUND: Use Excel in WINE.
Microsoft Office Excel 2003 (11.5612.6505)
apt-cache policy wine1.3
wine1.3:
Installed: 1.3.28-
Candidate: 1.3.28-
Version table:
*** 1.3.28-
500 http://
100 /var/lib/
1.
500 http://
Changed in openoffice: | |
status: | Unknown → Confirmed |
Changed in df-libreoffice: | |
importance: | Unknown → Medium |
status: | Unknown → New |
Changed in df-libreoffice: | |
importance: | Medium → Wishlist |
status: | New → Confirmed |
Changed in openoffice: | |
status: | Confirmed → Unknown |
description: | updated |
summary: |
- =(-8)^(1/3) + [Upstream] =(-8)^(1/3) |
Changed in openoffice: | |
importance: | Unknown → Low |
It looks like calc is unable to evaluate odd roots (a number raised to the 1/7,... etc). For instance if you type in as a formula
power of 1/3,1/5,
-8^(1/3), calc returns #VALUE when the answer should be -2. It looks like any
negative number you raise to a fractional exponent can't be evaluated. For
even roots this should be expected since imaginary values would result,
however odd roots should result in real values.