Bug#267260: openoffice.org: oocalc's countif doesn't work with cell names

["David N. Welton" <davidw@debian.org>]

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