Apache OpenOffice (AOO) Bugzilla – Issue 128538
[Regression] Tooltip in Windows Explorer shows modified date in wrong format
Last modified: 2022-11-06 16:46:39 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".
Created attachment 87151 [details] Document showing the problem
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
(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"?
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.
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.