[Desktop-packages] [Bug 1273659] Re: Array formula bug SUM(Len(A2:A200)) adds empty cells
** 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 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 Productivity Suite:
Unknown
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.
---
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
To manage notifications about this bug go to:
https://bugs.launchpad.net/df-libreoffice/+bug/1273659/+subscriptions
--
Mailing list: https://launchpad.net/~desktop-packages
Post to : desktop-packages@lists.launchpad.net
Unsubscribe : https://launchpad.net/~desktop-packages
More help : https://help.launchpad.net/ListHelp
[Desktop-packages] [Bug 1273659] Re: Array formula bug SUM(Len(A2:A200)) adds empty cells
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 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 Productivity Suite:
New
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.
---
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
To manage notifications about this bug go to:
https://bugs.launchpad.net/df-libreoffice/+bug/1273659/+subscriptions
--
Mailing list: https://launchpad.net/~desktop-packages
Post to : desktop-packages@lists.launchpad.net
Unsubscribe : https://launchpad.net/~desktop-packages
More help : https://help.launchpad.net/ListHelp
[Desktop-packages] [Bug 1273659] Re: Array formula bug SUM(Len(A2:A200)) adds empty cells
** Changed in: libreoffice (Ubuntu)
Status: Incomplete = 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.
---
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
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 : desktop-packages@lists.launchpad.net
Unsubscribe : https://launchpad.net/~desktop-packages
More help : https://help.launchpad.net/ListHelp
[Desktop-packages] [Bug 1273659] Re: Array formula bug SUM(Len(A2:A200)) adds empty cells
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)))}, 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.
+ ---
+ 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
** Attachment added: Dependencies.txt
https://bugs.launchpad.net/bugs/1273659/+attachment/3962694/+files/Dependencies.txt
--
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:
Incomplete
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.
---
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
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 : desktop-packages@lists.launchpad.net
Unsubscribe : https://launchpad.net/~desktop-packages
More help : https://help.launchpad.net/ListHelp
[Desktop-packages] [Bug 1273659] Re: Array formula bug SUM(Len(A2:A200)) adds empty cells
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 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:
Incomplete
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.
---
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
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 : desktop-packages@lists.launchpad.net
Unsubscribe : https://launchpad.net/~desktop-packages
More help : https://help.launchpad.net/ListHelp
[Desktop-packages] [Bug 1273659] Re: Array formula bug SUM(Len(A2:A200)) adds empty cells
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 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 : desktop-packages@lists.launchpad.net
Unsubscribe : https://launchpad.net/~desktop-packages
More help : https://help.launchpad.net/ListHelp
[Desktop-packages] [Bug 1273659] Re: Array formula bug SUM(Len(A2:A200)) adds empty cells
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)
Status: New = Incomplete
--
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:
Incomplete
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 : desktop-packages@lists.launchpad.net
Unsubscribe : https://launchpad.net/~desktop-packages
More help : https://help.launchpad.net/ListHelp
