Bug 165876 - FILE PROPERTIES: Timestamps do not update correctly when switching time zones
Summary: FILE PROPERTIES: Timestamps do not update correctly when switching time zones
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: filters and storage (show other bugs)
Version:
(earliest affected)
24.8.5.2 release
Hardware: All Linux (All)
: medium minor
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2025-03-23 16:01 UTC by Mohamed Zaghloul
Modified: 2025-06-02 05:52 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:

Attachments
notice timestamp still display the original timestamp from UTC-4 (09:05:42) (61.62 KB, image/png)
2025-03-23 16:01 UTC, Mohamed Zaghloul 		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 Mohamed Zaghloul 2025-03-23 16:01:18 UTC 
Created attachment 199973 [details]
notice timestamp still display the original timestamp from UTC-4 (09:05:42)

Steps to Reproduce:
1. Set system timezone to America/New_York (UTC-4).
2. Open LibreOffice and create a new document in Writer.
3. Save the document in format you wish to test
4. Close LibreOffice.
5. Change the system timezone to Africa/Cairo (UTC+2).
6. Open the saved documents and check their timestamps in File > Properties > General tab.

Observed Behavior:
- Some formats (e.g., .odt, .docx, .rtf, .html) still display the original timestamp from UTC-4 instead of adjusting to UTC+2.
- Some formats show 00:00:00 instead of the correct timestamps.
- Templates (.ott) replace the original creation timestamp with the current system time.
- Only Word 97-2003 (.doc) correctly converted 09:00 → 15:00 based on the timezone change.

Expected Behavior:
LibreOffice should store timestamps in UTC and adjust the displayed time based on the system’s current timezone.

Related: Bug 65209 - FILEOPEN: MS Word document properties creation times etc. time zones not preserved/displayed
Comment 1 Andrew Kopf 2025-06-01 19:55:05 UTC 
Hello Mohamed Zaghloul,

Thank you for reporting the bug. I can confirm that the bug is present in master.

Version: 25.2.3.2 (X86_64) / LibreOffice Community
Build ID: bbb074479178df812d175f709636b368952c2ce3
CPU threads: 22; OS: Windows 11 X86_64 (10.0 build 26100); UI render: Skia/Raster; VCL: win
Locale: en-US (en_US); UI: en-US
Calc: CL threaded