Issue 91334 - Formatted field in dialog does not format date
Summary: Formatted field in dialog does not format date
Alias: None
Product: General
Classification: Code
Component: scripting (show other issues)
Version: OOo 1.0.0
Hardware: PC Windows, all
: P3 Normal (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Depends on:
Reported: 2008-07-03 10:30 UTC by bmarcelly
Modified: 2014-01-01 09:15 UTC (History)
2 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: 4.1.0-dev
Developer Difficulty: ---

Dialog with a formatted field : incorrect display (12.24 KB, application/vnd.oasis.opendocument.text)
2008-07-03 10:32 UTC, bmarcelly
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description bmarcelly 2008-07-03 10:30:49 UTC
Regression found on 2.4.1 and 2.3.1. Was correct in 1.1.5.

Put a FormattedField control in a dialog (see next attachment).
Set the format to, for example:
in french(FR) : 31 décembre 1999 23:59:59
in English (USA) : Friday, December 31, 1999 
or : Fri, December 31, 1999
or : 12/31/1999 23:59:59

Both with dialog Test mode and at run time, the control displays the date serial 
number instead of a formatted date.
Comment 1 bmarcelly 2008-07-03 10:32:05 UTC
Created attachment 54913 [details]
Dialog with a formatted field : incorrect display
Comment 2 Rainer Bielefeld 2014-01-01 09:15:21 UTC
Reproducible with "AOO 4.0.1   – German UI / German locale  [Rev. 1524958 2013-09-20 11:40:29]" on  German WIN7 Home Premium (64bit)", “historic”  4.0  User Profile used for all  predecessor versions:

0. Allow Macro execution in Security settings, relaunch AOO
1. From AOO Start center start reporter's sample document
2. Menu 'Tools -> Macros -> Run Macro -> FormattedFieldDate.odt -> FormatDate'
   Bug: "Date et heure" message appears, shows Number Value "36526"
        instead of "01.01.2000"
3. [Ok]
   > A Date - Time value will be shown correctly

Additional Info:
(a) Was still ok with OOo 2.0.2
(b) Still Reproducible with server installation of "AOO 4.1.0-Dev – English  UI 
    / English locale - [AOO410m1(Build:9750)  -  Rev. 1554205 - 2014-01-01]" 
    on German WIN7 Home Premium (64bit)", own separate user profile.
(c)  Already reproducible with  Pre-3.4.0 (OOo 2.3.1), but because of crippled  
     Version selector (Bug 123063) no useful info can be contributed