2010-11-24 18:36:53 |
Christoph Arenz |
bug |
|
|
added bug |
2010-11-24 18:38:03 |
Christoph Arenz |
attachment added |
|
examples of wrong calculations with DCOUNT https://bugs.launchpad.net/ubuntu/+source/openoffice.org/+bug/681080/+attachment/1743794/+files/OO_DCOUNT_problem_2.ods |
|
2011-05-16 13:22:47 |
penalvch |
bug task added |
|
libreoffice (Ubuntu) |
|
2011-05-16 13:36:05 |
penalvch |
libreoffice (Ubuntu): status |
New |
Confirmed |
|
2011-05-16 13:38:17 |
penalvch |
summary |
oocalc: wrong calculation with DCOUNT and DCOUNTA function |
Calc DCOUNT function does not throw error in malformed expression =DCOUNT(A4:E13,0,A16:E17) |
|
2011-05-16 13:46:38 |
penalvch |
description |
Binary package hint: openoffice.org
Calculations with DCOUNT or DCOUNTA function deliver wrong result. Either no occurrence is counted even if some elements of the database meet the criteria or much more occurrences are counted. Given that DCOUNT counts rows of a database -- i.e. an area -- the result should not be larger than the number of rows in that database.
Sample spreadsheet can be attached.
ProblemType: Bug
DistroRelease: Ubuntu 10.04
Package: openoffice.org-calc 1:3.2.0-7ubuntu4.1
ProcVersionSignature: Ubuntu 2.6.32-25.45-generic 2.6.32.21+drm33.7
Uname: Linux 2.6.32-25-generic i686
Architecture: i386
Date: Wed Nov 24 19:08:01 2010
ProcEnviron:
PATH=(custom, user)
LANG=en_US.utf8
SHELL=/bin/bash
SourcePackage: openoffice.org |
Binary package hint: openoffice.org
1_ lsb_release -rd
Description: Ubuntu 11.04
Release: 11.04
2) apt-cache policy libreoffice-calc
libreoffice-calc:
Installed: 1:3.3.2-1ubuntu5
Candidate: 1:3.3.2-1ubuntu5
Version table:
*** 1:3.3.2-1ubuntu5 0
500 http://us.archive.ubuntu.com/ubuntu/ natty-proposed/main i386 Packages
100 /var/lib/dpkg/status
1:3.3.2-1ubuntu4 0
500 http://us.archive.ubuntu.com/ubuntu/ natty/main i386 Packages
3) What is expected to happen in LibreOffice Calc via the Terminal:
cd ~/Desktop && wget https://bugs.launchpad.net/ubuntu/+source/openoffice.org/+bug/681080/+attachment/1743794/+files/OO_DCOUNT_problem_2.ods && localc -nologo OO_DCOUNT_problem_2.ods
is Sheet 1, cell B19's formula:
=DCOUNT(A4:E13,0,A16:E17)
throws an error as it is a malformed expression pointing to a non-existent column 0.
4) What happens instead is it erroneously yields 5.
WORKAROUND: Use Gnumeric as it throws an error.
apt-cache policy gnumeric
gnumeric:
Installed: 1.10.13-1ubuntu1
Candidate: 1.10.13-1ubuntu1
Version table:
*** 1.10.13-1ubuntu1 0
500 http://us.archive.ubuntu.com/ubuntu/ natty/universe i386 Packages
100 /var/lib/dpkg/status
ProblemType: Bug
DistroRelease: Ubuntu 10.04
Package: openoffice.org-calc 1:3.2.0-7ubuntu4.1
ProcVersionSignature: Ubuntu 2.6.32-25.45-generic 2.6.32.21+drm33.7
Uname: Linux 2.6.32-25-generic i686
Architecture: i386
Date: Wed Nov 24 19:08:01 2010
ProcEnviron:
PATH=(custom, user)
LANG=en_US.utf8
SHELL=/bin/bash
SourcePackage: openoffice.org |
|
2011-05-16 13:46:48 |
penalvch |
tags |
apport-bug i386 lucid |
apport-bug i386 lo33 lucid |
|
2011-05-16 13:53:02 |
penalvch |
description |
Binary package hint: openoffice.org
1_ lsb_release -rd
Description: Ubuntu 11.04
Release: 11.04
2) apt-cache policy libreoffice-calc
libreoffice-calc:
Installed: 1:3.3.2-1ubuntu5
Candidate: 1:3.3.2-1ubuntu5
Version table:
*** 1:3.3.2-1ubuntu5 0
500 http://us.archive.ubuntu.com/ubuntu/ natty-proposed/main i386 Packages
100 /var/lib/dpkg/status
1:3.3.2-1ubuntu4 0
500 http://us.archive.ubuntu.com/ubuntu/ natty/main i386 Packages
3) What is expected to happen in LibreOffice Calc via the Terminal:
cd ~/Desktop && wget https://bugs.launchpad.net/ubuntu/+source/openoffice.org/+bug/681080/+attachment/1743794/+files/OO_DCOUNT_problem_2.ods && localc -nologo OO_DCOUNT_problem_2.ods
is Sheet 1, cell B19's formula:
=DCOUNT(A4:E13,0,A16:E17)
throws an error as it is a malformed expression pointing to a non-existent column 0.
4) What happens instead is it erroneously yields 5.
WORKAROUND: Use Gnumeric as it throws an error.
apt-cache policy gnumeric
gnumeric:
Installed: 1.10.13-1ubuntu1
Candidate: 1.10.13-1ubuntu1
Version table:
*** 1.10.13-1ubuntu1 0
500 http://us.archive.ubuntu.com/ubuntu/ natty/universe i386 Packages
100 /var/lib/dpkg/status
ProblemType: Bug
DistroRelease: Ubuntu 10.04
Package: openoffice.org-calc 1:3.2.0-7ubuntu4.1
ProcVersionSignature: Ubuntu 2.6.32-25.45-generic 2.6.32.21+drm33.7
Uname: Linux 2.6.32-25-generic i686
Architecture: i386
Date: Wed Nov 24 19:08:01 2010
ProcEnviron:
PATH=(custom, user)
LANG=en_US.utf8
SHELL=/bin/bash
SourcePackage: openoffice.org |
Binary package hint: openoffice.org
1_ lsb_release -rd
Description: Ubuntu 11.04
Release: 11.04
2) apt-cache policy libreoffice-calc
libreoffice-calc:
Installed: 1:3.3.2-1ubuntu5
Candidate: 1:3.3.2-1ubuntu5
Version table:
*** 1:3.3.2-1ubuntu5 0
500 http://us.archive.ubuntu.com/ubuntu/ natty-proposed/main i386 Packages
100 /var/lib/dpkg/status
1:3.3.2-1ubuntu4 0
500 http://us.archive.ubuntu.com/ubuntu/ natty/main i386 Packages
LibreOffice 3.4.0
DEV300m103 (Build:5)
3) What is expected to happen in LibreOffice Calc via the Terminal:
cd ~/Desktop && wget https://bugs.launchpad.net/ubuntu/+source/openoffice.org/+bug/681080/+attachment/1743794/+files/OO_DCOUNT_problem_2.ods && localc -nologo OO_DCOUNT_problem_2.ods
is Sheet 1, cell B19's formula:
=DCOUNT(A4:E13,0,A16:E17)
throws an error as it is a malformed expression pointing to a non-existent column 0.
4) What happens instead is it erroneously yields 5. Occurs in both Ubuntu LO & 3.4.0 Beta.
WORKAROUND: Use Gnumeric as it throws an error.
apt-cache policy gnumeric
gnumeric:
Installed: 1.10.13-1ubuntu1
Candidate: 1.10.13-1ubuntu1
Version table:
*** 1.10.13-1ubuntu1 0
500 http://us.archive.ubuntu.com/ubuntu/ natty/universe i386 Packages
100 /var/lib/dpkg/status
ProblemType: Bug
DistroRelease: Ubuntu 10.04
Package: openoffice.org-calc 1:3.2.0-7ubuntu4.1
ProcVersionSignature: Ubuntu 2.6.32-25.45-generic 2.6.32.21+drm33.7
Uname: Linux 2.6.32-25-generic i686
Architecture: i386
Date: Wed Nov 24 19:08:01 2010
ProcEnviron:
PATH=(custom, user)
LANG=en_US.utf8
SHELL=/bin/bash
SourcePackage: openoffice.org |
|
2011-05-16 13:59:06 |
penalvch |
libreoffice (Ubuntu): importance |
Undecided |
Medium |
|
2011-05-16 13:59:06 |
penalvch |
libreoffice (Ubuntu): status |
Confirmed |
Triaged |
|
2011-05-16 14:04:38 |
penalvch |
bug watch added |
|
http://bugs.freedesktop.org/show_bug.cgi?id=37256 |
|
2011-05-16 14:04:38 |
penalvch |
bug task added |
|
df-libreoffice |
|
2011-05-16 14:22:29 |
Bug Watch Updater |
df-libreoffice: status |
Unknown |
Confirmed |
|
2011-05-16 14:22:29 |
Bug Watch Updater |
df-libreoffice: importance |
Unknown |
Low |
|
2011-05-17 19:16:51 |
penalvch |
bug task added |
|
gnumeric (Ubuntu) |
|
2011-05-17 19:17:17 |
penalvch |
gnumeric (Ubuntu): status |
New |
Invalid |
|
2011-07-20 21:52:51 |
Bug Watch Updater |
df-libreoffice: status |
Confirmed |
Invalid |
|
2011-07-21 22:03:01 |
Bug Watch Updater |
df-libreoffice: status |
Invalid |
Confirmed |
|
2011-08-03 18:52:25 |
Bug Watch Updater |
df-libreoffice: importance |
Low |
Wishlist |
|
2011-08-14 14:13:18 |
penalvch |
summary |
Calc DCOUNT function does not throw error in malformed expression =DCOUNT(A4:E13,0,A16:E17) |
[Upstream] Calc DCOUNT function does not throw error in malformed expression =DCOUNT(A4:E13,0,A16:E17) |
|
2011-09-15 14:18:13 |
Björn Michaelsen |
openoffice.org (Ubuntu): status |
New |
Won't Fix |
|
2014-01-04 18:34:45 |
Björn Michaelsen |
libreoffice (Ubuntu): importance |
Medium |
Wishlist |
|
2014-01-04 18:37:22 |
Björn Michaelsen |
libreoffice (Ubuntu): status |
Triaged |
Won't Fix |
|
2014-11-04 21:23:48 |
Bug Watch Updater |
df-libreoffice: status |
Confirmed |
Invalid |
|