https://bugs.documentfoundation.org/show_bug.cgi?id=101238
m.a.riosv <[email protected]> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|REOPENED |NEW
Version|4.3.3.2 release |Inherited From OOo
OS|Linux (All) |All
--- Comment #3 from m.a.riosv <[email protected]> ---
Found here
https://ask.libreoffice.org/en/question/31343/lo-calc-multiple-operations-define-input/
the explanation about MULTIPLE.OPERATIONS parameters.
The meaning of the parameters of MULTIPLE.OPERATIONS are
1 Cell containing the prototype of the formula
2 Cell, which is used as first variable in the prototype
3 Actual value of the first variable
4 Cell, which is used as second variable in the prototype
5 Actual value of the second variable
If I'm not wrong in your formula 2 and 3 are inverted what leads to the
circular reference. =MULTIPLE.OPERATIONS(D$2;$F2;$D1) D1 is used as first
actual value the next it's D2 the cell for the formula.
The Err:522 appears when A400 or below is referenced in D2, in A400 or below
and in D2, doing a hard recalc the whole column A gets Err:522.
But indeed there is a different bug, because even deleting the whole
MULTIPLE.OPERATIONS formulas, Errs:522 don't disappear and the spreadsheet it's
not recalculated even with hard recalc {Ctrl+Shift+F9], even deleting D1 and D2
and A1.
Same issues with Aoo 4.1
Disabling OpenCl has not any effect.
Menu/Tools/Detective - Trace error doesn't show anything.
Please Eike could you take a look.
--
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
