A proper fix will take some time as the problem is deep inside the code,
hidden in a maze of recursive and iterative code.

Also, the chances are that when fixed, calc will no longer hang, but neither 
give a solution. The reason for this is that in attachment 46880 the formula in 
every cell depends on the formula-result in other cells. And as the root is 
searched by starting to calculate the final cell (F110), the goal seeking code 
has to call itself too often (i.e. for every formula cell a new call is needed).
A more efficient formula (e.g. using TVM-functions) would solve this (and 
prevent the hanging as long as the problem is not yet fixed).

-- 
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
https://bugs.launchpad.net/bugs/156381

Title:
  [Upstream] [hardy] Goal Seek hangs Calc indefinitely

To manage notifications about this bug go to:
https://bugs.launchpad.net/df-libreoffice/+bug/156381/+subscriptions

-- 
ubuntu-bugs mailing list
[email protected]
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs

Reply via email to