https://bugs.documentfoundation.org/show_bug.cgi?id=131652
Bug ID: 131652
Summary: chained MULTIPLE.OPERATIONS leaves effects of first
set in the cell preceding "FormulaCell"
Product: LibreOffice
Version: 6.0.5.2 release
Hardware: All
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: xyhau...@gmx.de
Description:
I will refer to the parameters of MULTIPLE.OPERATIONS as defined in ODF v1.2.
MULTIPLE.OPERATIONS(
Reference FormulaCell
Reference RowCell ; variable to be replaced, FormulaCell depends on
it
Reference RowReplacement ; new value for row
Reference ColumnCell ; variable to be replaced, FormulaCell depends on
it
Reference ColumnReplacement ; new value for col
)
If having a chained MULT.OP, where the "FormulaCell" is referencing a cell
doing the actual calculation (depending on "RowCell" and/or "ColumnCell"), one
can observe, that the "FormulaCell" shows the result of one of the last MULT.OP
replacement runs, instead of the result calculated from the default content of
"RowCell" and "ColumnCell".
The "RowCell" and "ColumnCell" keep their values, as expected.
Steps to Reproduce:
Check the attachment.
1. Set up a calculation/formula in cell "F" depending on at least 3 variables:
f(A,B,C,D).
2. Reference to "F" from another cell "R"
3. calculate MULT.OP(R, A, newA, B, newB), let's call the cell "M"
4. calculate a chained MULT.OP(M, C, newC, D, newD)
5. update/recalculate with F9 and STRG + ALT + F9
Actual Results:
The cells "F" and "R" will show f(newA,newB,C,D).
Expected Results:
The cells "F" and "R" should always show f(A,B,C,D).
Reproducible: Always
User Profile Reset: No
Additional Info:
Further cells referencing "F" or "R" will show f(A,B,C,D), which is actually
the correct value, but wrong in the sense that "F" and "R" show
f(newA,newB,C,D).
Version: 6.4.2.2 (x64)
Build-ID: 4e471d8c02c9c90f512f7f9ead8875b57fcb1ec3
CPU-Threads: 2; BS: Windows 10.0 Build 18362; UI-Render: Standard; VCL: win;
Gebietsschema: en-GB (de_DE); UI-Sprache: de-DE
Calc:
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
