https://bugs.freedesktop.org/show_bug.cgi?id=73113
Priority: medium
Bug ID: 73113
Assignee: libreoffice-bugs@lists.freedesktop.org
Summary: LOOKUP function results in #N/A
Severity: normal
Classification: Unclassified
OS: Linux (All)
Reporter: andis.lazd...@gmail.com
Hardware: Other
Status: UNCONFIRMED
Version: 4.2.0.1 rc
Component: Libreoffice
Product: LibreOffice
Created attachment 91272
--> https://bugs.freedesktop.org/attachment.cgi?id=91272&action=edit
Sample file with not working lookup function
I found that LOOKUP function is not working in many files created in previous
versions of Libreoffice. A file attached to this report is an example of
merging 2 datasets using LOOKUP function. In sheet "Kopa" there is LOOKUP,
which is still working and in sheet "C" there is LOOKUP in column E, which is
not working any more in 4.2.0.1 (showing #N/A for me in all rows, except cell
E37, where correct result is shown). In 4.1.4.2 with the same locale settings
(Latvian) everything works fine.
Sheet "C" column F contains SUMIF function, which works fine with the same
search criteria.
I found similar problem with not working DAVERAGE function in previously
created files.
System: Ubuntu 13.04. 32 bit.
--
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
