Public bug reported: Binary package hint: openoffice.org
The help for vlookup says for the 4th parameter: in unordered lists the searched value must match exact. In OOo trailing spaces are not taken into account. This is not bad on its own, but is an incomptibility to MS-office, so tables safed as .xls look fine in OOo but fail in ms-office. In the attached file the value "ref2 " at cell A7 has a trailing space, the searchvalue in A20 has not. In OOo displayes a non-error-result in cell F20, while ms-office displayesa #NV value. I filed this against OpenOffice.org directly in bug <http://www.openoffice.org/issues/show_bug.cgi?id=107380>. The answer was: You can configure OOo what kind of "exact" you want to use. Goto Tools > Options > Calc > Calculate. Check the item "Search criteria and <> must apply to whole cells" to get the same behavior as Excel. I tested this with the windows version and they are true. But with OpenOffice.org (same build: 9420) on ubuntu the "Search criteria and <> must apply to whole cells" option has no effect on the example file, so I think it a ubuntu specific bug. ProblemType: Bug Architecture: i386 Date: Fri Dec 4 08:59:51 2009 DistroRelease: Ubuntu 9.10 Package: openoffice.org-core 1:3.1.1-5ubuntu1 [modified: var/lib/openoffice/basis3.1/program/services.rdb] ProcEnviron: PATH=(custom, user) LANG=de_AT.UTF-8 SHELL=/bin/bash ProcVersionSignature: Ubuntu 2.6.31-15.50-generic SourcePackage: openoffice.org Uname: Linux 2.6.31-15-generic i686 XsessionErrors: (gnome-settings-daemon:3213): GLib-CRITICAL **: g_propagate_error: assertion `src != NULL' failed (gnome-settings-daemon:3213): GLib-CRITICAL **: g_propagate_error: assertion `src != NULL' failed (polkit-gnome-authentication-agent-1:3432): GLib-CRITICAL **: g_once_init_leave: assertion `initialization_value != 0' failed (nautilus:3305): Eel-CRITICAL **: eel_preferences_get_boolean: assertion `preferences_is_initialized ()' failed ** Affects: openoffice.org (Ubuntu) Importance: Undecided Status: New ** Tags: apport-bug i386 -- vlookup exact does not mean exact https://bugs.launchpad.net/bugs/492186 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://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
