[Libreoffice-bugs] [Bug 124279] New: Function wizard structure tab shows inconsistent intermediate results

[bugzilla-daemon at bugs.documentfoundation.org]

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: libreoffice-bugs at lists.freedesktop.org
          Reporter: olivier.hallot at documentfoundation.org

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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20190322/e44c8ea8/attachment.html>