Launchpad has imported 6 comments from the remote bug at https://bugs.freedesktop.org/show_bug.cgi?id=37256.
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 2011-05-16T07:04:10+00:00 Christopher M. Penalver wrote: Created attachment 46765 OO_DCOUNT_problem_2.ods Downstream bug may be found at: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/681080 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. Reply at: https://bugs.launchpad.net/ubuntu/+source/openoffice.org/+bug/681080/comments/3 ------------------------------------------------------------------------ On 2011-07-20T03:08:25+00:00 Markus Mohrhard wrote: this is not a bug as http://wiki.services.openoffice.org/wiki/Documentation/How_Tos/Calc:_DCOUNT_function mentions 0 is used for all columns Reply at: https://bugs.launchpad.net/ubuntu/+source/openoffice.org/+bug/681080/comments/7 ------------------------------------------------------------------------ On 2011-07-21T08:39:44+00:00 Christopher M. Penalver wrote: (In reply to comment #1) > this is not a bug > > as > http://wiki.services.openoffice.org/wiki/Documentation/How_Tos/Calc:_DCOUNT_function > mentions 0 is used for all columns [email protected], as mentioned in the above link: "Issues: The exact use of 0 as the field parameter is unclear, both in operation and in compatibility (issue 84168)". As well, Microsoft clears up what it means via: http://office.microsoft.com/en-us/excel-help/dcount-HP005209049.aspx The field parameter is not supposed to have a 0 in it as field is the column to use. A 0 column does not make sense. Hence, LO should throw an error for Excel compatibility reasons (Gnumeric also throws the error appropriately). Reply at: https://bugs.launchpad.net/ubuntu/+source/openoffice.org/+bug/681080/comments/8 ------------------------------------------------------------------------ On 2011-08-02T15:55:51+00:00 Markus Mohrhard wrote: No we are not Excel and we have our own formula api. As mentionen in the link I posted O is allowed and refers to all columns. This is not a bug but a feature! We are not a excel copy so we don't need to behave in the same way. Reply at: https://bugs.launchpad.net/ubuntu/+source/openoffice.org/+bug/681080/comments/9 ------------------------------------------------------------------------ On 2011-08-02T18:51:59+00:00 Christopher M. Penalver wrote: [email protected], thank you for your attention on this issue. (In reply to comment #3) > No we are not Excel and we have our own formula api. I never said LibreOffice was Excel. > As mentionen in the link I posted O is allowed and refers to all columns. While 0 is currently allowed, it does not hold compatibility with Excel or Gnumeric as noted in Comment #2. > This is not a bug but a feature! Ok, this bug has been remarked as ENHANCEMENT. Reply at: https://bugs.launchpad.net/ubuntu/+source/openoffice.org/+bug/681080/comments/10 ------------------------------------------------------------------------ On 2014-11-04T03:32:43+00:00 Jmadero-dev wrote: As Markus already explained that this is a feature - it's not getting changed. Markus is one of our most experienced developers. Please don't reopen the bug. Reply at: https://bugs.launchpad.net/ubuntu/+source/openoffice.org/+bug/681080/comments/13 ** Changed in: df-libreoffice Status: Confirmed => Invalid -- 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/681080 Title: [Upstream] Calc DCOUNT function does not throw error in malformed expression =DCOUNT(A4:E13,0,A16:E17) Status in LibreOffice Productivity Suite: Invalid Status in “gnumeric” package in Ubuntu: Invalid Status in “libreoffice” package in Ubuntu: Won't Fix Status in “openoffice.org” package in Ubuntu: Won't Fix 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://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 To manage notifications about this bug go to: https://bugs.launchpad.net/df-libreoffice/+bug/681080/+subscriptions -- Mailing list: https://launchpad.net/~desktop-packages Post to : [email protected] Unsubscribe : https://launchpad.net/~desktop-packages More help : https://help.launchpad.net/ListHelp
