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: 1.7976931348623157E308 > LOG> Goal Result: 0.8 Divergence: 1.7976931348623157E308 > Method seekGoal() finished with state FAILED > LOG> seekGoal(): PASSED.FAILED
-- 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 Productivity Suite: Confirmed Status in The OpenOffice.org Suite: Confirmed Status in “libreoffice” package in Ubuntu: Triaged Status in “openoffice.org” package in Ubuntu: Won't Fix Bug description: Binary package hint: openoffice.org-calc 1) lsb_release -rd Description: Ubuntu 11.04 Release: 11.04 2) apt-cache policy libreoffice-calc libreoffice-calc: Installed: 1:3.3.2-1ubuntu5 Candidate: 1:3.3.2-1ubuntu5 Version table: *** 1:3.3.2-1ubuntu5 0 500 http://us.archive.ubuntu.com/ubuntu/ natty-updates/main i386 Packages 500 http://us.archive.ubuntu.com/ubuntu/ natty-proposed/main i386 Packages 100 /var/lib/dpkg/status 1:3.3.2-1ubuntu4 0 500 http://us.archive.ubuntu.com/ubuntu/ natty/main i386 Packages 3) What is expected to happen in LibreOffice Calc via the Terminal: cd ~/Desktop && wget https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/156381/+attachment/167142/+files/sample.ods && localc -nologo sample.ods Tools -> Goal Seek... -> Formula Cell $F$110 -> Target 0 -> Variable Cell $E$7 -> OK button and it does so quickly and successfully. 4) What happens instead is it hangs Calc (waited ~10 minutes than killed process). WORKAROUND: Use Gnumeric as it performs the calculation instantly. apt-cache policy gnumeric gnumeric: Installed: 1.10.13-1ubuntu1 Candidate: 1.10.13-1ubuntu1 Version table: *** 1.10.13-1ubuntu1 0 500 http://us.archive.ubuntu.com/ubuntu/ natty/universe i386 Packages 100 /var/lib/dpkg/status Original Reporter Comments: If you use the "Goal Seek" on a spreadsheet that exceeds 105 rows OOO calc hangs completely, taking over 50% of CPU and you have to force the exit. To manage notifications about this bug go to: https://bugs.launchpad.net/df-libreoffice/+bug/156381/+subscriptions -- Mailing list: https://launchpad.net/~desktop-packages Post to : desktop-packages@lists.launchpad.net Unsubscribe : https://launchpad.net/~desktop-packages More help : https://help.launchpad.net/ListHelp
