[Libreoffice-bugs] [Bug 125580] Wrong value when adding two dates

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=125580

m.a.riosv <miguelangelrv at libreoffice.org> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |miguelangelrv at libreoffice.o
                   |                            |rg
         Resolution|---                         |NOTABUG
             Status|UNCONFIRMED                 |RESOLVED

--- Comment #2 from m.a.riosv <miguelangelrv at libreoffice.org> ---
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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20190529/a4cf599d/attachment.html>