** 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