[Libreoffice-bugs] [Bug 42746] New: EDITING: Incorrect LOOKUP Function

[bugzilla-daemon at freedesktop.org]

https://bugs.freedesktop.org/show_bug.cgi?id=42746

             Bug #: 42746
           Summary: EDITING: Incorrect LOOKUP Function
    Classification: Unclassified
           Product: LibreOffice
           Version: LibO 3.3.2 release
          Platform: Other
        OS/Version: All
            Status: UNCONFIRMED
 Status Whiteboard: BSA
          Severity: normal
          Priority: medium
         Component: Spreadsheet
        AssignedTo: libreoffice-bugs at lists.freedesktop.org
        ReportedBy: jakenveina at yahoo.com


Created attachment 53331
  --> https://bugs.freedesktop.org/attachment.cgi?id=53331
The attachment is the specific spreadsheet with the specific set of data for
which LOOKUP is malfunctioning

Problem description:

In the attached spreadsheet, the LOOKUP Functions in Columns B and C are
failing to lookup correctly. The first errored result occurs in Row 9. The
value in A9 should be matched to the value in G9, causing the values in H9 and
I9 to be pushed to B9 and C9, respectively. Instead the LOOKUP function is
matching A9 to G37, and pulling from H37 and I37. This makes no sense as the
values in A9 and G37 clearly do not match. In the spreadsheet, I have even
copied the column G directly to column A, to ensure that the values are exactly
the same, regardless of formatting, and the same result occurs. I have also
tried formatting columns A and G as both numbers, and as plain text, and
re-entering all the values accordingly. Whether the columns are numbers or
text, the exact same result occurs. I have additionally checked that the
function "=(A9=A37)" returns FALSE for all of these circumstances.

Browser: Mozilla/5.0 (X11; Linux x86_64; rv:7.0.1) Gecko/20100101 Firefox/7.0.1

-- 
Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.