[Libreoffice-bugs] [Bug 141146] New: LOOKUP picks data from unreferenced sheet

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 141146
           Summary: LOOKUP picks data from unreferenced sheet
           Product: LibreOffice
           Version: 7.0.5.2 release
          Hardware: x86-64 (AMD64)
                OS: Windows (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: s5t1e3v4e3m11 at hotmail.com

Description:
Using in the 2nd sheet the formula =LOOKUP(1,1/(A$2:A$11=E$1),1)
we get data from the 1st sheet if the search data is in the lookup vector
(please see attached example)


Steps to Reproduce:
Follow steps in attachment or start from empty sheet:

1. in 1st sheet in cell B1 put "unrelated data"
2. in 2nd sheet in cell E1 put "k2"
3. in 2nd sheet A2:A11 put the values "k1" to "k10"
4. in 2nd sheet in cell E4 put the formula =LOOKUP(1,1/(A$2:A$11=E$1),1)


Actual Results:
The formula delivers "unrelated data"

Expected Results:
Either showing an error or #N/A


Reproducible: Always


User Profile Reset: Yes



Additional Info:
If we put in E1 a value NOT in the lookup vector, the formula delivers #N/A,
which is correct.

More details can be found at
https://ask.libreoffice.org/en/question/298436/lookup-picks-data-from-unreferenced-sheet/

Version: 7.1.1.2 (x64) / LibreOffice Community
Build ID: fe0b08f4af1bacafe4c7ecc87ce55bb426164676
CPU threads: 4; OS: Windows 6.3 Build 9600; UI render: Skia/Raster; VCL: win
Locale: en-GB (en_GB); UI: en-US
Calc:

-- 
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/20210321/c8baaea9/attachment.htm>