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
** Bug watch added: freedesktop.org Bugzilla #75397
https://bugs.freedesktop.org/show_bug.cgi?id=75397
** Also affects: df-libreoffice via
https://bugs.freedesktop.org/show_bug.cgi?id=75397
Importance: Unknown
Status: Unknown
--
You received this bug notification because you are
** Changed in: libreoffice (Ubuntu)
Status: Incomplete => New
--
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 noti
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
apport information
** Tags added: apport-collected saucy
** 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)))}, how
EliCoten, thank you for reporting this and helping make Ubuntu better. Please
execute the following in a terminal:
sudo apt-get -y install libreoffice && apport-collect 1273659
As well, could you please attach a file that demonstrates this problem?
** Changed in: libreoffice (Ubuntu)
Stat
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
