← Back to team overview

desktop-packages team mailing list archive

[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 indefinitely

Status in LibreOffice Productivity Suite:
  In Progress
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