Launchpad has imported 2 comments from the remote bug at https://bugs.freedesktop.org/show_bug.cgi?id=75397.
If you reply to an imported comment from within Launchpad, your comment will be sent to the remote bug automatically. Read more about Launchpad's inter-bugtracker facilities at https://help.launchpad.net/InterBugTracking. ------------------------------------------------------------------------ On 2014-02-23T11:44:58+00:00 Elicoten wrote: 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. See demonstration of the problem in cell B12 here: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1273659/+attachment/3962696/+files/Array%20Formula%20Bug.ods Reply at: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1273659/comments/6 ------------------------------------------------------------------------ On 2014-02-23T11:47:07+00:00 Elicoten wrote: See also https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1273659 Reply at: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1273659/comments/7 ** Changed in: df-libreoffice Status: Unknown => New ** Changed in: df-libreoffice Importance: Unknown => Medium -- 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: Array formula bug SUM(Len(A2:A200)) adds empty cells To manage notifications about this bug go to: https://bugs.launchpad.net/df-libreoffice/+bug/1273659/+subscriptions -- ubuntu-bugs mailing list [email protected] https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
