https://bugs.documentfoundation.org/show_bug.cgi?id=148982
Bug ID: 148982 Summary: Multiple Operations fail to work with long sequences of dependent cells Product: LibreOffice Version: Inherited From OOo Hardware: All URL: https://ask.libreoffice.org/t/calc-getting-list-of-out put-values-for-a-set-of-input-values/77238/ OS: All Status: UNCONFIRMED Severity: normal Priority: medium Component: Calc Assignee: libreoffice-bugs@lists.freedesktop.org Reporter: mikekagan...@hotmail.com CC: er...@redhat.com 1. In a new Calc document, put number '1' to A1. 2. Put '=A1+1' to A2. 3. Copy A2, and paste into A3:A300000 4. Check that A300000 shows '300000' 5. Put number '2' to B1 6. Select B1:C1 7. Run Data->Multiple Operations 8. Put 'A300000' to Formulas, 'A1' to 'Column input cell', and click OK. => Err:522 ("Circular reference") is shown in C1, and also in some bottommost cells in A column (A299999 and A300000) 9. Put cursor to C3, and hit F9 (recalculate) => more cells show Err:522 in column A (starting from A299600). 10. Delete B1:C1, and hit Ctrl+Shift+F9 (hard recalc) => Err:522 is still shown in A299600:A300000. 11. Save and reload => all cells in A show expected numbers again. This is repro also in OO0 3.3.0; in current LO, it doesn't depend on OpenCL and/or multi-threaded calculations. -- You are receiving this mail because: You are the assignee for the bug.