https://bugs.documentfoundation.org/show_bug.cgi?id=101238
Bug ID: 101238
Summary: MULTIPLE.OPERATIONS fails with Err:522 - not a
duplicate of 40626
Product: LibreOffice
Version: 4.3.3.2 release
Hardware: x86-64 (AMD64)
OS: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Created attachment 126502
--> https://bugs.documentfoundation.org/attachment.cgi?id=126502&action=edit
Spreadsheet to reproduce the issue
This is not a duplicate of bug 40626 because it does not require chaining of
MULTIPLE.OPERATIONS to rear its ugly head. Instead, attempting to run
MULTIPLE.OPERATIONS on a set of cells which contain a simple precedence chain
causes the bug to appear. An example is in the attached spreadsheet.
Expected behaviour: MULTIPLE.OPERATIONS succeeds and shows numeric results, no
matter whether cell D2 points to A399, A400, or any other cell above or below
in A1:A1000.
Actual behaviour: MULTIPLE.OPERATIONS fails with Err:522 if cell D2 points to
A400 or any cell below. Err:522 messages then continue to contaminate the
sheet, even if cell D2 it edited to point to A399 or above again. The only way
to recover is to enter "=A399" in cell D2, save and re-open.
First seen in Version: 4.3.3.2 Build ID: 430m0(Build:2)
Verified as still being a problem in Version: 5.1.4.2
Build ID: f99d75f39f1c57ebdd7ffc5f42867c12031db97a
It appears that this bug tickles a hardcoded limit. It makes parametric
exploration of data sets impossible. There is no obvious reason why
MULTIPLE.OPERATIONS would need to include a hardcoded limit for the depth of
the precedence chain. What it should do is to "stuff" a value in a column or
row input cell and collect the output from the formula cell once recalculation
has finished.
--
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
