Created attachment 57878 [details]
example after one step (I can't attach two files)
I wish to solve the two dimensional Laplace equation by the relaxation method. To do this, I chose a region of the spread sheet enclosed in cells holding constant numerical values. Interior cells hold formulas like, for B2: =(B1+B3+A2+C2)/4.
See Laplace0.ods; This amounts to a large number of circular references. I check iteration, chose step number 1, error bound 0.1, uncheck automatic calculation and press F9; I get Laplace1.ods, error 523 in every variable cell. Changing step number or error bound makes no difference. In contrast, the one-dimensional case (as in the help for circular reference) works well. What do I do wrong ?
Related question: once the computation stops, with error 523, how can I restart it without retyping the speadsheet?
Remark: Over the years, I have run this type of computation successfully on Quattro pro (!), Excel and OpenOffice.calc
Created attachment 57879 [details]
Initial state of spreadsheet
This bug is never confirmed. Set to UNCONFIRMED.
As I am not expert on iterative computation, would you please take a look it bug 46845 to see if this one is a duplicate?
Le 07/07/2014 17:32, email@example.com a écrit :
> Kevin Suo <mailto:firstname.lastname@example.org> changed bug 46850
> What Removed Added
> See Also https://bugs.freedesktop.org/show_bug.cgi?id=46845
> *Comment # 3 <https://bugs.freedesktop.org/show_bug.cgi?id=46850#c3>
> on bug 46850 <https://bugs.freedesktop.org/show_bug.cgi?id=46850> from
> Kevin Suo <mailto:email@example.com> *
> Hi jean-philippe.grivet,
> As I am not expert on iterative computation, would you please take a look it
> bug 46845 <show_bug.cgi?id=46845> to see if this one is a duplicate?
> You are receiving this mail because:
> * You reported the bug.
That's quite possible, although it is impossible to conclude since kevin
gives no details of his computation
Ce courrier électronique ne contient aucun virus ou logiciel malveillant parce que la protection avast! Antivirus est active.
Not reproducible for me with versions 4.1.6, 220.127.116.11.0+ and 18.104.22.168.0+ under Ubuntu 14.04 x86-64. If I modify steps number to 10, I do not get an error and the computation converges.
You can restart the computation by reloading the file
Please, could you try again with current stable version?
Set status to NEEDINFO. Please set it back to UNCONFIRMED once you have provided requested informations.
Best regards. JBF
Dear Bug Submitter,
This bug has been in NEEDINFO status with no change for at least 6 months. Please provide the requested information as soon as possible and mark the bug as UNCONFIRMED. Due to regular bug tracker maintenance, if the bug is still in NEEDINFO status with no change in 30 days the QA team will close the bug as INVALID due to lack of needed information.
For more information about our NEEDINFO policy please read the wiki located here:
If you have already provided the requested information, please mark the bug as UNCONFIRMED so that the QA team knows that the bug is ready to be confirmed.
Thank you for helping us make LibreOffice even better for everyone!
Message generated on: 2015-02-18
Still works (see comment #5) in LibreOffice 22.214.171.124.0+ under Ubuntu 14.10 x86-64
Closing as WorksForMe. Please feel free to reopen if you disagree.
Best regards. JBF
(but iteration in calc isn't 'clean')
two comments on the initial report:
> Changing step number or error bound makes no difference.
wrong, it does, if you set steps to 1000 (lower values will work too) you'll get results, if you change 'error bound' or 'minimum change' to e.g. 0,5 in your sample you'll see results,
> once the computation stops, with error 523, how can I restart it without retyping the speadsheet?
retype F9, ctrl-shift-F9 or whatever, err:523 doesn't 'stop' the calculation, it's only an error message displayed for results whose changes exceed the given limit. the calculations are! done, and their results are! used for the next round. as your equations converge results will show up after some steps, once the change - per step - is lower than the given limit.
just spotted on a recheck:
ver 126.96.36.199 is stuck in err:523, ver 188.8.131.52 calculates,
iterative calculations are 'off' from undo,
same in ex$el,
ex$el does! a new round of calculation for circular dependent formulas on changes elsewhere in the sheet, while calc doesn't,