https://bugs.documentfoundation.org/show_bug.cgi?id=125580
N.A. Hoijtink <elk...@live.nl> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|NEW |UNCONFIRMED
Ever confirmed|1 |0
--- Comment #18 from N.A. Hoijtink <elk...@live.nl> ---
I can confirm a similar (same?) issue with off calculations:
if you enter a date+time value in the first row, and then add for e.g.
timevalue("00:15:00,000") to the previous cell and the use fill (drag it down)
at some point the datetime displayed equals ../../.. xx:59:59
for example enter in the first cell =datevalue(2023;12;3)+timevalue(0,15,0),
next cell = "previous cell"+timevalue("00:15:00,000") at some point it results
in a unexpected value (1 second less), in my case example at the 25th row.
so to be exact:
A1 03-12-2023 00:00:00,000 (enter some date/time combo in first
cell)
A2 =A1+TIMEVALUE("00:15:00,000") (formula to drag down from cell 2
onwards) results 03-12-2023 00:15:00
.
.
.
.
A25 =A24+TIMEVALUE("00:15:00,000") results
03-12-2023 05:59:59
There seems to be some sort of a precision issue .... and it happens really
fast.
My system is a AMD Ryzen 7 5700G running Windows 10 24H1 OS Build 19043.3208
(Dutch), LibreOffice 7.6.0.3 (x86+64) Dutch
Not sure if it is the exact same issue or a more specific date/time issue ....
--
You are receiving this mail because:
You are the assignee for the bug.
