https://bugs.documentfoundation.org/show_bug.cgi?id=125580
m.a.riosv <[email protected]> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |[email protected]
| |rg
Resolution|--- |NOTABUG
Status|UNCONFIRMED |RESOLVED
--- Comment #2 from m.a.riosv <[email protected]> ---
This is a rounding issue.
date-time value have a real value in the cells:
days as integer number + hours/24 + minutes/24/60 + seconds/24/60/60
The visualization format doesn't change the cell value.
The first thing is using NOW() it gives actual date+time
So better TODAY() that gives an integer value
=ROUNDUP(TODAY()+TIME(0;5;0);7) in B1
a formula like
=ROUNDUP(B1+TIME(0;5;0);7)
for the rest of the cells, rounding up with seven decimal places seems gets the
right values even using seconds.
In any case not a bug, developers work hard to avoid rounding issues that comes
from the floating calculations with 15 places plus sign limit, it is a hardware
limitation, rounds exceeding this limits can give inaccurate results on the
last places of the number.
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
