** Changed in: libreoffice (Ubuntu)
Status: Triaged => Fix Released
--
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:
Performing {SUM(Len(B7:B11))} against
Thanks Kohei,
Verified with:
Win7x64Ultimate
Version: 4.2.5.0.0+ Build ID: 59906c3d54e6541185f4bf85b1d1c70530198059
TinderBox: Win-x86@42, Branch:libreoffice-4-2, Time: 2014-04-30_09:30:13
Version: 4.3.0.0.alpha1+ Build ID: 20778b037c688759a4dc46acb8aeb66c9d1290cc
TinderBox: Win-x86@39,
Kohei Yoshida committed a patch related to this issue.
It has been pushed to master:
http://cgit.freedesktop.org/libreoffice/core/commit/?id=5fab47ddbe332a150fb2005e941a2c19bd38ce7f
fdo#75397: Return an empty string for empty element.
The patch should be included in the daily builds available
Kohei Yoshida committed a patch related to this issue.
It has been pushed to libreoffice-4-2:
http://cgit.freedesktop.org/libreoffice/core/commit/?id=473e10aa5e1e3c6a4854dec9ff2ea522be283799h=libreoffice-4-2
fdo#75397: Return an empty string for empty element.
It will be available in
Fixed.
--
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:
Performing {SUM(Len(B7:B11))} against empty cells produces a non-zero
result
Status in LibreOffice
I'll take this. This bug was already present in 4.0 in fact.
--
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:
Performing {SUM(Len(B7:B11))} against empty cells
Here is for 4.1: https://gerrit.libreoffice.org/9188
--
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:
Performing {SUM(Len(B7:B11))} against empty cells produces a
Kohei Yoshida committed a patch related to this issue.
It has been pushed to master:
http://cgit.freedesktop.org/libreoffice/core/commit/?id=18fa4733f46c2dae40bad7cdea9d3f98e24495dd
fdo#75397: Write unit test for this.
The patch should be included in the daily builds available at
Kohei Yoshida committed a patch related to this issue.
It has been pushed to libreoffice-4-1:
http://cgit.freedesktop.org/libreoffice/core/commit/?id=a226019bb5431ca04cae28fefb6b83e2bb738243h=libreoffice-4-1
fdo#75397: Return an empty string for empty element.
It will be available in
4.2: https://gerrit.libreoffice.org/9187
--
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:
Performing {SUM(Len(B7:B11))} against empty cells produces a non-zero
** Changed in: df-libreoffice
Status: Confirmed = Fix Released
--
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:
Performing {SUM(Len(B7:B11))} against empty
** Changed in: df-libreoffice
Status: New = Confirmed
--
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:
Performing {SUM(Len(B7:B11))} against empty cells
Hi elicoten, thanks for reporting
Reproducible with:
Win7x64Ultimate
Version: 4.1.6.0.0+ Build ID: 1c33633ef18274bf384c74c492195519be83c05
until
Version: 4.3.0.0.alpha0+
Build ID: d84ccb39b744457cd47125beb4291c84223d5219
TinderBox: Win-x86@39, Branch:master, Time: 2014-02-22_10:05:06
Last
** 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
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
** 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
-
** Changed in: libreoffice (Ubuntu)
Importance: Undecided = Medium
** Changed in: libreoffice (Ubuntu)
Status: New = Triaged
--
You received this bug notification because you are a member of Desktop
Packages, which is subscribed to libreoffice in Ubuntu.
** 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
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)))},
apport information
** Attachment added: ProcEnviron.txt
https://bugs.launchpad.net/bugs/1273659/+attachment/3962695/+files/ProcEnviron.txt
--
You received this bug notification because you are a member of Desktop
Packages, which is subscribed to libreoffice in Ubuntu.
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
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.
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
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)
24 matches
Mail list logo
