I am having the same problem. I have written a thermal storage program for heating a home with Off Peak electricity. It is recursive for tank temperature, with inputs and outputs going on at the same time. The operator must put in different values of volume and power to make sure there is enough energy to carry the home through the On-Peak heating time.
LibO works part of the time, then pops up with 200 Err:523 messages. Sometimes it will come back by changing a parameter, and sometimes is stays stuck. Haven’t found F9 to work.
Excel works all the time. Occasionally, it will get stuck, but it a manual calc command will get it going again.
I am preparing this program to go out to dealers for sizing calculations in the field. They are not EEs in computer science. I really don’t care whether this is a bug, mathematically irrational, or anything else. It works reliably in Excel and not in LibO. I would be happy if recalc worked from the menu pull down.
I like LibO for all the obvious reasons, but may have to abandon it because of “killer” points like this, [and the fact that Hyperlink quit working, which is another problem for my dealers]. Too many bugs/problems for my work flow.
OK, after the rant, I went to the preferences/LO calc/Calculate and changed the Iterations Steps to 1000 (Min Change is .001). If the iteration reaches its end point with no legal value, the Err message comes out. Expanding the range (Steps x Change) of the iterations seems to help. Maybe the LO programmers could detect illegal values and automatically reiterate until the numbers become legal.
One more. Sorry for the length. When I make a big change in a key number the interation crashes. Say the number is normally 1000 (gallons). If I type in 0, then I get #DIV/0! all over the place, which is normal. I them go back and put 1000 in the cell and hit return. Nothing happens. I go to Tools/Cell Contents/Recalculate and nothing happens - no matter how many time I go there (F9 doesn’t work, nor ctrl-shft-F9).
However, If I type 1000 in the cell again, it recalculates, giving me Err:523 the second time and the correct numbers the third time. So, it takes 3 recalcs to get back to normal. I cn live this this. But why doesn’t the recalc menu work? I would like to create a button on the screen that says “RECALCULATE”.
After going around and around with this, I finally discovered CMD-SHFT-F9, mentioned above and called “hard recalculate”, whatever that means. Any way, it does all the steps to get the iteration back to real numbers in one step. I am looking for an official definition of what it is.