https://bugs.documentfoundation.org/show_bug.cgi?id=124279
Bug ID: 124279
Summary: Function wizard structure tab shows inconsistent
intermediate results
Product: LibreOffice
Version: 6.2.2.2 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Created attachment 150204
--> https://bugs.documentfoundation.org/attachment.cgi?id=150204&action=edit
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.
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
