| 2008-09-03 13:55:51 |
Fournier Frédéric |
bug |
|
|
added bug |
| 2008-09-03 14:56:08 |
Chris Coulson |
openoffice.org: status |
New |
Incomplete |
|
| 2008-09-03 14:56:08 |
Chris Coulson |
openoffice.org: statusexplanation |
|
Whats wrong with '(-8)^(1/3)=-2'?
If you work back the other way (ie '(-2)^3'), we get (-2)*(-2)*(-2)=-8, so this is correct |
|
| 2008-09-03 16:04:00 |
Chris Coulson |
openoffice.org: status |
Incomplete |
New |
|
| 2008-09-03 16:04:00 |
Chris Coulson |
openoffice.org: statusexplanation |
Whats wrong with '(-8)^(1/3)=-2'?
If you work back the other way (ie '(-2)^3'), we get (-2)*(-2)*(-2)=-8, so this is correct |
I understand now! I can confirm this behaviour too, but I want to see if it is a documented limitation of the software. |
|
| 2008-09-30 14:03:26 |
Neil Munro |
bug |
|
|
added attachment 'Screenshot.png' (Screenshot.png) |
| 2008-09-30 14:04:42 |
Neil Munro |
openoffice.org: status |
New |
Confirmed |
|
| 2008-09-30 14:04:42 |
Neil Munro |
openoffice.org: statusexplanation |
I understand now! I can confirm this behaviour too, but I want to see if it is a documented limitation of the software. |
|
|
| 2008-09-30 14:18:12 |
Chris Coulson |
openoffice.org: importance |
Undecided |
Low |
|
| 2008-09-30 14:18:12 |
Chris Coulson |
openoffice.org: statusexplanation |
|
FWIW, this works correctly in Excel. I'll forward this upstream when I get home tonight. |
|
| 2008-09-30 16:41:32 |
Chris Coulson |
bug |
|
|
assigned to openoffice |
| 2008-09-30 17:47:57 |
Chris Coulson |
openoffice: statusexplanation |
|
|
|
| 2008-09-30 17:48:12 |
Chris Coulson |
openoffice.org: status |
Confirmed |
Triaged |
|
| 2008-09-30 17:48:12 |
Chris Coulson |
openoffice.org: statusexplanation |
FWIW, this works correctly in Excel. I'll forward this upstream when I get home tonight. |
This is reported upstream |
|
| 2009-01-08 20:44:59 |
Bug Watch Updater |
openoffice: status |
Unknown |
Confirmed |
|
| 2011-05-30 04:24:42 |
penalvch |
bug task added |
|
libreoffice (Ubuntu) |
|
| 2011-05-30 04:24:56 |
penalvch |
bug |
|
|
added subscriber Christopher M. Penalver |
| 2011-09-14 22:29:16 |
Björn Michaelsen |
libreoffice (Ubuntu): status |
New |
Won't Fix |
|
| 2011-09-14 22:29:28 |
Björn Michaelsen |
bug task added |
|
df-libreoffice |
|
| 2011-09-14 22:32:26 |
Björn Michaelsen |
df-libreoffice: status |
New |
Incomplete |
|
| 2011-09-14 22:32:35 |
Björn Michaelsen |
openoffice.org (Ubuntu): status |
Triaged |
Won't Fix |
|
| 2011-09-14 23:23:01 |
penalvch |
description |
Binary package hint: openoffice.org
=> Valeur!
hoooooooooooo???
=(-8)^(1/3)=-2
sorry je ne parle pas anglais... |
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 |
|
| 2011-09-14 23:23:24 |
penalvch |
tags |
ooo-calc |
lo33 natty |
|
| 2011-09-14 23:24:43 |
penalvch |
libreoffice (Ubuntu): importance |
Undecided |
Medium |
|
| 2011-09-14 23:24:43 |
penalvch |
libreoffice (Ubuntu): status |
Won't Fix |
Triaged |
|
| 2011-12-22 21:50:43 |
Björn Michaelsen |
bug watch added |
|
https://bugs.freedesktop.org/show_bug.cgi?id=37271 |
|
| 2011-12-22 21:50:43 |
Björn Michaelsen |
df-libreoffice: importance |
Undecided |
Unknown |
|
| 2011-12-22 21:50:43 |
Björn Michaelsen |
df-libreoffice: status |
Incomplete |
Unknown |
|
| 2011-12-22 21:50:43 |
Björn Michaelsen |
df-libreoffice: remote watch |
|
freedesktop.org Bugzilla #37271 |
|
| 2011-12-22 21:50:56 |
Björn Michaelsen |
libreoffice (Ubuntu): status |
Triaged |
Won't Fix |
|
| 2011-12-22 21:53:58 |
Björn Michaelsen |
df-libreoffice: importance |
Unknown |
Undecided |
|
| 2011-12-22 21:53:58 |
Björn Michaelsen |
df-libreoffice: status |
Unknown |
New |
|
| 2011-12-22 21:53:58 |
Björn Michaelsen |
df-libreoffice: remote watch |
freedesktop.org Bugzilla #37271 |
|
|
| 2011-12-22 21:56:47 |
Björn Michaelsen |
bug watch added |
|
https://bugs.freedesktop.org/show_bug.cgi?id=44076 |
|
| 2011-12-22 21:56:47 |
Björn Michaelsen |
df-libreoffice: importance |
Undecided |
Unknown |
|
| 2011-12-22 21:56:47 |
Björn Michaelsen |
df-libreoffice: status |
New |
Unknown |
|
| 2011-12-22 21:56:47 |
Björn Michaelsen |
df-libreoffice: remote watch |
|
freedesktop.org Bugzilla #44076 |
|
| 2011-12-22 21:57:04 |
Björn Michaelsen |
libreoffice (Ubuntu): status |
Won't Fix |
Triaged |
|
| 2011-12-22 22:37:18 |
Bug Watch Updater |
df-libreoffice: status |
Unknown |
New |
|
| 2011-12-22 22:37:18 |
Bug Watch Updater |
df-libreoffice: importance |
Unknown |
Medium |
|
| 2011-12-25 03:34:15 |
Bug Watch Updater |
df-libreoffice: status |
New |
Confirmed |
|
| 2011-12-25 03:34:15 |
Bug Watch Updater |
df-libreoffice: importance |
Medium |
Wishlist |
|
| 2011-12-31 23:03:44 |
Bug Watch Updater |
bug watch added |
|
https://issues.apache.org/ooo/show_bug.cgi?id=37129 |
|
| 2011-12-31 23:17:57 |
penalvch |
openoffice: status |
Confirmed |
Unknown |
|
| 2011-12-31 23:17:57 |
penalvch |
openoffice: remote watch |
OpenOffice.org Issue Tracker #37129 |
issues.apache.org/ooo/ #37129 |
|
| 2011-12-31 23:29:36 |
penalvch |
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://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 |
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: SIGN(X)*ABS(X)^(1/3)
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 |
|
| 2012-02-22 13:28:42 |
Björn Michaelsen |
summary |
=(-8)^(1/3) |
[Upstream] =(-8)^(1/3) |
|
| 2012-08-31 02:21:59 |
Marco Biscaro |
bug |
|
|
added subscriber Marco Biscaro |
| 2013-02-11 01:36:08 |
Bug Watch Updater |
openoffice: importance |
Unknown |
Low |
|
| 2018-12-23 22:41:12 |
penalvch |
libreoffice (Ubuntu): status |
Triaged |
Fix Released |
|
