Issue 60703 - Date Format in "Edit Field: Variables" Dialog
Summary: Date Format in "Edit Field: Variables" Dialog
Alias: None
Product: Writer
Classification: Application
Component: ui (show other issues)
Version: OOo 2.0.1
Hardware: All All
: P3 Trivial with 2 votes (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Keywords: needmoreinfo, oooqa
Depends on:
Reported: 2006-01-17 13:35 UTC by luddite1812
Modified: 2013-08-07 14:38 UTC (History)
2 users (show)

See Also:
Latest Confirmation in: ---
Developer Difficulty: ---

"Edit Fields: Variables" date field problem screen shot as requested. (19.76 KB, image/jpeg)
2006-02-09 02:41 UTC, luddite1812
no flags Details
trivial spreadsheet showing problem (6.88 KB, application/vnd.sun.xml.calc)
2006-02-25 16:14 UTC, peteredwards
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description luddite1812 2006-01-17 13:35:30 UTC
When I edit a date in the "Edit Field: Variables" Dialog the value is incorrect.

For example, the date format is '31 Dec 1999'. Today's date of '17 Jan 2006'
appears in the value text area as '38734'.
Comment 1 michael.ruess 2006-01-17 14:31:23 UTC
Reassigned to ES.
Comment 2 lars 2006-01-17 17:18:46 UTC
probably duplicate to issue 59919?
Comment 3 eric.savary 2006-01-18 11:01:35 UTC
Please describe step by step what you insert and which format you choose.
Comment 4 luddite1812 2006-01-18 16:22:56 UTC
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'.
Comment 5 eric.savary 2006-01-24 13:40:46 UTC
Please attach a sample document.
Comment 6 eric.savary 2006-02-08 15:14:17 UTC
No answer
Comment 7 eric.savary 2006-02-08 15:14:45 UTC
Comment 8 luddite1812 2006-02-09 02:41:11 UTC
Created attachment 33984 [details]
"Edit Fields: Variables" date field problem screen shot as requested.
Comment 9 luddite1812 2006-02-09 02:42:17 UTC
I attached the screen shot of the problem, as requested.

Sorry for the delay.
Comment 10 eric.savary 2006-02-09 09:10:24 UTC
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.
Comment 11 eric.savary 2006-02-09 14:51:35 UTC
Comment 12 luddite1812 2006-02-09 15:47:48 UTC
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.
Comment 13 peteredwards 2006-02-25 16:10:46 UTC
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.
Comment 14 peteredwards 2006-02-25 16:14:30 UTC
Created attachment 34451 [details]
trivial spreadsheet showing problem
Comment 15 eric.savary 2006-02-27 11:05:27 UTC
->peteredwards: your problem is a Calc problem. File an issue for the
Spreadsheet component.

Reassigned to Requirements
Comment 16 ace_dent 2008-05-15 15:25:09 UTC
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
or consider trying the new OOo 3 BETA (still in testing):
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 :
Many thanks,
Cleaning-up and Closing old Issues as part of:
~ The Grand Bug Squash, pre v3 ~