Bug#267260: marked as done (openoffice.org: oocalc's countif doesn't work with cell names)
Your message dated Sat, 21 Aug 2004 20:09:18 +0200
with message-id <1093111758.1940.39.camel@feathers>
and subject line Bug#267260: openoffice.org: oocalc's countif doesn't work with cell names
has caused the attached Bug report to be marked as done.
This means that you claim that the problem has been dealt with.
If this is not the case it is now your responsibility to reopen the
Bug report if necessary, and/or fix the problem forthwith.
(NB: If you are a system administrator and have no idea what I am
talking about this indicates a serious mail system misconfiguration
somewhere. Please contact me immediately.)
Debian bug tracking system administrator
(administrator, Debian Bugs database)
--------------------------------------
Received: (at submit) by bugs.debian.org; 21 Aug 2004 13:54:56 +0000
>From davidw@dedasys.com Sat Aug 21 06:54:56 2004
Return-path: <davidw@dedasys.com>
Received: from host4-67.pool80117.interbusiness.it (dedasys.com) [80.117.67.4]
by spohr.debian.org with esmtp (Exim 3.35 1 (Debian))
id 1ByWKe-0002a9-00; Sat, 21 Aug 2004 06:54:56 -0700
Received: by dedasys.com (Postfix, from userid 1000)
id 86A094C171; Sat, 21 Aug 2004 15:52:03 +0200 (CEST)
Content-Type: text/plain; charset="us-ascii"
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
From: "David N. Welton" <davidw@debian.org>
To: Debian Bug Tracking System <submit@bugs.debian.org>
Subject: openoffice.org: oocalc's countif doesn't work with cell names
X-Mailer: reportbug 2.63
Date: Sat, 21 Aug 2004 15:52:02 +0200
Message-Id: <[🔎] 20040821135203.86A094C171@dedasys.com>
Delivered-To: submit@bugs.debian.org
X-Spam-Checker-Version: SpamAssassin 2.60-bugs.debian.org_2004_03_25
(1.212-2003-09-23-exp) on spohr.debian.org
X-Spam-Status: No, hits=-8.0 required=4.0 tests=BAYES_00,HAS_PACKAGE
autolearn=no version=2.60-bugs.debian.org_2004_03_25
X-Spam-Level:
Package: openoffice.org
Version: 1.1.2-2
Severity: normal
Hi,
I have a spreadsheet something like this:
1
1
1
5
5
5
10
10
20
20
20
20
And I want to do this:
=COUNTIF(A2:A1000;"<=G2")
where G2 is some cutoff value.
=COUNTIF(A2:A1000;"<=10")
does work, though.
Thanks,
Dave
-- System Information:
Debian Release: 3.1
APT prefers testing
APT policy: (500, 'testing')
Architecture: powerpc (ppc)
Kernel: Linux 2.6.6
Locale: LANG=en_US, LC_CTYPE=en_US
Versions of packages openoffice.org depends on:
ii dictionaries-common [openoffi 0.22.30.1 Common utilities for spelling dict
ii openoffice.org-bin 1.1.2-2 OpenOffice.org office suite binary
ii openoffice.org-debian-files 1.1.2-3+1 Debian specific parts of OpenOffic
ii openoffice.org-l10n-en [openo 1.1.2-2 English (US) language package for
ii openoffice.org-l10n-it [openo 1.1.2-2 Italian language package for OpenO
ii ttf-opensymbol 1.1.2-2 The OpenSymbol TrueType font
-- no debconf information
---------------------------------------
Received: (at 267260-close) by bugs.debian.org; 21 Aug 2004 18:36:04 +0000
>From halls@debian.org Sat Aug 21 11:36:04 2004
Return-path: <halls@debian.org>
Received: from moutng.kundenserver.de [212.227.126.185]
by spohr.debian.org with esmtp (Exim 3.35 1 (Debian))
id 1Byaii-0000lj-00; Sat, 21 Aug 2004 11:36:04 -0700
Received: from [212.227.126.206] (helo=mrelayng.kundenserver.de)
by moutng.kundenserver.de with esmtp (Exim 3.35 #1)
id 1Byaih-0003pJ-00
for 267260-close@bugs.debian.org; Sat, 21 Aug 2004 20:36:03 +0200
Received: from [80.128.231.73] (helo=wallace.thehalls.de)
by mrelayng.kundenserver.de with asmtp (Exim 3.35 #1)
id 1Byaih-0002t0-00
for 267260-close@bugs.debian.org; Sat, 21 Aug 2004 20:36:03 +0200
Received: from feathers (feathers [192.168.10.4])
by wallace.thehalls.de (Postfix) with ESMTP id 13938990E
for <267260-close@bugs.debian.org>; Sat, 21 Aug 2004 20:09:06 +0200 (CEST)
Received: by feathers (Postfix, from userid 1050)
id 2B9AF8007; Sat, 21 Aug 2004 20:09:18 +0200 (CEST)
Subject: Re: Bug#267260: openoffice.org: oocalc's countif doesn't work with
cell names
From: Chris Halls <halls@debian.org>
To: 267260-close@bugs.debian.org
In-Reply-To: <[🔎] 20040821135203.86A094C171@dedasys.com>
References: <[🔎] 20040821135203.86A094C171@dedasys.com>
Content-Type: text/plain
Content-Transfer-Encoding: 7bit
Message-Id: <1093111758.1940.39.camel@feathers>
Mime-Version: 1.0
X-Mailer: Ximian Evolution 1.4.6
Date: Sat, 21 Aug 2004 20:09:18 +0200
X-Provags-ID: kundenserver.de abuse@kundenserver.de auth:b46e2b357ea7d4f6cadf4c99fb902606
Delivered-To: 267260-close@bugs.debian.org
X-Spam-Checker-Version: SpamAssassin 2.60-bugs.debian.org_2004_03_25
(1.212-2003-09-23-exp) on spohr.debian.org
X-Spam-Status: No, hits=-6.0 required=4.0 tests=BAYES_00,HAS_BUG_NUMBER
autolearn=no version=2.60-bugs.debian.org_2004_03_25
X-Spam-Level:
On Sat, 2004-08-21 at 15:52, David N. Welton wrote:
> And I want to do this:
>
> =COUNTIF(A2:A1000;"<=G2")
>
> where G2 is some cutoff value.
The BTS is not a user support forum, please take your question to an
appropriate forum. You should have noticed from the high count of bugs
in the BTS that the maintainers have far too much to do already without
this sort of 'bug report'.
At a guess, you can't put the name of a cell in a string and expect OOo
to know that you didn't really mean the text "G2". Perhaps you need to
get the value of G2 out with the CELL function, but I'm a packager not a
spreadsheet function expert, sorry.
Chris
Reply to: