https://bugs.documentfoundation.org/show_bug.cgi?id=153312
Bug ID: 153312
Summary: EDITING Data Validation/Vlookup pulldown list won't
work unless items alphabetical
Product: LibreOffice
Version: 7.4.4.2 release
Hardware: All
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
I created a simple example of a pulldown list consisting of a vertical list of
items. If the items are not in alphabetical order, the pulldown does not work.
The pulldown can select an item that's not alphabetical, but the adjacent
VLOOKUP function to have that selection put a value in another cell doesn't
work.
I've attached a simple example to illustrate.
A5:A8 - list of pulldown items
B5:B8 - list of data I want when I select the corresponding A item
D4 is the pulldown to select
E4 contains the result of the pulldown data from column B.
If you pulldown and select FFF you get Ftoo.
If you pulldown and select DDD you get Dtoo.
If you pulldown and select BBB you get a blank (probably error)
If you pulldown and select AAA you get a blank
If I reorder the data in A5:B8 alphabetically, it works, I get the
-too data in E4 as expected.
Steps to Reproduce:
1.See description
2.
3.
Actual Results:
See description
Expected Results:
See description
Reproducible: Always
User Profile Reset: No
Additional Info:
Version: 7.4.4.2 (x64) / LibreOffice Community
Build ID: 85569322deea74ec9134968a29af2df5663baa21
CPU threads: 12; OS: Windows 10.0 Build 22621; UI render: Skia/Vulkan; VCL: win
Locale: en-US (en_US); UI: en-US
Calc: threaded
--
You are receiving this mail because:
You are the assignee for the bug.
