Ask LibreOffice - RSS feedhttps://ask.libreoffice.org/en/questions/Questions and answers for LibreOfficeenThu, 26 Jul 2012 23:36:59 +0200Manual calculation of circular references in Calc?https://ask.libreoffice.org/en/question/4279/manual-calculation-of-circular-references-in-calc/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):
![Excel options to enable manual calculation](http://img171.imageshack.us/img171/1561/excelcalculationoptions.png)
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?huntekeThu, 26 Jul 2012 23:36:59 +0200https://ask.libreoffice.org/en/question/4279/