desktop-packages team mailing list archive

[Korrawit Pruegsanusak <detective.conan.1412@xxxxxxxxx>]

>From upstream bugzilla comment 1:
> This one has alrady been fixed on master as part of the fix for Bug 31939.  The fix will appear in 3.4 and 3.3.2.
This should be fixed in 3.3.2 release in natty a few months ago, and should be fixed in oneiric too (see version number in https://launchpad.net/df-libreoffice/+packages) but the janitor doesn't work because there is no mentions to this bug in the changelog.

Anyway, I've tested version 1:3.3.2-1ubuntu2~maverick1 using libreoffice
ppa and it works fine (this bug is not reproducible) Thanks!

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