Err: 523 circular reference battery or miscalculation

Question

To complete the spreadsheet sequence, I usually let my students write a small car racing simulator in Excel. In my new school, I do not have Excel at my disposal, so we do everything with Calc (which is generally normal). However, there is something that worked well in Excel that I cannot get to work in Calc.

I need a drive field that adds a bone roll result (simulated =int(rand()*6)+1)to get the current sum of all previous bone rolls plus the current one.

This is possible if you activate iterative calculations. But with my current settings, I most often get the following error:

The settings are as follows:

, " :" 6. F9, . , , , , , , .

Excel :

:

:

+ 1:

LibreOffice Calc?

: Calc?

Answer 1

mariosv , , A1.

A1 1 3 ( ) () , 1 1:

0   0
1   2
2   Err:523
3   Err:523
1   14
2   Err:523
3   Err:523
1   26
2   Err:523
3   Err:523
1   38

, , . " " (.. , 0 1 (.. 3 1).

:

: 5.4.3.2 (x64)
: 92a7159f7e4af62137622921e809f8546db437e5 : 2; : Windows 6.29; : ; : en-GB (en_GB); Calc:

( LO OO).

, 6.1.0.1 .

_{... Google?- - .;)}