Apache OpenOffice (AOO) Bugzilla – Full Text Issue Listing |
Summary: | Date Format in "Edit Field: Variables" Dialog | ||||||||
---|---|---|---|---|---|---|---|---|---|
Product: | Writer | Reporter: | luddite1812 <luddite1812> | ||||||
Component: | ui | Assignee: | AOO issues mailing list <issues> | ||||||
Status: | CONFIRMED --- | QA Contact: | |||||||
Severity: | Trivial | ||||||||
Priority: | P3 | CC: | issues, lars_o_hansen | ||||||
Version: | OOo 2.0.1 | Keywords: | needmoreinfo, oooqa | ||||||
Target Milestone: | --- | ||||||||
Hardware: | All | ||||||||
OS: | All | ||||||||
Issue Type: | ENHANCEMENT | Latest Confirmation in: | --- | ||||||
Developer Difficulty: | --- | ||||||||
Attachments: |
|
Description
luddite1812
2006-01-17 13:35:30 UTC
Reassigned to ES. probably duplicate to issue 59919? Please describe step by step what you insert and which format you choose. I have a field in the writer document that is a date. 1) I right click on it, 2) then select 'field' 3) then I get the "Edit Field: Variables" Dialog there the date value is incorrect. For example, the date format selected is '31 Dec 1999'. Today's date of '17 Jan 2006' appears in the value text area as '38734'. Please attach a sample document. No answer closed Created attachment 33984 [details]
"Edit Fields: Variables" date field problem screen shot as requested.
I attached the screen shot of the problem, as requested. Sorry for the delay. It depends on how the date has been defined when the variable has been set. Th e variable is a number, so 38734 is ok and corresponds to Jan 17, 2006. 31 Dec 1999 is only a sample in the list, it is not intended to be the current date. Consequently, 17 Jan 2006 is 38734 formatted with the 31 Dec 1999 date format. -> no bug. Closed I would have felt that the value should be displayed in accordance with the selected format? I do not see what use such a 5 digit number is to a user who wants to specify or review the date. I wish to report this same problem, with an attached example. There is no problem if the number format is one of the built-in date formats, but if I change to 'DD/MM/YY;;#' (so indirections to empty cells appear empty), the edit field shows a 5-digit number. Most annoying when I wish merely to correct a date. Created attachment 34451 [details]
trivial spreadsheet showing problem
->peteredwards: your problem is a Calc problem. File an issue for the Spreadsheet component. Reassigned to Requirements This Issue requires more information ('needmoreinfo'), but has not been updated within the last year. Please re-test with one of the latest versions of OOo - the problem(s) may have already been addressed. Either use the recent stable version: http://download.openoffice.org/index.html or consider trying the new OOo 3 BETA (still in testing): http://download.openoffice.org/3.0beta/ Please report back the outcome so this Issue may be closed or progressed as necessary - otherwise it may be Resolved as Invalid in the future. You may also wish to search for (and note) any duplicates of this Issue that may have advanced further : http://www.openoffice.org/issues/query.cgi Many thanks, Andrew Cleaning-up and Closing old Issues as part of: ~ The Grand Bug Squash, pre v3 ~ |