https://bugs.documentfoundation.org/show_bug.cgi?id=94510
Bug ID: 94510
Summary: Validity list of dates converted to numbers inside
list
Product: LibreOffice
Version: 5.0.2.2 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Created attachment 119024
--> https://bugs.documentfoundation.org/attachment.cgi?id=119024&action=edit
validity list shows date as general numbers
Supose you create two named ranges:
- one constant 'fixed_range' ranges from: $Sheet1.$A$3:$A$30
- second dynamic size 'dynamic_range' ranges using this formula:
$Sheet1.$A$3:INDEX($Sheet1.$A$3:$A$30,COUNT($Sheet1.$A$3:$A$30))
Let's say the data are formatted as date.
Create two validaty cells which items are linked to names 'fixed_range' and
'dynamic_range'.
When you open dynamic_range list the date are shown as general numbers not on
date format actually.
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
