Created attachment 179987 [details]
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.