https://bugs.documentfoundation.org/show_bug.cgi?id=149333
--- Comment #5 from Mike Kaganski <[email protected]> --- Maybe the easiest example (inspired by bug 161338): A1: 200 A2: =1/A1 Goal Seek Formula cell: $A$2 Target value: 100 Variable cell: $A$1 The method used in ScDocument::Solver (sc/source/core/data/documen4.cxx), Regula Falsi, is known to have limitations for discontinuous functions (like the cases mentioned here). Some improvements are needed to overcome the limitations. Excel's Goal Seek converges much slower in these cases, compared to instant failure of Calc; it looks OK to try to introduce additional steps (alternative methods? more clever detection of special points?) here, if that helps. -- You are receiving this mail because: You are the assignee for the bug.
