** Also affects: libreoffice (Ubuntu)
Importance: Undecided
Status: New
** Description changed:
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 Exc
** Tags added: jaunty
--
OpenOffice Calc VLOOKUP function doesn't work like Excel
https://bugs.launchpad.net/bugs/381543
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
--
ubuntu-bugs mailing list
ubuntu-bugs@lists.ubuntu.com
https://li
** Also affects: openoffice
Importance: Undecided
Status: New
** Changed in: openoffice.org (Ubuntu)
Importance: Undecided => Low
** Changed in: openoffice.org (Ubuntu)
Status: Confirmed => Triaged
--
OpenOffice Calc VLOOKUP function doesn't work like Excel
https://bugs.laun
** Changed in: openoffice.org (Ubuntu)
Status: New => Confirmed
--
OpenOffice Calc VLOOKUP function doesn't work like Excel
https://bugs.launchpad.net/bugs/381543
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
--
ubuntu-bugs mai
Well, I don't really want to get into the question of who is following the spec
the closest, because we all know that MS and specs don't mix :)
I can't see a big problem with accepting a single value in this function, and
it would help compatibility with Excel, which is good for users. I should
** Tags removed: amd64
--
OpenOffice Calc VLOOKUP function doesn't work like Excel
https://bugs.launchpad.net/bugs/381543
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
--
ubuntu-bugs mailing list
ubuntu-bugs@lists.ubuntu.com
https://l
I'm not an expert on this, thought after reading
http://office.microsoft.com/en-us/excel/HP100698351033.aspx
I get the impression that openoffice behaves more closely to the ms vlookup
specification than excel.
--
OpenOffice Calc VLOOKUP function doesn't work like Excel
https://bugs.launchpad.ne
** Attachment added: "The output should be 'dog' in both columns"
http://launchpadlibrarian.net/27259986/vlookup%20testcase.xls
** Attachment added: "Dependencies.txt"
http://launchpadlibrarian.net/27259987/Dependencies.txt
--
OpenOffice Calc VLOOKUP function doesn't work like Excel
https