https://bugs.documentfoundation.org/show_bug.cgi?id=92333
Bug ID: 92333
Summary: Vlookup is broken
Product: LibreOffice
Version: 4.3.3.2 release
Hardware: x86-64 (AMD64)
OS: Linux (All)
Status: UNCONFIRMED
Severity: major
Priority: medium
Component: Calc
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: fpoul...@metrodore.fr
Created attachment 116827
--> https://bugs.documentfoundation.org/attachment.cgi?id=116827&action=edit
The option screen
See the .ods attached.
I made a very simple list with 3 items. I make three simple research on it. 2
of them give false or unexpected result.
Note: the "entire cell" option is disabled.
PS: "recherche" stands for "lookup", in french.
Here is my Debian version of LO:
$ apt show libreoffice
Package: libreoffice
Version: 1:4.3.3-2
Installed-Size: 126 kB
Maintainer: Debian LibreOffice Maintainers <debian-openoff...@lists.debian.org>
Depends: fonts-sil-gentium-basic, libreoffice-base, libreoffice-calc,
libreoffice-core (= 1:4.3.3-2), libreoffice-draw, libreoffice-impress,
libreoffice-math, libreoffice-report-builder-bin, libreoffice-writer,
libreoffice-avmedia-backend-gstreamer | libreoffice-avmedia-backend-vlc,
fonts-dejavu, libreoffice-java-common (>= 1:4.3.3~), python3-uno (>= 4.0~) |
python-uno
Recommends: fonts-liberation | ttf-mscorefonts-installer, libpaper-utils
Suggests: cups-bsd, hunspell-dictionary, hyphen-hyphenation-patterns, iceweasel
| firefox | icedove | thunderbird | iceape-browser | mozilla-browser,
imagemagick | graphicsmagick-imagemagick-compat, libgl1, libreoffice-gnome |
libreoffice-kde, libreoffice-grammarcheck, libreoffice-help-4.3,
libreoffice-l10n-4.3, libsane, libxrender1, myspell-dictionary,
mythes-thesaurus, openclipart-libreoffice, pstoedit, unixodbc,
gstreamer1.0-plugins-base, gstreamer1.0-plugins-good,
gstreamer1.0-plugins-ugly, gstreamer1.0-plugins-bad, gstreamer1.0-ffmpeg,
default-jre | gcj-jre | openjdk-7-jre | openjdk-6-jre | sun-java5-jre |
sun-java6-jre | java5-runtime | jre, libreoffice-officebean
Homepage: http://www.libreoffice.org
Tag: role::metapackage
Section: metapackages
Priority: optional
Download-Size: 69,7 kB
APT-Manual-Installed: yes
APT-Sources: http://ftp.be.debian.org/debian/ jessie/main amd64 Packages
Description: office productivity suite (metapackage)
LibreOffice is a full-featured office productivity suite that provides
a near drop-in replacement for Microsoft(R) Office.
.
This metapackage installs all components of libreoffice:
* libreoffice-writer: Word processor
* libreoffice-calc: Spreadsheet
* libreoffice-impress: Presentation
* libreoffice-draw: Drawing
* libreoffice-base: Database
* libreoffice-math: Equation editor
.
You can extend the functionality of LibreOffice by installing these
packages:
* hunspell-*/myspell-*: Hunspell/Myspell dictionaries
for use with LibreOffice
* libreoffice-l10n-*: UI interface translation
* libreoffice-help-*: User help
* mythes-*: Thesauri for the use with LibreOffice
* hyphen-*: Hyphenation patterns for LibreOffice
* libreoffice-gtk: Gtk UI Plugin, GNOME File Picker support,
QuickStarter for GNOMEs notification are
* libreoffice-gnome: GIO, GConf backend
* libreoffice-kde: KDE UI Plugin and KDE File Picker support
* unixodbc: ODBC database support
* cups-bsd: Allows LibreOffice to detect your CUPS printer queues
automatically
* libsane: Use your sane-supported scanner with LibreOffice
* libxrender1: Speed up display by using Xrender library
* libgl1: OpenGL support
* openclipart-libreoffice: Open Clip Art Gallery with LibreOffice index
files
* iceweasel | firefox | icedove | thunderbird | iceape-browser |
mozilla-browser:
Mozilla profile with Certificates needed for XML Security...
* openjdk-6-jre | gcj-jre | java5-runtime:
Java Runtime Environment for use with LibreOffice
* pstoedit / imagemagick: helper tools for EPS thumbnails
* gstreamer0.10-plugins-*: GStreamer plugins for use with LibreOffices
media backend
* libpaper-utils: papersize detection support via paperconf
* bluez: Bluetooth support for Impress (slideshow remote control
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
