** Summary changed: - Array formula bug SUM(Len(A2:A200)) adds empty cells + Performing {SUM(Len(B7:B11))} against empty cells produces a non-zero result
** Description changed: - In a sheet where the range A2:A200 contain text strings and some are empty, the array formula - {=SUM(Len(A2:A200))} adds one to the sum for every empty cell. + 1) lsb_release -rd + Description: Ubuntu Trusty Tahr (development branch) + Release: 14.04 - {=SUM(IF(ISBLANK(A2:A200),0,LEN(A2:K200)))}, however, works correctly - - but the if(isblank()) shouldn't be necessary. + 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 - It seems to be more than just the SUM function, as I tried the QUARTILE - function with LEN as an array function and I also got the result 1 when - I was expecting 0. So perhaps any time you do an array function LEN() - with empty cells, LEN gives 1 when it should give 0. + 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 - (Needless to say the nonarray variation where you use a range of cells to perform the same calculation e.g. - =LEN(A2) - =LEN(A3) - =LEN(A4) - =LEN(A5) - ... - =LEN(A199) - =LEN(A200) - =SUM(B2:B200) + is cell B12 is 0, as it is in Gnumeric and Microsoft Office Excel 2003 + (11.5612.8172). - works fine. - --- + 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 ** Tags added: amd64 trusty -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1273659 Title: Performing {SUM(Len(B7:B11))} against empty cells produces a non-zero result To manage notifications about this bug go to: https://bugs.launchpad.net/df-libreoffice/+bug/1273659/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs