[Bug 264345] Re: [Upstream] =(-8)^(1/3)
Confirmed resolved in at least LO 6.1.3.2. ** Changed in: libreoffice (Ubuntu) Status: Triaged => Fix Released -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/264345 Title: [Upstream] =(-8)^(1/3) To manage notifications about this bug go to: https://bugs.launchpad.net/df-libreoffice/+bug/264345/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 264345] Re: [Upstream] =(-8)^(1/3)
Launchpad has imported 12 comments from the remote bug at https://issues.apache.org/ooo/show_bug.cgi?id=37129. If you reply to an imported comment from within Launchpad, your comment will be sent to the remote bug automatically. Read more about Launchpad's inter-bugtracker facilities at https://help.launchpad.net/InterBugTracking. On 2004-11-14T08:30:53+00:00 Kmorning wrote: It looks like calc is unable to evaluate odd roots (a number raised to the power of 1/3,1/5,1/7,...etc). For instance if you type in as a formula -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. Reply at: https://bugs.launchpad.net/ubuntu/+source/openoffice.org/+bug/264345/comments/0 On 2004-11-15T09:05:53+00:00 Frank-l wrote: Hi, it's the same problem as described in Issue 24271. Therefore I close this one as double. Frank *** This issue has been marked as a duplicate of 24271 *** Reply at: https://bugs.launchpad.net/ubuntu/+source/openoffice.org/+bug/264345/comments/1 On 2004-11-15T09:06:09+00:00 Frank-l wrote: closed double Reply at: https://bugs.launchpad.net/ubuntu/+source/openoffice.org/+bug/264345/comments/2 On 2004-11-15T09:31:09+00:00 Frank-l wrote: Sorry, not a double. Frank Reply at: https://bugs.launchpad.net/ubuntu/+source/openoffice.org/+bug/264345/comments/3 On 2004-11-15T09:32:03+00:00 Frank-l wrote: Hi Eike, please have a look. Frank Reply at: https://bugs.launchpad.net/ubuntu/+source/openoffice.org/+bug/264345/comments/4 On 2004-11-15T10:23:06+00:00 Niklas-nebel wrote: This should be changed, but it's not inportant enough for target 2.0. Reply at: https://bugs.launchpad.net/ubuntu/+source/openoffice.org/+bug/264345/comments/5 On 2005-02-03T20:10:29+00:00 Cs213006 wrote: Bug repeated in OOo1.1.3/Linux and 680m74 on WinXP Reply at: https://bugs.launchpad.net/ubuntu/+source/openoffice.org/+bug/264345/comments/6 On 2007-02-09T23:28:58+00:00 Cbx550f wrote: Repeated in 2.0.3 Linux Reply at: https://bugs.launchpad.net/ubuntu/+source/openoffice.org/+bug/264345/comments/7 On 2007-02-22T22:29:35+00:00 Rb-henschel wrote: Why do you want to change it? It is dangerous to calculate like (-8)^(1/3)=-2. Look at this: (-8)^(1/3)=(-8)^(2/6)=((-8)^2))^(1/6)=64^(1/6)=2 If you use fractions in exponents and want to keep the rules for exponents, than you cannot allow negative base. And ^ and POWER calculate with exponents. There are other opinions, but then you are speaking of a cube root, which would be a new function in Calc. Reply at: https://bugs.launchpad.net/ubuntu/+source/openoffice.org/+bug/264345/comments/8 On 2007-02-22T22:30:42+00:00 Rb-henschel wrote: *** Issue 74782 has been marked as a duplicate of this issue. *** Reply at: https://bugs.launchpad.net/ubuntu/+source/openoffice.org/+bug/264345/comments/9 On 2008-09-30T18:12:56+00:00 Rb-henschel wrote: *** Issue 94487 has been marked as a duplicate of this issue. *** Reply at: https://bugs.launchpad.net/ubuntu/+source/openoffice.org/+bug/264345/comments/22 On 2009-04-15T04:42:30+00:00 Mikekaganski wrote: The bug persists in OOo 3.0.1/WinXP. It leads to incompatibility with MS Excel and thus, to difficulties in migration. The general math rule says that For odd values of n, every negative number has a real negative nth root (http://en.wikipedia.org/wiki/Nth_root). And it's not correct to spaculate that (-8)^(1/3)=(-8)^(2/6)=((-8)^2))^(1/6)=64^(1/6)=2. This speculation is a sort of sophism that masks the fact that there are more than one nth roots. When you make any transformations of powers you must take into account the possible loss of some roots or introduction of new roots. The correct result of sqrt(x) should be a multitude of two (possibly complex) numbers, not a single number. As we cannot return such a result in a spreadsheet we agree to see only positive answer, but it doesn't mean that we don't deserve to get correct negative
[Bug 264345]
*** Bug 50596 has been marked as a duplicate of this bug. *** -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/264345 Title: [Upstream] =(-8)^(1/3) To manage notifications about this bug go to: https://bugs.launchpad.net/df-libreoffice/+bug/264345/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 264345] Re: [Upstream] =(-8)^(1/3)
** Summary changed: - =(-8)^(1/3) + [Upstream] =(-8)^(1/3) -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/264345 Title: [Upstream] =(-8)^(1/3) To manage notifications about this bug go to: https://bugs.launchpad.net/df-libreoffice/+bug/264345/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 264345]
WORKAROUND: SIGN(X)*ABS(X)^(1/3) -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/264345 Title: =(-8)^(1/3) To manage notifications about this bug go to: https://bugs.launchpad.net/df-libreoffice/+bug/264345/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 264345]
The problem has been discussed in OOo too; https://issues.apache.org/ooo/show_bug.cgi?id=37129 If you will keep rule a^(r*s) = (a^r)^s you cannot allow negative basis a. Excel does not allow arbitrary fractions but tests only for unit fraction. That is not difficult. The highest such converted number is 1/(2^31-3) in Excel; 1/(2^31-1) fails. So the question is, whether LO should implement Excels behavior for easier converting from Excel. ODF1.2 says POWER(a,b), where a=0 and INT(b)!=b, is implementation-defined. in chapter 6.16.46. So the standard allows such solution. If you want to use arbitrary fractions, the class TOOLS_DLLPUBLIC Fraction from fract.hxx in tools might be useful. -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/264345 Title: =(-8)^(1/3) To manage notifications about this bug go to: https://bugs.launchpad.net/df-libreoffice/+bug/264345/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 264345] Re: =(-8)^(1/3)
** Bug watch added: issues.apache.org/ooo/ #37129 https://issues.apache.org/ooo/show_bug.cgi?id=37129 -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/264345 Title: =(-8)^(1/3) To manage notifications about this bug go to: https://bugs.launchpad.net/df-libreoffice/+bug/264345/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 264345] Re: =(-8)^(1/3)
** Changed in: openoffice Status: Confirmed = Unknown ** Changed in: openoffice Remote watch: OpenOffice.org Issue Tracker #37129 = issues.apache.org/ooo/ #37129 -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/264345 Title: =(-8)^(1/3) To manage notifications about this bug go to: https://bugs.launchpad.net/df-libreoffice/+bug/264345/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 264345] Re: =(-8)^(1/3)
** Description changed: 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 + 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 + 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 -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/264345 Title: =(-8)^(1/3) To manage notifications about this bug go to: https://bugs.launchpad.net/df-libreoffice/+bug/264345/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 264345]
Setting this to enhancement. We need to write our own Power function for this. At the moment we are using the c++ standard library functionn which results in an error for negative base and a non integral exponent. Code pointers: http://opengrok.libreoffice.org/xref/core/sc/source/core/tool/interpr5.cxx#1687 -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/264345 Title: =(-8)^(1/3) To manage notifications about this bug go to: https://bugs.launchpad.net/df-libreoffice/+bug/264345/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 264345]
Hm after an additional thought I'm not sure if it is really that simple to implement. At the point where we calculate the power we no longer have the information that we had a fraction as exponent. I wonder how excel solves this problem. I suspect that we would have the same problem with ixion. -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/264345 Title: =(-8)^(1/3) To manage notifications about this bug go to: https://bugs.launchpad.net/df-libreoffice/+bug/264345/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 264345] Re: =(-8)^(1/3)
** Changed in: df-libreoffice Status: New = Confirmed ** Changed in: df-libreoffice Importance: Medium = Wishlist -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/264345 Title: =(-8)^(1/3) To manage notifications about this bug go to: https://bugs.launchpad.net/df-libreoffice/+bug/264345/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 264345] Re: =(-8)^(1/3)
wont fix as per upstream ** Bug watch added: freedesktop.org Bugzilla #37271 https://bugs.freedesktop.org/show_bug.cgi?id=37271 ** Changed in: df-libreoffice Importance: Undecided = Unknown ** Changed in: df-libreoffice Status: Incomplete = Unknown ** Changed in: df-libreoffice Remote watch: None = freedesktop.org Bugzilla #37271 ** Changed in: df-libreoffice Importance: Unknown = Undecided ** Changed in: df-libreoffice Status: Unknown = New ** Changed in: df-libreoffice Remote watch: freedesktop.org Bugzilla #37271 = None ** Bug watch added: freedesktop.org Bugzilla #44076 https://bugs.freedesktop.org/show_bug.cgi?id=44076 ** Changed in: df-libreoffice Importance: Undecided = Unknown ** Changed in: df-libreoffice Status: New = Unknown ** Changed in: df-libreoffice Remote watch: None = freedesktop.org Bugzilla #44076 -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/264345 Title: =(-8)^(1/3) To manage notifications about this bug go to: https://bugs.launchpad.net/df-libreoffice/+bug/264345/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 264345] Re: =(-8)^(1/3)
Launchpad has imported 1 comments from the remote bug at https://bugs.freedesktop.org/show_bug.cgi?id=44076. If you reply to an imported comment from within Launchpad, your comment will be sent to the remote bug automatically. Read more about Launchpad's inter-bugtracker facilities at https://help.launchpad.net/InterBugTracking. On 2011-12-22T21:55:53+00:00 Björn Michaelsen wrote: 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 Reply at: https://bugs.launchpad.net/df- libreoffice/+bug/264345/comments/15 ** Changed in: df-libreoffice Status: Unknown = New ** Changed in: df-libreoffice Importance: Unknown = Medium -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/264345 Title: =(-8)^(1/3) To manage notifications about this bug go to: https://bugs.launchpad.net/df-libreoffice/+bug/264345/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 264345] Re: =(-8)^(1/3)
No new OOo releases in Ubuntu = Wont fix Needs upstream bug reference in LibreOffice = Incomplete ** Changed in: libreoffice (Ubuntu) Status: New = Won't Fix ** Also affects: df-libreoffice Importance: Undecided Status: New ** Changed in: df-libreoffice Status: New = Incomplete ** Changed in: openoffice.org (Ubuntu) Status: Triaged = Won't Fix -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/264345 Title: =(-8)^(1/3) To manage notifications about this bug go to: https://bugs.launchpad.net/df-libreoffice/+bug/264345/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 264345] Re: =(-8)^(1/3)
Fournier Frédéric, the issue you are reporting is an upstream one and it would be nice if somebody having it could send the bug to the developers of the software by following the instructions at http://wiki.documentfoundation.org/BugReport . If you have done so, please tell us the number of the upstream bug (or the link), so we can add a bugwatch that will inform us about its status. Thanks in advance. ** Description changed: - Binary package hint: openoffice.org + 1) lsb_release -rd + Description: Ubuntu 11.04 + Release: 11.04 - = Valeur! - h??? - =(-8)^(1/3)=-2 - sorry je ne parle pas anglais... + 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 ** Tags removed: ooo-calc ** Tags added: lo33 natty ** Changed in: libreoffice (Ubuntu) Importance: Undecided = Medium ** Changed in: libreoffice (Ubuntu) Status: Won't Fix = Triaged -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/264345 Title: =(-8)^(1/3) To manage notifications about this bug go to: https://bugs.launchpad.net/df-libreoffice/+bug/264345/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 264345] Re: =(-8)^(1/3)
** Also affects: libreoffice (Ubuntu) Importance: Undecided Status: New -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/264345 Title: =(-8)^(1/3) -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 264345] Re: =(-8)^(1/3)
** Changed in: openoffice Status: Unknown = Confirmed -- =(-8)^(1/3) https://bugs.launchpad.net/bugs/264345 You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 264345] Re: =(-8)^(1/3)
Thanks for your bug report, I have tested this under Ubuntu 8.04 with openoffice 2.4.1 and I can confirm this happens, please find attached a screenshot of this occurring. ** Attachment added: Screenshot.png http://launchpadlibrarian.net/18086472/Screenshot.png ** Changed in: openoffice.org (Ubuntu) Status: New = Confirmed -- =(-8)^(1/3) https://bugs.launchpad.net/bugs/264345 You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 264345] Re: =(-8)^(1/3)
FWIW, this works correctly in Excel. I'll forward this upstream when I get home tonight. ** Changed in: openoffice.org (Ubuntu) Importance: Undecided = Low -- =(-8)^(1/3) https://bugs.launchpad.net/bugs/264345 You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 264345] Re: =(-8)^(1/3)
** Tags added: ooo-calc -- =(-8)^(1/3) https://bugs.launchpad.net/bugs/264345 You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 264345] Re: =(-8)^(1/3)
** Bug watch added: OpenOffice.org Issue Tracker #94487 http://qa.openoffice.org/issues/show_bug.cgi?id=94487 ** Also affects: openoffice via http://qa.openoffice.org/issues/show_bug.cgi?id=94487 Importance: Unknown Status: Unknown -- =(-8)^(1/3) https://bugs.launchpad.net/bugs/264345 You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 264345] Re: =(-8)^(1/3)
This is reported upstream ** Changed in: openoffice Bugwatch: OpenOffice.org Issue Tracker #94487 = OpenOffice.org Issue Tracker #37129 ** Changed in: openoffice.org (Ubuntu) Status: Confirmed = Triaged -- =(-8)^(1/3) https://bugs.launchpad.net/bugs/264345 You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
Re: [Bug 264345] Re: =(-8)^(1/3) algo floating...
Here is an algorithm that gives you the smallest denominator of a floating number written in the form of fraction. with that you can solve the problem even if in the calculation of x ^ (n / m), n / m is transformed into a floating because you can find something iteration. I use that frac referrals factionnaire part of a number: frac(1.255)=0.255; is a recursive function: function d=donominateur(x) if (frac(x)-0.01 and frac(x)0.01) then d=1/x; else d=1/x*donominateur(1/x); end if end function I have one. ods of this algorithm to show that the algorithm works, we can show mathematically a recurrence but is a long time. The only flaw of this algorithm is the accuracy of the test: frac (x)-esp and frac (x) eps. the accuracy of x must be less than esp. I just send this. Ods on the list if you want? Le mercredi 03 septembre 2008 à 16:04 +, Martin Kretzschmar a écrit : I'm not an expert on computer arithmetic, but I would guess that this can only be solved using symbolic algebra, or by storing rational numbers as rationals, or by using complex arithmetic. Openoffice.org most likely uses plain floating point arithmetic, so cannot solve this. -- =(-8)^(1/3) https://bugs.launchpad.net/bugs/264345 You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
Re: [Bug 264345] Re: =(-8)^(1/3) algo floating...
Le vendredi 05 septembre 2008 à 08:14 +, Fournier Frédéric a écrit : Here is an algorithm that gives you the smallest denominator of a floating number written in the form of fraction. with that you can solve the problem even if in the calculation of x ^ (n / m), n / m is transformed into a floating because you can find something iteration. I use that frac referrals factionnaire part of a number: frac(1.255)=0.255; is a recursive function: function d=donominateur(x) if (frac(x)-0.01 and frac(x)0.01) then d=1/x; eratum then d=1; else d=1/x*donominateur(1/x); end if end function I have one. ods of this algorithm to show that the algorithm works, we can show mathematically a recurrence but is a long time. The only flaw of this algorithm is the accuracy of the test: frac (x)-esp and frac (x) eps. the accuracy of x must be less than esp. I just send this. Ods on the list if you want? Le mercredi 03 septembre 2008 à 16:04 +, Martin Kretzschmar a écrit : I'm not an expert on computer arithmetic, but I would guess that this can only be solved using symbolic algebra, or by storing rational numbers as rationals, or by using complex arithmetic. Openoffice.org most likely uses plain floating point arithmetic, so cannot solve this. -- =(-8)^(1/3) https://bugs.launchpad.net/bugs/264345 You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
Re: [Bug 264345] Re: =(-8)^(1/3)
no, what should be done on a mathematical point of view, if you want to calculate x ^ (n / m), is to do a test of parity on m: if m is even then if x 0 I can not calculate x ^ (n / m) because complex if m is odd then if X 0 then the calculation becomes (-x) ^ (n / m) Apply this method manually in Openoffice.org, you will see it works. Le mercredi 03 septembre 2008 à 16:04 +, Martin Kretzschmar a écrit : I'm not an expert on computer arithmetic, but I would guess that this can only be solved using symbolic algebra, or by storing rational numbers as rationals, or by using complex arithmetic. Openoffice.org most likely uses plain floating point arithmetic, so cannot solve this. -- =(-8)^(1/3) https://bugs.launchpad.net/bugs/264345 You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
Re: [Bug 264345] Re: =(-8)^(1/3)
Le jeudi 04 septembre 2008 à 17:58 +, Fournier Frédéric a écrit : no, what should be done on a mathematical point of view, if you want to calculate x ^ (n / m), is to do a test of parity on m: if m is even then if x 0 I can not calculate x ^ (n / m) because complex if m is odd then if X 0 then the calculation becomes (-x) ^ (n / m) erratum (-(-x)^(1/m))^n Apply this method manually in Openoffice.org, you will see it works. Le mercredi 03 septembre 2008 à 16:04 +, Martin Kretzschmar a écrit : I'm not an expert on computer arithmetic, but I would guess that this can only be solved using symbolic algebra, or by storing rational numbers as rationals, or by using complex arithmetic. Openoffice.org most likely uses plain floating point arithmetic, so cannot solve this. -- =(-8)^(1/3) https://bugs.launchpad.net/bugs/264345 You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 264345] [NEW] =(-8)^(1/3)
Public bug reported: Binary package hint: openoffice.org = Valeur! h??? =(-8)^(1/3)=-2 sorry je ne parle pas anglais... ** Affects: openoffice.org (Ubuntu) Importance: Undecided Status: New -- =(-8)^(1/3) https://bugs.launchpad.net/bugs/264345 You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 264345] Re: =(-8)^(1/3)
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 ** Changed in: openoffice.org (Ubuntu) Status: New = Incomplete -- =(-8)^(1/3) https://bugs.launchpad.net/bugs/264345 You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
Re: [Bug 264345] Re: =(-8)^(1/3)
it just me references: value and not -2 translated by Google Le mercredi 03 septembre 2008 à 14:56 +, Chris Coulson a écrit : 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 ** Changed in: openoffice.org (Ubuntu) Status: New = Incomplete -- =(-8)^(1/3) https://bugs.launchpad.net/bugs/264345 You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 264345] Re: =(-8)^(1/3)
I understand now! I can confirm this behaviour too, but I want to see if it is a documented limitation of the software. ** Changed in: openoffice.org (Ubuntu) Status: Incomplete = New -- =(-8)^(1/3) https://bugs.launchpad.net/bugs/264345 You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
Re: [Bug 264345] Re: =(-8)^(1/3)
I'm not an expert on computer arithmetic, but I would guess that this can only be solved using symbolic algebra, or by storing rational numbers as rationals, or by using complex arithmetic. Openoffice.org most likely uses plain floating point arithmetic, so cannot solve this. -- =(-8)^(1/3) https://bugs.launchpad.net/bugs/264345 You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs