Hi elicoten, thanks for reporting Reproducible with: Win7x64Ultimate Version: 4.1.6.0.0+ Build ID: 1c33633ef18274bf384c74c492195519be83c05 until Version: 4.3.0.0.alpha0+ Build ID: d84ccb39b744457cd47125beb4291c84223d5219 TinderBox: Win-x86@39, Branch:master, Time: 2014-02-22_10:05:06
Last working: Versión 3.6.7.2 (ID de compilación: e183d5b) -- 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: Confirmed 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 : [email protected] Unsubscribe : https://launchpad.net/~desktop-packages More help : https://help.launchpad.net/ListHelp
