https://bugs.freedesktop.org/show_bug.cgi?id=44076
Bug #: 44076
Summary: =(-8)^(1/3) should return -2
Classification: Unclassified
Product: LibreOffice
Version: LibO 3.4.4 release
Platform: Other
OS/Version: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Spreadsheet
AssignedTo: [email protected]
ReportedBy: [email protected]
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://us.archive.ubuntu.com/ubuntu/ natty-updates/main i386
Packages
100 /var/lib/dpkg/status
1:3.3.2-1ubuntu4 0
500 http://us.archive.ubuntu.com/ubuntu/ natty/main i386 Packages
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: Use Excel in WINE.
Microsoft Office Excel 2003 (11.5612.6505)
apt-cache policy wine1.3
wine1.3:
Installed: 1.3.28-0ubuntu1~ppa1~natty1
Candidate: 1.3.28-0ubuntu1~ppa1~natty1
Version table:
*** 1.3.28-0ubuntu1~ppa1~natty1 0
500 http://ppa.launchpad.net/ubuntu-wine/ppa/ubuntu/ natty/main i386
Packages
100 /var/lib/dpkg/status
1.3.15-0ubuntu5 0
500 http://us.archive.ubuntu.com/ubuntu/ natty/universe i386 Packages
--
Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
