[sc-issues] [Issue 97857] Dropdown list shows number format after setting validity as Date
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=97857 --- Additional comments from j...@openoffice.org Tue Sep 15 14:41:16 + 2009 --- Testing DEV300_m58 on Linux (Fedora 11): Looks ok now: the dropdown shows formatted dates instead of serial dates. Thanks! - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 97857] Dropdown list shows number format after setting validity as Date
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=97857 --- Additional comments from j...@openoffice.org Fri Aug 28 16:36:44 + 2009 --- 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? - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 97857] Dropdown list shows number format after setting validity as Date
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=97857 User amy2008 changed the following: What|Old value |New value Status|VERIFIED |CLOSED --- Additional comments from amy2...@openoffice.org Fri Jul 10 06:27:36 + 2009 --- Verified in DEV300m51 Closing - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 97857] Dropdown list shows number format after setting validity as Date
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=97857 User oc changed the following: What|Old value |New value Status|RESOLVED |VERIFIED --- Additional comments from o...@openoffice.org Mon Jun 8 09:42:55 + 2009 --- verified in internal build cws_calc50 - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 97857] Dropdown list shows number format after setting validity as Date
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=97857 --- Additional comments from o...@openoffice.org Mon Jun 8 09:08:21 + 2009 --- *** Issue 102537 has been marked as a duplicate of this issue. *** - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 97857] Dropdown list shows number format after setting validity as Date
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=97857 User nn changed the following: What|Old value |New value Assigned to|nn|oc --- Additional comments from n...@openoffice.org Thu May 28 14:21:11 + 2009 --- reassigning to QA for verification - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 97857] Dropdown list shows number format after setting validity as Date
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=97857 User nn changed the following: What|Old value |New value Status|NEW |RESOLVED Issue type|DEFECT|PATCH Resolution| |FIXED Target milestone|--- |OOo 3.2 --- Additional comments from n...@openoffice.org Tue May 5 16:33:29 + 2009 --- I added the last patch to CWS "calc50". - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 97857] Dropdown list shows number format after setting validity as Date
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=97857 User nn changed the following: What|Old value |New value Assigned to|spreadsheet |nn --- Additional comments from n...@openoffice.org Tue May 5 16:27:26 + 2009 --- taking the issue - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 97857] Dropdown list shows number format after setting validity as Date
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=97857 --- Additional comments from gaojing...@openoffice.org Tue Apr 28 08:18:48 + 2009 --- Created an attachment (id=61865) the updated patch for this issue, but it doesn't still work for external reference and a formula - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 97857] Dropdown list shows number format after setting validity as Date
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=97857 --- Additional comments from gaojing...@openoffice.org Wed Apr 22 05:46:46 + 2009 --- Created an attachment (id=61719) the updated patch of this issue - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 97857] Dropdown list shows number format after setting validity as Date
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=97857 User gaojingmei changed the following: What|Old value |New value CC|'cornouws,pj' |'cornouws,gaojingmei,lvyue | |,maoyg,nn,pj' - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 97857] Dropdown list shows number format after setting validity as Date
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=97857 --- Additional comments from gaojing...@openoffice.org Fri Apr 3 02:56:27 + 2009 --- Created an attachment (id=61373) the updated patch for this issue - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 97857] Dropdown list shows number format after setting validity as Date
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=97857 --- Additional comments from gaojing...@openoffice.org Thu Apr 2 09:24:33 + 2009 --- Created an attachment (id=61356) The patch of this issue. - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 97857] Dropdown list shows number format after setting validity as Date
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=97857 User cornouws changed the following: What|Old value |New value CC|'pj' |'cornouws,pj' --- Additional comments from corno...@openoffice.org Fri Feb 20 23:11:32 + 2009 --- 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. - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 97857] Dropdown list shows number format after setting validity as Date
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=97857 User amy2008 changed the following: What|Old value |New value OtherIssuesDependingOnTh| |84292 is| | - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 97857] Dropdown list shows number format after setting validity as Date
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=97857 Issue #|97857 Summary|Dropdown list shows number format after setting validi |ty as Date Component|Spreadsheet Version|DEV300m37 Platform|PC URL| OS/Version|All Status|NEW Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|code Assigned to|spreadsheet Reported by|amy2008 --- Additional comments from amy2...@openoffice.org Thu Jan 8 05:45:29 + 2009 --- 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 - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org