desktop-packages team mailing list archive

[Rutger Hendriks <617264@xxxxxxxxxxxxxxxxxx>]

Hi, the bug has indeed been fixed. Thank you all.
Op 10 sep. 2011 17:05 schreef "Christopher M. Penalver" <
christopher.penalver@xxxxxxx> het volgende:
> Rutger Hendriks, I am closing the bug task for LibreOffice because the
> bug has been fixed in the latest development version of Ubuntu - Oneiric
> Ocelot.
>
> This is a significant bug in Ubuntu. If you need a fix for the bug in
> previous versions of Ubuntu, please do steps 1 and 2 of the SRU
> Procedure [1] to bring the need to a developer's attention.
>
> [1]: https://wiki.ubuntu.com/StableReleaseUpdates#Procedure
>
> lsb_release -rd
> Description: Ubuntu oneiric (development branch)
> Release: 11.10
>
> apt-cache policy libreoffice-calc
> libreoffice-calc:
> Installed: 1:3.4.2-2ubuntu3
> Candidate: 1:3.4.2-2ubuntu3
> Version table:
> *** 1:3.4.2-2ubuntu3 0
> 500 http://us.archive.ubuntu.com/ubuntu/ oneiric/main i386 Packages
> 100 /var/lib/dpkg/status
>
> ** Changed in: libreoffice (Ubuntu)
> Status: Triaged => Fix Released
>
> --
> You received this bug notification because you are subscribed to the bug
> report.
> https://bugs.launchpad.net/bugs/617264
>
> Title:
> [Upstream] Calc: formulas with INDIRECT not honoring AutoCalculate
>
> Status in LibreOffice Productivity Suite:
> Fix Released
> Status in “gnumeric” package in Ubuntu:
> Invalid
> Status in “libreoffice” package in Ubuntu:
> Fix Released
> Status in “openoffice.org” package in Ubuntu:
> New
>
> Bug description:
> Binary package hint: openoffice.org
> Binary package hint: libreoffice
>
> 1)
> Natty:
> lsb_release -rd
> Description: Ubuntu Natty (development branch)
> Release: 11.04
>
> Maverick:
> lsb_release -rd
> Description: Ubuntu 10.10
> Release: 10.10
>
> 2)
> Natty:
> apt-cache policy libreoffice-calc
> libreoffice-calc:
>   Installed: 1:3.3.1-1ubuntu5
>   Candidate: 1:3.3.1-1ubuntu5
>   Version table:
>  *** 1:3.3.1-1ubuntu5 0
>         500 http://us.archive.ubuntu.com/ubuntu/ natty/main i386 Packages
100
> /var/lib/dpkg/status
>
> Maverick:
> apt-cache policy libreoffice-calc
> libreoffice-calc:
>   Installed: 1:3.3.1-1ubuntu3~maverick1
>   Candidate: 1:3.3.1-1ubuntu3~maverick1
>   Version table:
>  *** 1:3.3.1-1ubuntu3~maverick1 0
>         500 http://ppa.launchpad.net/libreoffice/ppa/ubuntu/ maverick/main
i386 Packages
>         100 /var/lib/dpkg/status
>
> 3) What is expected to happen via the Terminal:
>
> cd ~/Desktop && wget
>
https://bugs.launchpad.net/ubuntu/+source/openoffice.org/+bug/617264/+attachment/1487753/+files/Formulas%20with%20Indirect%20not%20recalculated.ods
> && localc -nologo Formulas\ with\ Indirect\ not\ recalculated.ods
>
> Click Tools -> Cell Contents -> AutoCalculate is checked
>
> If one puts a 1 in cell A1 then cell A3:
>
> =IF(A1="","A1 is empty",INDIRECT("'Sheet1'.B1"))
>
> automatically reflects the change.
>
> 4) What happens is it does not.
>
> WORKAROUND: Click Ctrl+Shift+F9 to get the cell with INDIRECT to
> calculate. Note how Gnumeric autocalculates INDIRECT function without
> the need for Ctrl+Shift+F9
>
> lsb_release -rd
> Description: Ubuntu 10.10
> Release: 10.10
>
> apt-cache policy gnumeric
> gnumeric:
>   Installed: 1.10.8-1ubuntu1
>   Candidate: 1.10.8-1ubuntu1
>   Version table:
>  *** 1.10.8-1ubuntu1 0
>         500 http://us.archive.ubuntu.com/ubuntu/ maverick/universe i386
Packages
>         100 /var/lib/dpkg/status
>
> ProblemType: Bug
> DistroRelease: Ubuntu 10.04
> Package: openoffice.org-core 1:3.2.0-7ubuntu4.1
> ProcVersionSignature: Ubuntu 2.6.32-24.39-generic 2.6.32.15+drm33.5
> Uname: Linux 2.6.32-24-generic x86_64
> Architecture: amd64
> Date: Fri Aug 13 10:10:28 2010
> EcryptfsInUse: Yes
> ExecutablePath: /usr/lib/openoffice/program/soffice.bin
> InstallationMedia: Kubuntu 10.04 LTS "Lucid Lynx" - Release amd64
(20100427.1)
> ProcEnviron:
>  PATH=(custom, no user)
>  LANG=nl_NL.UTF-8
>  SHELL=/bin/bash
> SourcePackage: openoffice.org
>
> To manage notifications about this bug go to:
> https://bugs.launchpad.net/df-libreoffice/+bug/617264/+subscriptions

