Apache OpenOffice (AOO) Bugzilla – Full Text Issue Listing
|Summary:||Dropdown list shows number format after setting validity as Date|
|Status:||CLOSED FIXED||QA Contact:||issues@sc <issues>|
|Priority:||P3||CC:||cno, gaojingmei, issues, lvyue, niklas.nebel, peter.junge, yonggang.mao|
|Issue Type:||PATCH||Latest Confirmation in:||---|
|Issue Depends on:|
Description amy2008 2009-01-08 05:45:29 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
Comment 1 cno 2009-02-20 23:11:32 UTC
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.
Comment 2 gaojingmei 2009-04-02 10:24:33 UTC
Created attachment 61356 [details] The patch of this issue.
Comment 3 gaojingmei 2009-04-03 03:56:27 UTC
Created attachment 61373 [details] the updated patch for this issue
Comment 4 gaojingmei 2009-04-22 06:46:46 UTC
Created attachment 61719 [details] the updated patch of this issue
Comment 5 gaojingmei 2009-04-28 09:18:48 UTC
Created attachment 61865 [details] the updated patch for this issue, but it doesn't still work for external reference and a formula
Comment 6 niklas.nebel 2009-05-05 17:27:26 UTC
taking the issue
Comment 7 niklas.nebel 2009-05-05 17:33:29 UTC
I added the last patch to CWS "calc50".
Comment 8 niklas.nebel 2009-05-28 15:21:11 UTC
reassigning to QA for verification
Comment 9 oc 2009-06-08 10:08:21 UTC
*** Issue 102537 has been marked as a duplicate of this issue. ***
Comment 10 oc 2009-06-08 10:42:55 UTC
verified in internal build cws_calc50
Comment 11 amy2008 2009-07-10 07:27:36 UTC
Verified in DEV300m51 Closing
Comment 12 Joe Smith 2009-08-28 17:36:44 UTC
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?
Comment 13 Joe Smith 2009-09-15 15:41:16 UTC
Testing DEV300_m58 on Linux (Fedora 11): Looks ok now: the dropdown shows formatted dates instead of serial dates. Thanks!