https://bugs.documentfoundation.org/show_bug.cgi?id=99343
Bug ID: 99343
Summary: Function MATCH() gives error
Product: LibreOffice
Version: 5.0.5.2 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Created attachment 124388
--> https://bugs.documentfoundation.org/attachment.cgi?id=124388&action=edit
Example showing the bug
The MATCH() function results in an error when the searched range has specific
values.
In the attached example the function is used in cell B2. It searches range
A5:A15 for the value noted in cell B3, using a ascending range. In this example
cell B3 shows the highest value in the range A5:A15. The MATCH() function works
fine, unless the range in A5:A15 starts below 99 AND contains the value 100.
For example if the range values add up from 81 to 91, the highest value is 91
and the MATCH function correctly finds the corresponding cell. Same goes for a
value range from 91 to 99. However when the value 100 is added to the list in
column A, the MATCH() function results in #N/B. Strangely this is not connected
to the value 100 perse. When the list in column A starts with 99, the function
produces a correct result even when the value 100 is also present in the list.
The bug can be avoided by using an exact match instead of an ascending range.
This is not always possible of course.
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
