[Libreoffice-bugs] [Bug 116428] New: lookup function does not evaluates properly when used with MIN function

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=116428

            Bug ID: 116428
           Summary: lookup function does not evaluates properly when used
                    with MIN function
           Product: LibreOffice
           Version: 5.0 all versions
          Hardware: x86-64 (AMD64)
                OS: Linux (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: LibreOffice
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: justo.sabadell at gmail.com

Description:
In an array with columns A to E and 9 rows, I use lookup to search for the
maximum and minimum vale in each of the columns B to E and to report the
corresponding text on column A.

When using maximum, it works ok. When using minimum, it results on #N/A except
for the first evaluated column (B).

Steps to Reproduce:
1.Build a (at least) nx3 matrix: e.g. 9x3, where the first column (A) is
composed of text cells and the second and third (B and C) of numbers
2.Use formula with lookup function, e.g. in cell B10 use
"=LOOKUP(MIN(B1:B9),B1:B9,A1:A9)"
3.Use similar formula for C10:"=LOOKUP(MIN(C1:C9),C1:C9,A1:A9)"

Actual Results:  
Then, the results in cells B10 and C10 are:
- B10 -> gets the text in the A-column cell corresponding to the row that has
the minimum value among B1:B9, as expected
- C10 -> just gets #N/A

Expected Results:
C10 should behave as B10, given the text in the A-column cell which corresponds
to the row where the minimum value from C1:C9 is.


Reproducible: Always


User Profile Reset: Yes



Additional Info:
IT evaluates correctly for the first column only. If the matrix has 3 or more
columns and trhe funtion is used, then it fails for all columns evaluated but
the first.
Funny enough it doesn't fails with MAX. 
It also fails if referred to another cell that reports MIN(C1:C9): e.g
"=LOOKUP(C11,C1:C9,A1:A9)", while C11 is "=MIN(C1:C9)".



User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:45.0) Gecko/20100101
Firefox/45.0

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20180316/a7659694/attachment-0001.html>