Le 26/10/2012 13:31, Brian Barker a écrit :
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.
Brian Barker
It helps tremendously, thank you. Plus the fact, that I read somewhere
else, that computation on demand is initiated by CTRL+SHIFT+F9.
My real concern is in fact with two-dimensional regions of the
worksheet; would you know whether results can be presented as contour
lines or as a surface
seen in perspective (z(x,y)) ?
Thanks again,
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
Context
Privacy Policy |
Impressum (Legal Info) |
Copyright information: 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.