See cell B12 of the attachment for an example of the problem ** Attachment added: "Example showing the problem - see cell B12" https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1273659/+attachment/3962696/+files/Array%20Formula%20Bug.ods
-- 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: Array formula bug SUM(Len(A2:A200)) adds empty cells Status in “libreoffice” package in Ubuntu: Incomplete Bug description: 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. {=SUM(IF(ISBLANK(A2:A200),0,LEN(A2:K200)))}, however, works correctly - but the if(isblank()) shouldn't be necessary. 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. (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) works fine. --- 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/ubuntu/+source/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