https://bugs.freedesktop.org/show_bug.cgi?id=76562
Priority: medium
Bug ID: 76562
Assignee: [email protected]
Summary: MATCH function doesn't work for large arrays
Severity: normal
Classification: Unclassified
OS: Windows (All)
Reporter: [email protected]
Hardware: x86-64 (AMD64)
Status: UNCONFIRMED
Version: 4.2.1.1 release
Component: Spreadsheet
Product: LibreOffice
When the array given in the MATCH function is larger than exactly 207 rows, it
always returns #N/A.
Not working example:
MATCH(1;A2:A208;1)
Working example:
MATCH(1;A2:A207;1)
The type of data doesn't matter. The sheet it's pulling data from doesn't
matter. The comparison type doesn't matter. The value to be compared against
doesn't matter.
--
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
