2009-05-29 05:47:32 |
Kieran Fleming |
bug |
|
|
added bug |
2009-05-29 05:47:32 |
Kieran Fleming |
attachment added |
|
The output should be 'dog' in both columns http://launchpadlibrarian.net/27259986/vlookup%20testcase.xls |
|
2009-05-29 05:47:32 |
Kieran Fleming |
attachment added |
|
Dependencies.txt http://launchpadlibrarian.net/27259987/Dependencies.txt |
|
2009-06-01 01:04:01 |
Kieran Fleming |
tags |
amd64 apport-bug |
apport-bug |
|
2009-06-01 06:33:54 |
Adonis Papaderos |
openoffice.org (Ubuntu): status |
New |
Confirmed |
|
2009-06-08 04:27:19 |
Chris Cheney |
bug task added |
|
openoffice |
|
2009-06-08 04:27:37 |
Chris Cheney |
openoffice.org (Ubuntu): importance |
Undecided |
Low |
|
2009-06-08 04:27:37 |
Chris Cheney |
openoffice.org (Ubuntu): status |
Confirmed |
Triaged |
|
2010-05-13 22:06:12 |
Chris Cheney |
tags |
apport-bug |
apport-bug jaunty |
|
2011-05-31 05:40:49 |
penalvch |
bug task added |
|
libreoffice (Ubuntu) |
|
2011-05-31 05:44:10 |
penalvch |
description |
Binary package hint: openoffice.org
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.
Test case attached.
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 |
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 |
|
2011-05-31 05:44:31 |
penalvch |
tags |
apport-bug jaunty |
apport-bug jaunty lo33 |
|
2011-05-31 05:45:25 |
penalvch |
libreoffice (Ubuntu): importance |
Undecided |
Medium |
|
2011-05-31 05:45:25 |
penalvch |
libreoffice (Ubuntu): status |
New |
Triaged |
|
2011-05-31 05:46:12 |
penalvch |
summary |
OpenOffice Calc VLOOKUP function doesn't work like Excel |
Calc VLOOKUP function doesn't produce same results as Excel |
|
2011-05-31 05:54:47 |
penalvch |
bug watch added |
|
http://bugs.freedesktop.org/show_bug.cgi?id=37776 |
|
2011-05-31 05:54:47 |
penalvch |
bug task added |
|
df-libreoffice |
|
2011-05-31 07:22:27 |
Bug Watch Updater |
df-libreoffice: status |
Unknown |
Confirmed |
|
2011-05-31 07:22:27 |
Bug Watch Updater |
df-libreoffice: importance |
Unknown |
Medium |
|
2011-06-14 19:52:59 |
Bug Watch Updater |
df-libreoffice: status |
Confirmed |
Fix Released |
|
2011-08-14 14:11:47 |
penalvch |
summary |
Calc VLOOKUP function doesn't produce same results as Excel |
[Upstream] Calc VLOOKUP function doesn't produce same results as Excel |
|
2011-08-31 19:55:57 |
penalvch |
libreoffice (Ubuntu): status |
Triaged |
Fix Released |
|
2011-09-15 14:18:13 |
Björn Michaelsen |
openoffice.org (Ubuntu): status |
Triaged |
Won't Fix |
|
2011-09-19 16:34:11 |
penalvch |
openoffice: status |
New |
Invalid |
|