At 11:35 26/10/2012 +0200, JP Grivet wrote:
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.
You have set Steps (not "step") to 1: this is the maximum number of
iterations, so that you have allowed the iteration to be performed
only once. Your calculation will not converge in one step, so you
see Error 523 - that your calculation has not converged within your
limit of just one step. You will need about 50 steps for such a
calculation to converge. Set Steps to 50 or more and see what happens.
I trust this helps.
For unsubscribe instructions e-mail to: email@example.com
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
Impressum (Legal Info)
: Unless otherwise specified, all text and images
on this website are licensed under the
Creative Commons Attribution-Share Alike 3.0 License
This does not include the source code of LibreOffice, which is
licensed under the Mozilla Public License (MPLv2
"LibreOffice" and "The Document Foundation" are
registered trademarks of their corresponding registered owners or are
in actual use as trademarks in one or more countries. Their respective
logos and icons are also subject to international copyright laws. Use
thereof is explained in our trademark policy