Created attachment 54291 [details]
Giving the task foran target value search
with formula cell $K$248 to get a target value of zero
with changeable cell $H$5
leads reproducable to a blocking crash of libre office calc 3.4.4
(OOO340m1 (Build 402)
Comment on attachment 54291 [details]
Libre Office 3.4.4 (Build 402) crashes using
target value search on cell $K$248 aimed value of zero
with changeable cell $h$5
NOT reproducible with reporter's sample and "LibreOffice 3.4.4 - WIN7 Home Premium (64bit) English UI [Build ID: OOO340m1 (Build:402)]" using SCO Evolutionary Aslorithm, DEPS and Linear for details see attached screenshots. May be I'm doing a little detail different to reporter?
Might be related to Bug 43388 Crash (Runtime error) when using SCO (or DEPS) Evolutionary Algorithm Solver
- Attach screenshots with comments if you believe that that might explain the
problem better than a text comment. Best way is to insert your screenshots
into a DRAW document and to add comments that explain what you want to show
- Contribute a step by step instruction containing every key press and every
mouse click how to reproduce your problem (and if possible how to created a
sample document from the scratch)
- add information
-- What algorithm you use
-- concerning your PC (video card, ...)
-- concerning your OS (Version, Distribution, Language)
-- concerning your LibO localization (UI language)
–- Libo settings that might be related to your problems
(video hardware acceleration ...)
-- how you launch LibO and how you opened the sample document
–- If you can contribute an OOo Issue that might be useful
-- everything else crossing your mind
Created attachment 54295 [details]
Showing my results
Created attachment 54305 [details]
Comment on attachment 54305 [details]
Lade ich die Tabelle in Excel erhalte ich
problemlos als Zielwert 3,73922738630465%
Created attachment 54306 [details]
Ändere ich die Bedingungen für Solve minimal ab
(in $K$247 den Wert 260 erzielen bei änderbarem $H$5)
zeigt der Solver nach ca 30 Sekunden den Lösungswert 260,
rechnet aber weiter bis nach 3 Minuten das Programm nicht mehr ansprechbar ist.
With "Goal Seek" [Reproducible] with "LibreOffice 3.4.5 RC1 - WIN7 Home Premium (64bit) English UI [Build ID: OOO340m1 (Build:501)]", also with
Parallel Dev-Installation of "LibreOffice 3.5.0 Beta1 - WIN7 Home Premium (64bit) German UI [Build-ID: 7362ca8-b5a8e65-af86909-d471f98-61464c4] Windows_Release_Configuration 11-Dec-2011 06:51"
Currently I see this one as a DUP of "Bug 37341 - Goal Seek hangs indefinitely for too many calculation steps (Formula Cell $F$110)"
Please feel free to reopen this Bug if you find evidence that we have an independent issue here.
*** This bug has been marked as a duplicate of bug 37341 ***
Zdeněk Crhonek committed a patch related to this issue.
It has been pushed to "master":
uitest Calc/Goal seek; tdf#37341 ; tdf#43693
It will be available in 6.2.0.
The patch should be included in the daily builds available at
http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More
information about daily builds can be found at:
Affected users are encouraged to test the fix and report feedback.