|
Apache OpenOffice (AOO) Bugzilla – Full Text Issue Listing |
| Summary: | date/time is displayed as different format in exported odp | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|
| Product: | Impress | Reporter: | Tang Meng <tmyl2010> | ||||||||
| Component: | save-export | Assignee: | AOO issues mailing list <issues> | ||||||||
| Status: | UNCONFIRMED --- | QA Contact: | |||||||||
| Severity: | Normal | ||||||||||
| Priority: | P3 | CC: | levente.l.balint, phoenix.wanglf, tfedor | ||||||||
| Version: | 4.0.0-dev | ||||||||||
| Target Milestone: | --- | ||||||||||
| Hardware: | All | ||||||||||
| OS: | All | ||||||||||
| Issue Type: | DEFECT | Latest Confirmation in: | --- | ||||||||
| Developer Difficulty: | --- | ||||||||||
| Attachments: |
|
||||||||||
I am looking at this bug. Created attachment 79113 [details]
sample file
I was unable to reproduce this on 3.5.0 (r1400866) on Windows 7 Professional N SP1 (x64). I also tried to reproduce the bug on a Mac OSX Lion v10.7 by following the steps but failed there as well (used the same 3.5.0 snapshot build r1400866) I was finally successful in reproducing the issue on v3.4.1. Although there were some conditions that I needed to alter in the initial report in order to reproduce it (please see Investigation on 3.4.1 for further details on this) On Win7 I tried to vary some of the specific steps in the description to see if I could reproduce it in some other form: - use the file in the report instead of creating the file - create pptx file instead of ppt mentioned - change initial locale to Romanian and THEN to Chinese - change locale from English-US to Romanian INSTEAD of Chinese - change the file exported from ppt to otp - change Date/Time setting from Variable to Fixed - manually set the Date’s Format and Language on the Header and Footer menu (under Automatically update) instead of leaving it on the default values - re-adding the Date/Time in the Footer in the odp then saving>reopening file These tests all failed in reproducing this specific bug. My personal take on this issue is that it got “resolved” sometime between the initial bug report and r1400866 (basing this on the tests I have run on different configurations/versions) Investigation on 3.4.1:
The bug only reproduces if the Update automatically option is selected on Date and Time. If it’s set to Fixed, the bug does not reproduce.
The bug does not seem to be specific to any locale or locale change. I was able to reproduce it with RO and HU settings as well.
In addition to this, the bug reproduces on the initially created ppt. as well. (when opening it with Impress 3.4.1 the date on the footer appeared in Chinese) This led me to believe that the behavior reproduces with any format supported by impress (this would be a good set of followup tests)
Alternate steps to reproduce (on 3.4.1):
1. Create ppt with MS Powerpoint on a machine with a certain locale
(e.g. en-US)
2. Add footer Date and Time to the ppt
(go to Insert > Header & Footer > tick Date and Time > select Update automatically > Apply to All)
3. Change locale for the machine(e.g. Chinese)
(Control Panel > Clock Language and Region > Change date/time/format > Format tab)
>> this might require a system restart for changes to take effect
4. Open the ppt in Impress
Expected: the ppt Footer displays in English
Actual: the Date format is in Chinese
Mac OS X 10.7.5, PPT for Mac 2011 Version 14.3.7, OpenOffice 4.0.1 While I am able to reproduce this concern, I believe this behavior is expected as standard internationalization functionality. Here are some supporting ideas/reasons for this: * Compared to PPT, behavior is the same, PPT and OO Presentation are dependent on computer locale when the date/time update automatically option is chosen. * Other OpenOffice applications exhibit the same behavior. * An excerpt from the book The Tiny Guide to OpenOffice.org, by Benjamin Horst, ISBN 1-930919-66-2 -- says a bit about this "…Each inserted field will be automatically updated with the correct metadata, taken from your computer's internal clock…" These are my steps to reproduce: * confirm computer is in English locale * create PPT presentation * insert footer * there are two options here, choice of which determines auto updating of date/time (see attachment) ** Update Automatically ** Fixed ** choose Update Automatically and use the drop-down to select format, Apply * save PPT * open PPT in OO Presentation, save as odp and then close OO * change computer locale to Chinese (or any other locale), save * open OO and open the OO Presentation * notice the date/time is now in Chinese format (which is my expectation with this process) * close OO * change computer locale back to English now to see how English locale will stay throughout this process: * confirm computer is in English locale * create PPT presentation * insert footer ** choose Fixed, enter date in free text field, Apply * save PPT * open PPT in OO Presentation, save as odp and then close OO * change computer locale to Chinese (or any other locale), save * open OO and open the OO Presentation * notice the date/time is in English format (which is my expectation with this process) Created attachment 81953 [details] Update Automatically vs. Fixed PPT footer for Comment #6 |
Created attachment 79106 [details] sample file with English header/footer 1. create a ppt file in MS-PPT with date/time in footer in an english locale machine. (sample file in attachment) 2. open the ppt in Aoo and save as odp. 3. Change the system locale to Chinese and change system date/time format to Chinese. 4. relaunch Aoo, reopen the odp Defect: the data/time format in footer is changed to Chinese format. It should be the English format.