** 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 empt
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, Branc
** 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 ce
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
resu
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 non
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
http://dev-b
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=473e10aa5e1e3c6a4854dec9ff2ea522be283799&h=libreoffice-4-2
fdo#75397: Return an empty string for empty element.
It will be available in LibreOf
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 Producti
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 produ
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=a226019bb5431ca04cae28fefb6b83e2bb738243&h=libreoffice-4-1
fdo#75397: Return an empty string for empty element.
It will be available in LibreOf
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 working
** 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 produ
** 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.
https://bugs.launchpad.net/bu
** 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
- {=SUM(Len(A2:A200))
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 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 c
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
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.
https://bugs.launchpa
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
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.
24 matches
Mail list logo