-- 
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/617264

Title:
  [Upstream] Calc: formulas with INDIRECT not honoring AutoCalculate

Status in LibreOffice Productivity Suite:
  Fix Released
Status in “gnumeric” package in Ubuntu:
  Invalid
Status in “libreoffice” package in Ubuntu:
  Fix Released
Status in “openoffice.org” package in Ubuntu:
  New

Bug description:
  Binary package hint: openoffice.org
  Binary package hint: libreoffice

  1)
  Natty:
  lsb_release -rd
  Description:        Ubuntu Natty (development branch)
  Release:        11.04

  Maverick:
  lsb_release -rd
  Description: Ubuntu 10.10
  Release: 10.10

  2)
  Natty:
  apt-cache policy libreoffice-calc
  libreoffice-calc:
    Installed: 1:3.3.1-1ubuntu5
    Candidate: 1:3.3.1-1ubuntu5
    Version table:
   *** 1:3.3.1-1ubuntu5 0
          500 http://us.archive.ubuntu.com/ubuntu/ natty/main i386 Packages 100
  /var/lib/dpkg/status

  Maverick:
  apt-cache policy libreoffice-calc
  libreoffice-calc:
    Installed: 1:3.3.1-1ubuntu3~maverick1
    Candidate: 1:3.3.1-1ubuntu3~maverick1
    Version table:
   *** 1:3.3.1-1ubuntu3~maverick1 0
          500 http://ppa.launchpad.net/libreoffice/ppa/ubuntu/ maverick/main i386 Packages
          100 /var/lib/dpkg/status

  3) What is expected to happen via the Terminal:

  cd ~/Desktop && wget
  https://bugs.launchpad.net/ubuntu/+source/openoffice.org/+bug/617264/+attachment/1487753/+files/Formulas%20with%20Indirect%20not%20recalculated.ods
  && localc -nologo Formulas\ with\ Indirect\ not\ recalculated.ods

  Click Tools -> Cell Contents -> AutoCalculate is checked

  If one puts a 1 in cell A1 then cell A3:

  =IF(A1="","A1 is empty",INDIRECT("'Sheet1'.B1"))

  automatically reflects the change.

  4) What happens is it does not.

  WORKAROUND: Click Ctrl+Shift+F9 to get the cell with INDIRECT to
  calculate. Note how Gnumeric autocalculates INDIRECT function without
  the need for Ctrl+Shift+F9

  lsb_release -rd
  Description: Ubuntu 10.10
  Release: 10.10

  apt-cache policy gnumeric
  gnumeric:
    Installed: 1.10.8-1ubuntu1
    Candidate: 1.10.8-1ubuntu1
    Version table:
   *** 1.10.8-1ubuntu1 0
          500 http://us.archive.ubuntu.com/ubuntu/ maverick/universe i386 Packages
          100 /var/lib/dpkg/status

  ProblemType: Bug
  DistroRelease: Ubuntu 10.04
  Package: openoffice.org-core 1:3.2.0-7ubuntu4.1
  ProcVersionSignature: Ubuntu 2.6.32-24.39-generic 2.6.32.15+drm33.5
  Uname: Linux 2.6.32-24-generic x86_64
  Architecture: amd64
  Date: Fri Aug 13 10:10:28 2010
  EcryptfsInUse: Yes
  ExecutablePath: /usr/lib/openoffice/program/soffice.bin
  InstallationMedia: Kubuntu 10.04 LTS "Lucid Lynx" - Release amd64 (20100427.1)
  ProcEnviron:
   PATH=(custom, no user)
   LANG=nl_NL.UTF-8
   SHELL=/bin/bash
  SourcePackage: openoffice.org

To manage notifications about this bug go to:
https://bugs.launchpad.net/df-libreoffice/+bug/617264/+subscriptions