<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><table border="1" cellspacing="0" cellpadding="8">
<tr>
<th>Bug ID</th>
<td><a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - calculation: odd roots from negative should work in general - e.g. '=(-8)^(2/3)' should return 4"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=137751">137751</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>calculation: odd roots from negative should work in general - e.g. '=(-8)^(2/3)' should return 4
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>Inherited From OOo
</td>
</tr>
<tr>
<th>Hardware</th>
<td>All
</td>
</tr>
<tr>
<th>OS</th>
<td>All
</td>
</tr>
<tr>
<th>Status</th>
<td>UNCONFIRMED
</td>
</tr>
<tr>
<th>Severity</th>
<td>normal
</td>
</tr>
<tr>
<th>Priority</th>
<td>medium
</td>
</tr>
<tr>
<th>Component</th>
<td>Calc
</td>
</tr>
<tr>
<th>Assignee</th>
<td>libreoffice-bugs@lists.freedesktop.org
</td>
</tr>
<tr>
<th>Reporter</th>
<td>newbie-02@gmx.de
</td>
</tr></table>
<p>
<div>
<pre>Description:
there was an old bug recently solved: <a class="bz_bug_link
bz_status_RESOLVED bz_closed"
title="RESOLVED FIXED - =(-8)^(1/3) should return -2"
href="show_bug.cgi?id=44076">tdf#44076</a>,
imho the fix is incomplete as it doesn't work for e.g. '=-8^(2/3)',
'=-8^(2/3)' and '=-27^(2/3)' are! 'calculateable terms', even in calc, if you
rearrange them to '=-8^2^(1/3)' or '=-8^(1/3)^2',
as @Christopher likes to keep that report closed and requested a new bug ...
here we go,
@xisco, pls. do not! close duplicate, acc. @Christoper it's a different issue
... and it's not resolved!
ok?
follow up to: <a class="bz_bug_link
bz_status_RESOLVED bz_closed"
title="RESOLVED FIXED - =(-8)^(1/3) should return -2"
href="show_bug.cgi?id=44076">tdf#44076</a>,
related: <a class="bz_bug_link
bz_status_RESOLVED bz_closed"
title="RESOLVED FIXED - Error taking Cube Root of Negative Number"
href="show_bug.cgi?id=69293">tdf#69293</a>, <a class="bz_bug_link
bz_status_NEW "
title="NEW - Powers of negative numbers highly inconsistent"
href="show_bug.cgi?id=121398">tdf#121398</a>,
P.S. an expanded task would be to solve the handling of (-8)^(2/6), calculate
straightforward and get 2, or reduce the fraction to '1/3' first and get -2?
there might be a math rule for that, but i missed it in school and couldn't
find it on the web ... a help might be that 4^1/2 is not! 2, but [-2/2],
Steps to Reproduce:
1. enter '=(-8)^(2/3)' in a cell, without the quotes,
2. hit enter
3. observe #NUM! as result
Actual Results:
#NUM!
Expected Results:
4
Reproducible: Always
User Profile Reset: No
Additional Info:
tested with:
Version: 7.1.0.0.alpha0+ (x64)
Build ID: 586f6abee92af3cdabdce034b607b9a046ed3946
CPU threads: 8; OS: Windows 6.1 Service Pack 1 Build 7601; UI render: default;
VCL: win
Locale: de-DE (de_DE); UI: en-US
Calc:</pre>
</div>
</p>
<hr>
<span>You are receiving this mail because:</span>
<ul>
<li>You are the assignee for the bug.</li>
</ul>
</body>
</html>