Created attachment 150204 [details] 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.
Easier reproducer: =ABS(-1)*PI() or even just =PI() Apparently the structure is confused by PI() not having an argument. Same can be observed with =ABS(-1)*TRUE() Already in 5.3.7 (oldest I have), don't know if older.
Katarina Behrens committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/+/ad2acdfa36db00678f44f5cd69d687183f02a0bd%5E%21 tdf#124279: consider also functions with no arguments It will be available in 6.3.0. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Katarina Behrens committed a patch related to this issue. It has been pushed to "libreoffice-6-3": https://git.libreoffice.org/core/+/bf34e08f8d0d90939fea24d17f94434b0cd66439%5E%21 tdf#124279: consider also functions with no arguments It will be available in 6.3.0.1. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Katarina Behrens committed a patch related to this issue. It has been pushed to "libreoffice-6-2": https://git.libreoffice.org/core/+/e5a4746378202f8b599de11632b7c8772b735ea2%5E%21 tdf#124279: consider also functions with no arguments It will be available in 6.2.5. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.