Issue 128538 - [Regression] Tooltip in Windows Explorer shows modified date in wrong format
Summary: [Regression] Tooltip in Windows Explorer shows modified date in wrong format
Status: UNCONFIRMED
Alias: None
Product: Internationalization
Classification: Code
Component: code (show other issues)
Version: 4.1.13
Hardware: PC Windows 10
: P5 (lowest) Normal (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords: regression
Depends on:
Blocks:
 
Reported: 2022-10-11 20:38 UTC by Stewart Gordon
Modified: 2022-11-06 16:46 UTC (History)
1 user (show)

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

Attachments
Screenshot of bug (25.09 KB, image/png)
2022-10-11 20:38 UTC, Stewart Gordon 		no flags Details
Document showing the problem (8.82 KB, application/vnd.oasis.opendocument.text)
2022-10-11 20:41 UTC, Stewart Gordon 		no flags Details
Windows 10 Explorer (french edition) (35.56 KB, image/png)
2022-11-04 09:35 UTC, oooforum (fr) 		no flags Details
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
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.