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

Reply via email to