Bug 168404 - Base unexpectedly "rounds" datetime when connected to Calc
Summary: Base unexpectedly "rounds" datetime when connected to Calc
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Base (show other bugs)
Version:
(earliest affected)
7.2.5.2 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2025-09-14 08:11 UTC by huge.pan4824
Modified: 2025-09-14 10:55 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

Attachments
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 huge.pan4824 2025-09-14 08:11:13 UTC 
Description:
Some datetime values are incorrectly "rounded" in Base when it is connected to Calc spreadsheet.

Steps to Reproduce:
1. Create a spreadsheet with a datetime column.
2. Input one of the values as "2023-05-12 02:21".
3. Now create a Base file with this spreadsheet as source.
4. Check the value in the table in Base.

Actual Results:
The value is displayed as one minute earlier than what is actually in the spreadsheet.

Expected Results:
The value should be the same as in the spreadsheet the Base connects to.


Reproducible: Always


User Profile Reset: No

Additional Info:
Version: 7.2.5.2 (x64) / LibreOffice Community
Build ID: 499f9727c189e6ef3471021d6132d4c694f357e5
CPU threads: 4; OS: Windows 10.0 Build 19045; UI render: Skia/Raster; VCL: win
Locale: en-US (en_US); UI: en-US
Calc: CL
Comment 1 Robert Großkopf 2025-09-14 10:55:25 UTC 
Tried it with
Version: 25.8.1.1 (X86_64)
Build ID: 54047653041915e595ad4e45cccea684809c77b5
CPU threads: 6; OS: Linux 6.4; UI render: default; VCL: kf5 (cairo+xcb)
Locale: de-DE (de_DE.UTF-8); UI: de-DE
Calc: threaded

2023-05-12 02:21:00 will be shown as 2023-05-12 02:20:59
2021-07-13 11:47:00 will be shown as 2021-07-13 11:46:59

Other datetime value with a time like 12:10:00 are shown right.

Might be the same buggy behavior as found in ReportBuilder: bug 97462