Public bug reported:
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.
** Affects: libreoffice (Ubuntu)
Importance: Undecided
Status: New
--
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:
New
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.
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 : [email protected]
Unsubscribe : https://launchpad.net/~desktop-packages
More help : https://help.launchpad.net/ListHelp
