[Libreoffice-bugs] [Bug 131652] New: chained MULTIPLE.OPERATIONS leaves effects of first set in the cell preceding "FormulaCell"

[bugzilla-daemon at bugs.documentfoundation.org]

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 at lists.freedesktop.org
          Reporter: xyhausen at 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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20200328/cb8b9048/attachment.htm>