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.
