https://bugs.documentfoundation.org/show_bug.cgi?id=148977
Bug ID: 148977
Summary: Multiple Operations does not work correctly if lots of
formulas are involved in the calculation
Product: LibreOffice
Version: 7.3.1.3 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Created attachment 179987
--> https://bugs.documentfoundation.org/attachment.cgi?id=179987&action=edit
Bug Reproducing Spreadsheet
I've encountered a bug with the "Multiple Operations" feature in calc, and I've
attached a spreadsheet to this that reproduces the bug.
This is a simple test spreadsheet to illustrate the problem. If you look in the
Good tab, you'll see that there are about 400 rows and this works correctly.
Each row does a simple calculation that references the result from the row
before it, along with the input variables X and Y that are defined at the top
of the spreadsheet.
The "Final" cell at the bottom in column A is just the last result found.
I created a list of X and Y values ranging from 0 to 6 and used the "Multiple
Operations" feature to fill in the results. So the table at the bottom should
be the same as if you manually entered the corresponding values for X and Y and
filled it in.
So the "Good" tab works just fine at around 400 rows.
The "Bad" tab is the exact same thing, only there are around 1900 rows. But the
calculation should be done the same way.
You'll notice that in this case, the resulting values are all filled in with 3.
This is incorrect and reflects the X and Y values that are currently set at the
top. So in this case it is not actually performing the Multiple Operations
function.
It only worked at all when I went into Options->Libreoffice Calc->Calculate and
enabled Iterations. If you uncheck Iterations then you'll see that the result
of Multiple Operations gives "Err:522", which doesn't really make sense as an
error.
I have also seen Err:504 using Multiple Operations which seems to be the same
bug, just presenting itself differently.
Thank you.
--
You are receiving this mail because:
You are the assignee for the bug.
