<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 - Function wizard structure tab shows inconsistent intermediate results"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=124279">124279</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>Function wizard structure tab shows inconsistent intermediate results
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>6.2.2.2 release
</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>olivier.hallot@documentfoundation.org
</td>
</tr></table>
<p>
<div>
<pre>Created <span class=""><a href="http://bugs.documentfoundation.org/attachment.cgi?id=150204" name="attach_150204" title="image with formula and function wizard, structure tab">attachment 150204</a> <a href="http://bugs.documentfoundation.org/attachment.cgi?id=150204&action=edit" title="image with formula and function wizard, structure tab">[details]</a></span>
image with formula and function wizard, structure tab
The attached image shows the issue. The tree view displays/suggest wrong
figures.
Step to reproduce
1) Open Calc and place cursor in cell A1
2) enter formula =A2*SIN(EXP(A3)*PI()/6)^A4
3) fill a2, a3, a4 with values 10, 0.312 and 2 respectively.
3) look at the Structure tab of the Function wizard in the picture.
What's wrong?
The intermediate calculation are out of order and does not represent the true
intermediate computation.
The image shows in row 3 and 4 all the intermediate results of the calculation.
for example, the line EXP=3.14159... suggest the resulting exponential is
3.141159 (aka PI()), which is wrong.
The final result is correct but the structure of the formula does not shows
reliable information. It should be displaying the contents of row 4 in the
tree.
I suppose the tree view of the formula was designed to assist in debugging
complex formulas, which is not what is happening.</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>