Bug 36673 - FORMATTING: Date format in LibO 3.4 different from LibO 3.3
Summary: FORMATTING: Date format in LibO 3.4 different from LibO 3.3
Status: RESOLVED FIXED
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: LibreOffice (show other bugs)
Version:
(earliest affected)
3.4.0 Beta3
Hardware: Other All
: high normal
Assignee: Katarina Behrens
URL:
Whiteboard:
Keywords: regression
: 36670 (view as bug list)
Depends on:
Blocks: mab3.4
  Show dependency tree / graph
 
Reported: 2011-04-29 07:26 UTC by André Schnabel
Modified: 2011-05-12 12:41 UTC (History)
5 users (show)

See Also:
Crash report or crash signature:

Attachments
sample file with several dates (91.99 KB, application/vnd.oasis.opendocument.spreadsheet)
2011-04-29 07:26 UTC, André Schnabel 		Details
Sample Document, see Comment 5 (20.29 KB, application/vnd.oasis.opendocument.text)
2011-05-03 00:13 UTC, Rainer Bielefeld Retired 		Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description André Schnabel 2011-04-29 07:26:26 UTC 
Created attachment 46156 [details]
sample file with several dates

Dates in spreadsheets are displayed in a different format when opened in 3.4 then it was formatted in 3.3.

E.g."MM/DD/YY" in 3.3 becomes "MMM D, YY" in 3.4. See attached spreadsheet file for more examples.

Time codes are not affected. Seems to be caused by removal of two date format codes in 3.4 - see screenshots in the spreadsheet file
Comment 1 Kohei Yoshida 2011-04-29 07:37:14 UTC 
Bubli, could you take a look at this one?
Comment 2 vitriol 2011-04-29 07:55:10 UTC 
Bug 36670 is the same?
Comment 3 André Schnabel 2011-04-29 08:15:44 UTC 
*** Bug 36670 has been marked as a duplicate of this bug. ***
Comment 4 Kim Bastin 2011-05-02 19:53:35 UTC 
After uninstalling 3.4 and reinstalling 3.3.2, dates continue to appear in the wrong format introduced with 3.4. E.g. a date entered in Writer 3.3.2 to appear as Friday 29 April 2011, which displayed as 29/04/2011 in 3.4, now continues to display 29/04/2011 even after uninstalling 3.4 and reinstalling 3.3.2.
Comment 5 Rainer Bielefeld Retired 2011-05-03 00:11:30 UTC 
[Reproducible] with "LibreOffice 3.4Beta3  – WIN7  Home Premium  (64bit) German UI [DEV300m103 (Build:3)]". I see exactly the reported problem in CALC, at least under particular circumstances. A cell formatted as DD.MM.YY in 3.3 will be shown as DD. MMM.YY with LibO3.4Beta3 for a normal entry, but not for "=today()"

Problem is not limited to Spreadsheet, also WRITER is affected, pls. see my attached "sample from 3.1.1_a.odt". That document has been created with OOo 3.1.1 because I do not have LibO 3.3 on my PC, but the effect "Date formatting changes when opened with LibO 3.4Beta"  is exactly the same.
Comment 6 Rainer Bielefeld Retired 2011-05-03 00:13:18 UTC 
Created attachment 46278 [details]
Sample Document, see Comment 5
Comment 7 Kim Bastin 2011-05-03 03:09:58 UTC 
Further to Comment 4: after reverting to 3.3.2, the incorrect date format introduced by 3.4 beta3 persists in both Calc and Writer.
Comment 8 Katarina Behrens 2011-05-04 06:50:04 UTC 
> Time codes are not affected. Seems to be caused by removal of two date format
> codes in 3.4 - see screenshots in the spreadsheet file

They're actually not removed, just moved a bit down the list as the order of formats somehow shuffled in 3.4 (no idea why so far). It's a mess :(
Comment 9 Katarina Behrens 2011-05-12 03:20:19 UTC 
Fixed then for 3.4 (commit 8d08e19822871)
Comment 10 Johannes Weberhofer 2011-05-12 12:41:50 UTC 
It's now working correctly on my OSX with today's daily build images