[Desktop-packages] [Bug 156381] Re: [Upstream] [hardy] Goal Seek hangs Calc indefinitely

This is fixed in Libreoffice 4.1+ (in 14.04, etc). Closing. ** Changed in: libreoffice (Ubuntu) Status: Triaged => Fix Released ** Changed in: openoffice Importance: Unknown => Undecided ** Changed in: openoffice Status: Confirmed => New ** Changed in: openoffice Remote watch:

[Desktop-packages] [Bug 156381] Re: [Upstream] [hardy] Goal Seek hangs Calc indefinitely

** Changed in: df-libreoffice Status: Confirmed => Fix Released -- You received this bug notification because you are a member of Desktop Packages, which is subscribed to openoffice.org in Ubuntu. https://bugs.launchpad.net/bugs/156381 Title: [Upstream] [hardy] Goal Seek hangs Calc inde

[Desktop-packages] [Bug 156381]

(In reply to comment #23) > excerpt from workdir/*/JunitTest/sc_unoapi/done.log: > > > checking: [sc.ScModelObj::com::sun::star::sheet::XGoalSeek] is iface: > > [com.sun.star.sheet.XGoalSeek] testcode: [ifc.sheet._XGoalSeek] > > LOG> Execute: seekGoal() > > LOG> Goal Result: 16.0 Divergence: 0.

[Desktop-packages] [Bug 156381]

Winfried committed a patch related to this issue. It has been pushed to "libreoffice-4-1": http://cgit.freedesktop.org/libreoffice/core/commit/?id=a3cbb8e2526a61a2b10e3663f5971f0441f605a9&h=libreoffice-4-1 fdo#37341 fix unending loop in calc with Goal Seek It will be available in LibreOffice 4.

[Desktop-packages] [Bug 156381]

Winfried committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=416d10b5f91047f0dcfbcc233c60322810bfc8d0 fdo#37341 fix unending loop in calc with Goal Seek The patch should be included in the daily builds available at htt

[Desktop-packages] [Bug 156381]

@Winfried: Master's 416d10b5f91047f0dcfbcc233c60322810bfc8d0 could be backported to 4-0 as well but additionally to resolving some merge conflicts would also need some adaption as there the ScDocument:GetValueCell() and ScDocument::GetFormulaCell() methods don't exist yet. -- You received this

[Desktop-packages] [Bug 156381]

(In reply to comment #29) > @Winfried: > Master's 416d10b5f91047f0dcfbcc233c60322810bfc8d0 could be backported to 4-0 > as well but additionally to resolving some merge conflicts would also need > some adaption as there the ScDocument:GetValueCell() and > ScDocument::GetFormulaCell() methods don't

[Desktop-packages] [Bug 156381] Re: [Upstream] [hardy] Goal Seek hangs Calc indefinitely

** Changed in: df-libreoffice Status: In Progress => Confirmed -- You received this bug notification because you are a member of Desktop Packages, which is subscribed to openoffice.org in Ubuntu. https://bugs.launchpad.net/bugs/156381 Title: [Upstream] [hardy] Goal Seek hangs Calc indef

[Desktop-packages] [Bug 156381]

Marking this fixed. Good job Winfried! -- You received this bug notification because you are a member of Desktop Packages, which is subscribed to openoffice.org in Ubuntu. https://bugs.launchpad.net/bugs/156381 Title: [Upstream] [hardy] Goal Seek hangs Calc indefinitely Status in LibreOffice

[Desktop-packages] [Bug 156381]

The fix broke JunitTest_sc_unoapi, so I unfortunately had to revert it for now with "Revert 'fdo#37341 dix unending loop in calc with Goal Seek.'" -- You received this bug notification because you a

[Desktop-packages] [Bug 156381]

Stephan Bergmann committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=bcbdf6763944dcc53c2667bf829a005ff0b9223a Revert "fdo#37341 dix unending loop in calc with Goal Seek" The patch should be included in the daily builds

[Desktop-packages] [Bug 156381]

Winfried committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=07112a712245bdcca40bb87e2bd118eec9635848 fdo#37341 dix unending loop in calc with Goal Seek The patch should be included in the daily builds available at htt

[Desktop-packages] [Bug 156381]

excerpt from workdir/*/JunitTest/sc_unoapi/done.log: > checking: [sc.ScModelObj::com::sun::star::sheet::XGoalSeek] is iface: > [com.sun.star.sheet.XGoalSeek] testcode: [ifc.sheet._XGoalSeek] > LOG> Execute: seekGoal() > LOG> Goal Result: 16.0 Divergence: 0.0 > LOG> Goal Result: 9.0 Divergence

[Desktop-packages] [Bug 156381]

Created attachment 83889 calc sheet with the goal seek tests from Junittest_sc_unoapi I've put the data form the Junittest on a calc sheet, with the outcomes as I would expect them. Presently, I don know whether the Junittest is wrong, or the patch. I could add a unittest to core/sc/qa/unit/ucal

[Desktop-packages] [Bug 156381]

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 depen

[Desktop-packages] [Bug 156381]

I have a dirty fix: The MAXRECURSION (/core/sc/source/core/data/formulacell.cxx) value of 400 is reached; increasing it 'solves' the problem. However, there will always be a case where the MAXRECURSION value is reached, so a proper handling of this situation is required. Also, a 'best' value for

[Desktop-packages] [Bug 156381]

I also confirm what Takeshi Abe reported, i.e. that the cause is not in ScInterpreter::ScBackSolver(), but in SCFormulaCell::Interpret(). At some point the result is no longer calculated but equal to the previous result, causing an infinite loop in ScBacksolver() since changing the start value doe

[Desktop-packages] [Bug 156381] Re: [Upstream] [hardy] Goal Seek hangs Calc indefinitely

** Changed in: df-libreoffice Status: Confirmed => In Progress -- You received this bug notification because you are a member of Desktop Packages, which is subscribed to openoffice.org in Ubuntu. https://bugs.launchpad.net/bugs/156381 Title: [Upstream] [hardy] Goal Seek hangs Calc indef

[Desktop-packages] [Bug 156381]

I confirm problem -as described in comment 3 and comment 4 - still exists on master. I will look into the code and see if i can find the cause and a fix. -- You received this bug notification because you are a member of Desktop Packages, which is subscribed to openoffice.org in Ubuntu. https://b

[Desktop-packages] [Bug 156381]

@kohei, @moggi - any input on how to move this ahead? I notice that easyhack status got lost or removed meanwhile - or can you suggest Takeshi Abe some more directions to look into? -- You received this bug notification because you are a member of Desktop Packages, which is subscribed to libreoff

[Desktop-packages] [Bug 156381] Re: [Upstream] [hardy] Goal Seek hangs Calc indefinitely

** Changed in: df-libreoffice Status: In Progress => Confirmed -- You received this bug notification because you are a member of Desktop Packages, which is subscribed to libreoffice in Ubuntu. https://bugs.launchpad.net/bugs/156381 Title: [Upstream] [hardy] Goal Seek hangs Calc indefini

[Desktop-packages] [Bug 156381]

Is the patch still unapplied? Anyway: Setting status back to NEW until clarified. -- You received this bug notification because you are a member of Desktop Packages, which is subscribed to libreoffice in Ubuntu. https://bugs.launchpad.net/bugs/156381 Title: [Upstream] [hardy] Goal Seek hangs C

[Desktop-packages] [Bug 156381] Re: [Upstream] [hardy] Goal Seek hangs Calc indefinitely

Launchpad has imported 14 comments from the remote bug at https://bugs.freedesktop.org/show_bug.cgi?id=37341. If you reply to an imported comment from within Launchpad, your comment will be sent to the remote bug automatically. Read more about Launchpad's inter-bugtracker facilities at https://hel

[Desktop-packages] [Bug 156381] migrating packaging from OpenOffice.org to Libreoffice

[This is an automated message.] There are no new official OpenOffice.org releases in Ubuntu packaging anymore => Won't Fix If the problem persists, please mark this bug as "also affects project Libreoffice" or "also affects distribution Libreoffice (Ubuntu)" if that has not happened already. P

[Desktop-packages] [Bug 156381] Re: [Upstream] [hardy] Goal Seek hangs Calc indefinitely

** Changed in: openoffice.org (Ubuntu) Status: Triaged => Won't Fix -- You received this bug notification because you are a member of Desktop Packages, which is subscribed to libreoffice in Ubuntu. https://bugs.launchpad.net/bugs/156381 Title: [Upstream] [hardy] Goal Seek hangs Calc ind