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:
(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
(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.0
LOG
Winfried committed a patch related to this issue.
It has been pushed to libreoffice-4-1:
http://cgit.freedesktop.org/libreoffice/core/commit/?id=a3cbb8e2526a61a2b10e3663f5971f0441f605a9h=libreoffice-4-1
fdo#37341 fix unending loop in calc with Goal Seek
It will be available in LibreOffice
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
@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
** 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
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
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
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:
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
The fix broke JunitTest_sc_unoapi, so I unfortunately had to revert it
for now with
http://cgit.freedesktop.org/libreoffice/core/commit/?id=bcbdf6763944dcc53c2667bf829a005ff0b9223a
Revert 'fdo#37341 dix unending loop in calc with Goal Seek.'
--
You received this bug notification because you are
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
** 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
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
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
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
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.
** 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
@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
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
** 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
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
** 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
24 matches
Mail list logo