apport-collect 1273659
The authorization page:
(https://launchpad.net/+authorize-token?...N)
should be opening in your browser. Use your browser to authorize
this program to access Launchpad on your behalf.
Press any key to continue or wait (5) seconds...
Waiting to hear from Launchpad about your decision...
(process:7620): GLib-CRITICAL **: g_slice_set_config: assertion 'sys_page_size
== 0' failed
Package libreoffice not installed and no hook available, ignoring
** 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.
{=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.
--
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/ubuntu/+source/libreoffice/+bug/1273659/+subscriptions
--
ubuntu-bugs mailing list
ubuntu-bugs@lists.ubuntu.com
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
