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: [email protected]
Reporter: [email protected]
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._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
