https://bugs.documentfoundation.org/show_bug.cgi?id=171065
Bug ID: 171065
Summary: Data Validity type Cell Range does not respect the
source list data types
Product: LibreOffice
Version: 26.8.0.0 alpha0+ master
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Created attachment 205843
--> https://bugs.documentfoundation.org/attachment.cgi?id=205843&action=edit
Test data
Open attached document. It contains a list in A2:A6 with cells with number and
cells with text content. The validity drop-drown in A9 uses this list.
Select an item in A9. Notice, that content is always handled as number
regardless of the data type in the source list.
Open the file in Excel and select an item in A9. Notice, that Excel keeps the
data type.
--
You are receiving this mail because:
You are the assignee for the bug.
