[Upstream] Calc DCOUNT function does not throw error in malformed expression =DCOUNT(A4:E13,0,A16:E17)
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
LibreOffice |
Invalid
|
Wishlist
|
|||
gnumeric (Ubuntu) |
Invalid
|
Undecided
|
Unassigned | ||
libreoffice (Ubuntu) |
Won't Fix
|
Wishlist
|
Unassigned | ||
openoffice.org (Ubuntu) |
Won't Fix
|
Undecided
|
Unassigned |
Bug 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://
100 /var/lib/
1:
500 http://
LibreOffice 3.4.0
DEV300m103 (Build:5)
3) What is expected to happen in LibreOffice Calc via the Terminal:
cd ~/Desktop && wget https:/
is Sheet 1, cell B19's formula:
=DCOUNT(
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://
100 /var/lib/
ProblemType: Bug
DistroRelease: Ubuntu 10.04
Package: openoffice.org-calc 1:3.2.0-7ubuntu4.1
ProcVersionSign
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
description: | updated |
tags: | added: lo33 |
description: | updated |
Changed in df-libreoffice: | |
importance: | Unknown → Low |
status: | Unknown → Confirmed |
Changed in gnumeric (Ubuntu): | |
status: | New → Invalid |
Changed in df-libreoffice: | |
status: | Confirmed → Invalid |
Changed in df-libreoffice: | |
status: | Invalid → Confirmed |
Changed in df-libreoffice: | |
importance: | Low → Wishlist |
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) |
Changed in openoffice.org (Ubuntu): | |
status: | New → Won't Fix |
Changed in df-libreoffice: | |
status: | Confirmed → Invalid |
Created attachment 46765 problem_ 2.ods
OO_DCOUNT_
Downstream bug may be found at: /bugs.launchpad .net/ubuntu/ +source/ libreoffice/ +bug/681080
https:/
1_ lsb_release -rd
Description: Ubuntu 11.04
Release: 11.04
2) apt-cache policy libreoffice-calc us.archive. ubuntu. com/ubuntu/ natty-proposed/main i386 Packages dpkg/status 3.3.2-1ubuntu4 0 us.archive. ubuntu. com/ubuntu/ natty/main i386 Packages
libreoffice-calc:
Installed: 1:3.3.2-1ubuntu5
Candidate: 1:3.3.2-1ubuntu5
Version table:
*** 1:3.3.2-1ubuntu5 0
500 http://
100 /var/lib/
1:
500 http://
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.