Apache OpenOffice (AOO) Bugzilla – Issue 124380
WIN Files Explorer in document tooltip shows date of modification as ISO 8601 instead of OS setting date format
Last modified: 2022-10-28 12:23:39 UTC
Created attachment 82818 [details] Test Kit This one is a spin off from "Bug 91067 - Tooltip in Windows Files Explorer shows modified date of OOo files in fixed format M/d/yyyy" Discussed behavior has been observed first by Edwin Sharp in <https://issues.apache.org/ooo/show_bug.cgi?id=91067#c19> I did tests with server installation of "AOO 4.1.0-Beta – German UI / German locale - [AOO410m14(Build:9760) - Rev. 1573601 2014-03-03 17:47:48]" on German WIN7 Home Premium (64bit)", own separate user profile; also French UI / French locale. You can do your own research with attached test kit with documents, screenshots, ... Facts: (a) WIN7 Files Explorer shows tooltips with date of modification (a1) for most documents my locale default format dd.mm.yyyy is used for the date formatting (a3) For LibO and AOO documents file format in tooltip is ISO 8601 yyyy-mm-dd. (a31) Date and Date contents is taken from <dc:date> (ODF V. 1.2 Part 1 4.3.2.10). I did a test, changes in that parameter of meta.xml change date shown in WIN Files Explorer Tooltip (a32) I did not understand info concerning date format in <dc:date> in ODF V. 1.2 (b) I created 2 documents with minimum text after I had changed all Language settings from de to fr. Date format did not change (d1) WIN files explorer did not show date of creation for newly created empty AOO documents, what do not contain <dc:date> information (d2) WIN files explorer did show date for newly created empty documents from othr software (except LibO) Thoughts (c) WIN would be free to show date info from document in any different format, so I believe current behavior is intended, not a bug (d) Observations might be related to "Bug 44257 - Save metadata in html/xhtml files using Dublin Core ", so <dc:date> format in meta.xml seems intended (e) Current behavior might have started with OOo 3, for OOo 2 WIN Files Explorer tooltips shown with dd.mm.yyyy. My skills are not sufficient to find out what the different might be causing that difference in format. My resume: Not a bug, intended; but might worry users
Currently I can't see a bigger importance for this. @Edwin: Your thoughts?
Why create this issue if you think this is not a bug? Why clutter Bugzilla with such "spin off" bugs? it is confusing and makes it even more difficult to find duplicates. Why be so inefficient about a single bug (91067) with importance field = minor? there are more than a thousand bugs in unconfirmed status craving for evaluation!
Comment 4 in "Bug 97818 - WIN Explorer Tooltip shows "T" as separator between Date and time instead of Blank" <https://issues.apache.org/ooo/show_bug.cgi?id=97818#c4> seem to show up some different root of the unexpected date view. If I understand that comment correctly, AOO should fill <dc:date> with a date information in accordance to Localization (OS? AOO?). But Experience and Attachment 82819 [details] for Bug 97818 seem to indicate that AOO always uses ISO format for information in <dc:date> So my My resume in original report might be wrong @hanya I wonder why documents from OOo 2.0.2 show the correct date formatting in WIN Explorer tooltips, although date source in meta.xml also is in ISO format? @Edwin Please excuse me for my inaccuracy, I intended to ask you for evaluation of technical details I listed in the report with technical knowledge.
@Edwin, hanya: Can you confirm that "modified202.odt" created with OOo 2.0.2 shows correct date formatting in WIN Explorer tooltips?
> @hanya > I wonder why documents from OOo 2.0.2 show the correct date formatting in > WIN Explorer tooltips, although date source in meta.xml also is in ISO > format? I checked the specification of ODF 1.2, 4.3.2.10 <dc:date>: >The <dc:date> element has content of data type dateTime 18.2. From 18.2W3C Schema Datatypes section, dateTime data type should follow xmlschema-2 [1]. And it tells: > The ·value space· of dateTime is closely related to the dates and times described in ISO 8601. > ... > The date and time datatypes described in this recommendation were inspired by [ISO 8601]. I do not know differences between two of them. It does not restrict existence of fractional seconds and also timezone. If they are there, they should be parsed as well. [1] http://www.w3.org/TR/xmlschema-2/#dateTime modified202.odt/meta.xml contains "2014-03-08T08:30:53" in dc:date element. It seems ok for the current implementation.
(In reply to hanya from comment #5) I did a test with "WithTextAOO.odtt/meta.xml" an deleted the trailing fractal seconds information: old: <dc:date>2014-03-08T07:21:14.34</dc:date> new: <dc:date>2014-03-08T07:21:14</dc:date> With new <dc:date> WIN explorer shows date in expected and common German format "08.03.2014 07:21:14" So may be WIN Explorer Tooltips have a problem with fractional seconds?
.doc (MSO97) and .docx (WORD2003 XML) saved from AOO are not affected, WIN Explorer shows date in tooltip correctly for these documents. I examined a .docx and found "<o:LastSaved>2014-03-09T16:38:56.74Z</o:LastSaved> used for modification time in Tooltip"; what ever the trailing "Z" might mean.
Created attachment 82824 [details] Document created with MSWORD 2010 Even documents.odt created from MS WORD 2010 show that problem, and even worse (they show the trailing "Z" I mentioned in document before). So I think this is a WIN Bug. If we don't have something like a "Microsoft Contact Group" I can report this problem to Microsoft. Independently we should think about dropping the second fractions until the problem with the WIN OS will have been fixed.
*** Issue 97818 has been marked as a duplicate of this issue. ***
WIN all due to DUP
I saw some worrying results, currently I can't tell what they mean. All Tests with AOO 4.0.1 Release – German UI / German locale [AOO401m5(Build:9714) - Rev. 1524958 2013-09-20 11:40:29]" on German WIN7 Home Premium (64bit)", “historic” 4.0 User Profile used for all predecessor versions. (f) Just for fun I switched my OS Settings to Date view ISO 8601. (g) Sample Document Bug 124189 downloaded afterwards did not show the problem (h) Even after an Edit Tooltip still showed correct Date/Time view (i) OS-Setting back to dd.mm.jjjj (i1) Tooltip for Sample Document Bug 124189 still ok (k) Additional edit in document (l) tooltip still ok (m) a newly created document shows the reported problem (n) OS / Region back to ISO 8601 (n1) Document from (n) still shows problem ("T" separator), <dc:date>2014-03-12T07:15:25.16</dc:date> (n2) Open - Edit - Save Document from (n), "T" separator has vanished, Tooltip ok, <dc:date>2014-03-12T07:17:13</dc:date> (n3) Does our <dc:date> contents format depend on OS Region settings? That all is rather strange! Can someone confirm these observations - and may be find a plausible reasoning?
Fixed in AOO 4.1.8