[Libreoffice-bugs] [Bug 141989] New: Calc VLOOKUP from DATA VALIDATION cell returns N/A for two of the validated values

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 141989
           Summary: Calc VLOOKUP from DATA VALIDATION cell returns N/A for
                    two of the validated values
           Product: LibreOffice
           Version: 7.0.5.2 release
          Hardware: All
                OS: Windows (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: that.man.colin at gmail.com

Description:
Sample File [Array Error.ods] attached.
A4 is the validated data list
B5 is a manual choice of column C,D,E or F to be returned
B8 is the return from the A4 & B5 selection criteria
When the array elements [CELL A4] for August or December are selected then the
return is N/A 



Steps to Reproduce:
Array C5:F16 is named Sales
Array C5:C16 is named Month
Array D5:D16 is named Prod_1
Array E5:E16 is named Prod_2
Array F5:F16 is named Prod_3
Range C3:F3 is simply the column number for the array lookup
Range C4:F4 is simply the column header and a reminder of the Array name
Select a validated month from A4
Enter a column number in B5 (It will accept 1 which returns the month name at
B8
Observe the returned value from table "Sales" in B8 
Try August or December in A4
The Months were initially created by dragfill on January
Please feel free to remove all the colours and conditional format if they are
too distracting. They are only intended to highlight the relevant array cells.
Note: Common multiples of 150 have produced duplicate numbers - they were also
dragfilled ;))


Actual Results:
August and December return N/A

Expected Results:
August, December and approriate numbers from the "Sales" array


Reproducible: Always


User Profile Reset: No


OpenGL enabled: Yes

Additional Info:
Version: 7.0.5.2 (x64)
Build ID: 64390860c6cd0aca4beafafcfd84613dd9dfb63a
CPU threads: 4; OS: Windows 10.0 Build 19042; UI render: Skia/Raster; VCL: win
Locale: sv-SE (en_GB); UI: en-GB
Calc: threaded

-- 
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/20210430/a367e4d2/attachment.htm>