Apache OpenOffice (AOO) Bugzilla – Issue 97857
Dropdown list shows number format after setting validity as Date
Last modified: 2013-08-07 15:14:30 UTC
Can reproduce it with DEV300m37 on WinXP and Fedora How to reproduce it 1 Create a new Calc document 2 Select A1, right_click and Format cells, switch to Numbers - Date (select one format like ****/**/** ), enter date e.g. 2008-12-5 in A1 3 Select another cell b2, Data - Validity - Criteria Allow as 'Cell Range', Source as 'A1' - OK 4 Click Dropdown list Result Find list item is number format Expectation List item is Date format Regards Meiying
Hi Meiying, I also see this in OOo 3.0.1 The number we see of course is the internal number representation of the date in A1 (Related (already so for a long time): when you want to enter a date as criteria for validation, you have to enter the number representation.
Created attachment 61356 [details] The patch of this issue.
Created attachment 61373 [details] the updated patch for this issue
Created attachment 61719 [details] the updated patch of this issue
Created attachment 61865 [details] the updated patch for this issue, but it doesn't still work for external reference and a formula
taking the issue
I added the last patch to CWS "calc50".
reassigning to QA for verification
*** Issue 102537 has been marked as a duplicate of this issue. ***
verified in internal build cws_calc50
Verified in DEV300m51 Closing
This is still not working for me, testing m54 on Fedora Linux. Should I start a new issue, or is there some integration detail that I've missed?
Testing DEV300_m58 on Linux (Fedora 11): Looks ok now: the dropdown shows formatted dates instead of serial dates. Thanks!