Issue 128538

Summary: [Regression] Tooltip in Windows Explorer shows modified date in wrong format
Product: Internationalization Reporter: Stewart Gordon <smjg>
Component: codeAssignee: AOO issues mailing list <issues>
Status: UNCONFIRMED --- QA Contact:
Severity: Normal    
Priority: P5 (lowest) CC: oooforum
Version: 4.1.13Keywords: regression
Target Milestone: ---   
Hardware: PC   
OS: Windows 10   
Issue Type: DEFECT Latest Confirmation in: ---
Developer Difficulty: ---
Attachments:
Description Flags
Screenshot of bug
none
Document showing the problem
none
Windows 10 Explorer (french edition) none

Description Stewart Gordon 2022-10-11 20:38:49 UTC 
Created attachment 87150 [details]
Screenshot of bug

This was previously reported as bug 91067 and closed as fixed.  However, the problem has come back.  Not sure whether it's related to bug 124380 - maybe this is a different failure mode under an older OOO version, or has a different cause altogether.

Steps to reproduce:
1. Have your regional settings set up as United Kingdom.  Presumably any country that uses DMY dates would work.
2. Save a document using OpenOffice.
3. Open the document's folder in Explorer.
4. Hover the mouse over the file.

Actual result:
The tooltip displays "10/11/2022 9:26:26 PM" instead of "11/10/2022 21:26".  Crucially, it shows the date as 10 November instead of 11 October.  See the attached screenshot.

Expected result:
The tooltip should display the date correctly per the user's regional settings, in this case "11/10/2022 21:26".
If the date is stored as a formatted string in the file, meaning that it won't display correctly for another user who has different regional settings, OOO needs to store it in an unambiguous format, such as "11 Oct 2022 21:26:26" or the ISO format, "2022-10-11 21:26:26".
Comment 1 Stewart Gordon 2022-10-11 20:41:50 UTC 
Created attachment 87151 [details]
Document showing the problem
Comment 2 oooforum (fr) 2022-11-03 19:24:55 UTC 
You set [regression] in the title. Which previous build has not this issue?

Tested on Windows 7 x64 Pro french and OpenOffice 4.1.13
No problem, date in properties's document is same as tooltip in Windows Explorer.
11/10/2022, 21:26:26, Stewart Gordon
Comment 3 Stewart Gordon 2022-11-04 00:13:57 UTC 
(In reply to oooforum (fr) from comment #2)
> You set [regression] in the title. Which previous build has not this issue?

Whichever one is the basis for bug 91067 having been marked as fixed.

> Tested on Windows 7 x64 Pro french and OpenOffice 4.1.13
> No problem, date in properties's document is same as tooltip in Windows
> Explorer.

What's a "properties's document"?
Comment 4 oooforum (fr) 2022-11-04 09:35:51 UTC 
Created attachment 87154 [details]
Windows 10 Explorer (french edition)

As you see in attached screenshot, I don't reproduce too on Windows 10.

You will find the properties in File menu.
Comment 5 Stewart Gordon 2022-11-06 16:46:39 UTC 
Hmm.  Same version of OpenOffice and same version of Windows, yet the bug is affecting some users but not others.  Very weird.

I just tried temporarily changing my regional settings to France and it didn't make a difference.  So it would seem that there's some factor at work causing it to sometimes honour regional settings and sometimes not.  This needs further investigation.