https://bugs.freedesktop.org/show_bug.cgi?id=66648
Priority: medium
Bug ID: 66648
Assignee: libreoffice-bugs@lists.freedesktop.org
Summary: Using VLOOKUP to find a period (.) in an unsorted list
returns the index for 'M'. Everything else OK.
Severity: major
Classification: Unclassified
OS: Linux (All)
Reporter: jogde...@yahoo.com
Hardware: x86-64 (AMD64)
Status: UNCONFIRMED
Version: unspecified
Component: Spreadsheet
Product: LibreOffice
I am using VLOOKUP to search an unordered list to find words, symbols,
punctuation marks, etc. It works fine for everything except a period(.). It
always gives me the letter 'M'. The list contains 75,500 entries and the period
is located approximately 2,000 entries down the list from the 'M'. Here's the
syntax I am using: =VLOOKUP(AS$3,$Y1:Z$75500,2,0).
I swapped the positions of the M and period and it works fine. It properly
finds both the period and M. Strange happenings ...... Any ideas??
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
