https://bugs.freedesktop.org/show_bug.cgi?id=74075
Priority: medium
Bug ID: 74075
Assignee: [email protected]
Summary: Strange Error when using INDEX and MATCH
Severity: minor
Classification: Unclassified
OS: Linux (All)
Reporter: [email protected]
Hardware: x86-64 (AMD64)
Status: UNCONFIRMED
Version: 4.1.3.2 release
Component: Libreoffice
Product: LibreOffice
I have a spreadsheet (made in Excel 2013, but I have made the sheet from
scratch in LO just to try) and i seems there is a strange error when LO handles
these functions.
I have a list (Letters in alphabet) in one coloum and a number next to it (a =
1, b = 2 etc, c = 3..) And I am using this function to call the number,
depending on what letters is inputted.
=IF(D1="","",INDEX($DATA.$B$1:$B$39,MATCH($PASSWORD.B5,$DATA.$A$1:$A$39)))
All letters UPTO "s" is fine, however all letters from this point gives an NA
value for a reason I cannot explain.
Me being silly or an actual bug?
Thanks!
--
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
