desktop-packages team mailing list archive

[Björn Michaelsen <bjoern.michaelsen@xxxxxxxxxxxxx>]

** Changed in: openoffice.org (Ubuntu)
       Status: Triaged => Won't Fix

-- 
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/381543

Title:
  [Upstream] Calc VLOOKUP function doesn't produce same results as Excel

Status in LibreOffice Productivity Suite:
  Fix Released
Status in The OpenOffice.org Suite:
  New
Status in “libreoffice” package in Ubuntu:
  Fix Released
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-updates/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

  3) What is expected to happen in LibreOffice Calc via the Terminal:

  cd ~/Desktop && wget
  https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/381543/+attachment/596214/+files/vlookup%20testcase.xls
  && localc -nologo vlookup\ testcase.xls

  is the file obtains the same results as Excel or Gnumeric using
  VLOOKUP.

  4) What happens instead is it does not.

  WORKAROUND: Use Gnumeric.

  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

  Original Reporter Comments: When using the VLOOKUP function, the
  second parameter is interpreted as an array in OpenOffice, but Excel
  treats it as a range. This means that Excel spreadsheets that use a
  single cell reference will work in Excel, but not in OpenOffice. It
  should be possible to fix this by treating a single cell reference as
  a single element array.

  ProblemType: Bug
  Architecture: amd64
  DistroRelease: Ubuntu 9.04
  Package: openoffice.org-core 1:3.0.1-9ubuntu3
  ProcEnviron:
   PATH=(custom, no user)
   LANG=en_AU.UTF-8
   SHELL=/bin/bash
  SourcePackage: openoffice.org
  Uname: Linux 2.6.28-11-generic x86_64

To manage notifications about this bug go to:
https://bugs.launchpad.net/df-libreoffice/+bug/381543/+subscriptions