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

    From David N. Welton@1:229/2 to All on Sat Aug 21 16:10:09 2004
    From: [email protected]

    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


    --
    To UNSUBSCRIBE, email to [email protected]
    with a subject of "unsubscribe". Trouble? Contact [email protected]

    --- SoupGate-Win32 v1.05
    * Origin: you cannot sedate... all the things you hate (1:229/2)