# Manual calculation of circular references in Calc? [closed]

In Excel, I can set the workbook to automatically calculate, or manually calculate based on my input (e.g. with F9). As it is often used with circular references, this is very useful for creating, among other things, animations with graphs. Here are the relevant MS Excel options (v2007):

The key notion that I'm after is handling circular references based on iterations. For example, let's assume AutoCalculate is off (Tools->Cell Contents->AutoCalculate [unchecked]), that Iterations are enabled with a step of 1 (Tools->Options->Libreoffice Calc->Calculate), and that I first put this into cells A1 through B2:

```
| A | B
--------------
1 | dt =| 0.1
2 | t =| 0.0
```

I now change cell B2 to the formula "=B1 + B2":

```
| A | B
------------------
1 | dt =| 0.1
2 | t =| =B1 + B2
```

But because AutoCalculate is off, the value shown should remain 0.0. Despite the circular reference, if I do this exercise in MS Excel, I can press F9, and B2 will update to 0.1. If I press F9 again, it updates to 0.2, and so on.

Currently, however, when I change the cell B2 as above, Calc first returns '#VALUE!'. When I then press F9, cell B2 then contains 'ERR:523'.

How can I recreate manual calculation with circular (and self!) references with LibO?