[libreoffice-users] circular references

Hello,

Using LO/Calc-3.6, I am trying, without success, to run an iterative 
computation. First, in tools/options/calc, I check
iterations and set step  1, minimum change = 0.01. Then, in tools/cell 
contents, I uncheck automatic computation.

For a minimal example, cell contents are as follows:
A1: 0; A2: =(A1+A3)/2; A3: =(A2+A4)/2;.....; A9: =(A8+A10)/2; A10: 1.

As soon as I press F9, Err:523 appears in each cell. This happens for 
any other choice of parameters. The same behavior
occurs if I use a column instead of a row, or a rectangular area.

Once the commputation has stopped with Err: 523, I must first retype 
every cell content before having another try.
Does anybody know of a workaroiund?

Remark: I have routinely run such iterative calculations using Quattro 
Pro and  Excel.

Thank you for your time and help
JP Grivet



--
For unsubscribe instructions e-mail to: users+help@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted