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: libreoffice-bugs@lists.freedesktop.org Reporter: curcio...@gmail.com 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 Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs