[Date Prev][Date Next] [Thread Prev][Thread Next] [Date Index] [Thread Index]

Bug#463329: openoffice.org-calc: LOOKUP function doesn't work as documented



Package: openoffice.org-calc
Version: 2.0.4.dfsg.2-7etch4
Severity: important

*** Please type your report below this line ***

The LOOKUP function returns highest value, less or equal searched one,
when it cannot find the searched value.
Documentation of LOOKUP function doesn't mention about that.This
couses one can spend really many hours investigating why the function
doesn't work as expected or worse - stay with wrong resoults even not
knowing about that.

The latest openoffice version - 2.3 has more complete description of
the function, including note about situation described above.

-- System Information:
Debian Release: 4.0
  APT prefers stable
  APT policy: (500, 'stable')
Architecture: amd64 (x86_64)
Shell:  /bin/sh linked to /bin/bash
Kernel: Linux 2.6.18-5-amd64
Locale: LANG=pl_PL.UTF-8, LC_CTYPE=pl_PL.UTF-8 (charmap=UTF-8)



Reply to: