https://bugs.freedesktop.org/show_bug.cgi?id=85078
Bug ID: 85078
Summary: LOOKUP cannot handle negative criterion
Product: LibreOffice
Version: unspecified
Hardware: x86-64 (AMD64)
OS: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Formula Editor
Assignee: [email protected]
Reporter: [email protected]
Created attachment 107908
--> https://bugs.freedesktop.org/attachment.cgi?id=107908&action=edit
financial spreadsheet where i was looking to find which month had the most
negative unreconciled balance. Sheet octiber, cell M2 has offending formula.
Problem description: LOOKUP doesn't handle negative search criterion correctly.
Steps to reproduce:
1. ....create lookup where search criterion is a negative number.
2. ....
3. ....
Current behaviour:Result of above lookup is "#N/A"
Expected behaviour:same behaviour as if search criterion was a positive value.
Attached spreadsheet October tab Cell M2 contains evidence.
Using any of the adjacent cells for the search criterion gives correct result.
however the K2 (negative criterion) results in the error.
I have checked for any spurious data (such as values created by calculation not
simple currency input) and there are none except simple addition and
subtraction of currency values.
The help file doesn't say that the criterion must be positive.
I am not sure if the help file line " Additionally, the search vector for the
LOOKUP must be sorted ascending, otherwise the search will not return any
usable results." is the reason but the adjacent lookup cells are not sorted and
give the expected result.
--
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
