Fixed.

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

Title:
  Performing {SUM(Len(B7:B11))} against empty cells produces a non-zero
  result

Status in LibreOffice Productivity Suite:
  Fix Released
Status in “libreoffice” package in Ubuntu:
  Triaged

Bug description:
  1) lsb_release -rd
  Description:  Ubuntu Trusty Tahr (development branch)
  Release:      14.04

  2) apt-cache policy libreoffice-calc
  libreoffice-calc:
    Installed: 1:4.2.0-0ubuntu1
    Candidate: 1:4.2.0-0ubuntu1
    Version table:
       1:4.2.1-0ubuntu1 0
          400 http://us.archive.ubuntu.com/ubuntu/ trusty-proposed/main amd64 
Packages
   *** 1:4.2.0-0ubuntu1 0
          500 http://us.archive.ubuntu.com/ubuntu/ trusty/main amd64 Packages
          100 /var/lib/dpkg/status

  3) What is expected to happen in Calc via a terminal:
  cd ~/Desktop && wget -c 
https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1273659/+attachment/3962696/+files/Array%20Formula%20Bug.ods
 -O example.ods && localc --nologo example.ods

  is cell B12 is 0, as it is in Gnumeric and Microsoft Office Excel 2003
  (11.5612.8172).

  4) What happens instead is it is 5.

  ---
  ApportVersion: 2.12.5-0ubuntu2.2
  Architecture: amd64
  DistroRelease: Ubuntu 13.10
  MarkForUpload: True
  Package: libreoffice 1:4.1.3-0ubuntu1
  PackageArchitecture: amd64
  ProcVersionSignature: Ubuntu 3.11.0-15.23-generic 3.11.10
  Tags:  saucy
  Uname: Linux 3.11.0-15-generic x86_64
  UpgradeStatus: Upgraded to saucy on 2013-11-15 (75 days ago)
  UserGroups: adm cdrom dip lpadmin plugdev sambashare sudo wireshark www-data

To manage notifications about this bug go to:
https://bugs.launchpad.net/df-libreoffice/+bug/1273659/+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

Reply via email to