[Libreoffice-bugs] [Bug 141976] New: HLOOKUP not working when (..) in lookup field

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 141976
           Summary: HLOOKUP not working when (..) in lookup field
           Product: LibreOffice
           Version: 7.1.2.2 release
          Hardware: All
                OS: Windows (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: documentfoundation at datenbank-projekt.de

Description:
a working hlookup does not work, when in the first row (where the lookup takes
place) is a () contained in the source.
Example: 
WVERWEIS($J$9;$J$11:$O$25;ZEILE()-3;0) works, when the first line is
Barcodes, QR-Codes, RFID und NFC
or
Backup und Datensicherung
but it shows a #NV when the first line is
Network Attached Storage (NAS) in Unternehmen und Privathaushalt


Steps to Reproduce:
1. put WVERWEIS($J$9;$J$11:$O$25;ZEILE()-3;0) in C6
2. have data in J9 limited to an area and have a dropdown there to choose items
3. place these in the area for the lookup of J9 which is
$Tabelle1.$J$11:$Tabelle1.$N$11

So, J11 holds
Barcodes, QR-Codes, RFID und NFC

K11 holds nothing (empty cell)

L11 holds
Network Attached Storage (NAS) in Unternehmen und Privathaushalt

M11 holds nothing (empty cell)
N11 holds
Backup und Datensicherung

Note: There might be another bug in the limited data field (J9 here). Even when
ignoring empty cells (options for valid data) there is one empty line shown in
the dropdown.

Actual Results:
When J9 contains
Barcodes, QR-Codes, RFID und NFC
hlookup works

Network Attached Storage (NAS) in Unternehmen und Privathaushalt                
hlookup fails and #nv is shown in C6

Backup und Datensicherung
hlookup works


Expected Results:
correct lookup 


Reproducible: Always


User Profile Reset: No



Additional Info:
[Information automatically included from LibreOffice]
Locale: de
Module: SpreadsheetDocument
[Information guessed from browser]
OS: Windows (All)
OS is 64bit: yes

-- 
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/20210429/2d1768a7/attachment-0001.htm>