https://bugs.freedesktop.org/show_bug.cgi?id=46850
Bug #: 46850
Summary: iterative computation will not converge
Classification: Unclassified
Product: LibreOffice
Version: LibO 3.5.0 RC2
Platform: x86 (IA32)
OS/Version: Windows (All)
Status: NEW
Severity: normal
Priority: medium
Component: Libreoffice
AssignedTo: [email protected]
ReportedBy: [email protected]
Created attachment 57878
--> https://bugs.freedesktop.org/attachment.cgi?id=57878
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
--
Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs