https://bugs.freedesktop.org/show_bug.cgi?id=50369
Bug #: 50369
Summary: : Formula function LOOKUP() does not work properly
Classification: Unclassified
Product: LibreOffice
Version: LibO 3.5.3 release
Platform: Other
OS/Version: All
Status: UNCONFIRMED
Status Whiteboard: BSA
Severity: normal
Priority: medium
Component: Spreadsheet
AssignedTo: [email protected]
ReportedBy: [email protected]
Created attachment 62122
--> https://bugs.freedesktop.org/attachment.cgi?id=62122
A sample workbook to demonstrate the issue.
Problem description:
The LOOKUP() function does not lookup all cells properly: N/A is returned.
Steps to reproduce:
1. Create two data columns
2. Fill in LOOKUP() formulas
3. Copy one column data to lookup the other column's data
Current behavior:
Several rows contain N/A.
Expected behavior:
Second calculated column should be identical to the second data column.
Platform (if different from the browser):
Windows XP SP3
Browser: Mozilla/5.0 (Windows NT 5.1; rv:12.0) Gecko/20100101 Firefox/12.0
Note:
I have tested this on original OO 3.2.1 release and the behavior is the same,
so I believe it is a bug inherited from OO.
--
Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
