https://bugs.freedesktop.org/show_bug.cgi?id=71589
Priority: medium
Bug ID: 71589
Assignee: [email protected]
Summary: UI: LOOKUP function returns error.
Severity: normal
Classification: Unclassified
OS: Windows (All)
Reporter: [email protected]
Hardware: Other
Whiteboard: BSA
Status: UNCONFIRMED
Version: 4.1.3.2 release
Component: Spreadsheet
Product: LibreOffice
Created attachment 89169
--> https://bugs.freedesktop.org/attachment.cgi?id=89169&action=edit
A screenshot showing correct and wrong returns for this function.
Problem description:
When LOOKUP uses a non-numeric for the search term, an error is returned.
Steps to reproduce:
1. Open an instance of Calc, launch the Function Wizard.
2. Enter some data in a range, for example A1:D4, making sure the first row is
sorted in ascending order. Have the first row contain numerals and letters.
3. Select a blank cell. Double-click on LOOKUP in the function list.
4. Select a letter from row 1 as the search criterion and row 1 as the search
vector.
5. Select one of the remaining rows as the results vector and press OK.
Current behavior:
An error is returned.
Expected behavior:
Correct value should be returned.
This same problem seems to exist for the two parameter version of this
function.
Operating System: Windows XP
Version: 4.1.3.2 release
--
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
