https://bugs.documentfoundation.org/show_bug.cgi?id=135505
Mike Kaganski <[email protected]> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|UNCONFIRMED |RESOLVED
Resolution|--- |NOTABUG
--- Comment #1 from Mike Kaganski <[email protected]> ---
(In reply to simon from comment #0)
> 1. Cell G1: =NOW() Assume it is 06/08/20
No, it is not "06/08/20". NOW [1] returns not a day, it returns a datetime
value - i.e., day *and time of the day*, the latter as a fraction of a day. So
e.g. for now, =NOW gives me 2020-08-06 20:10:48, which is 44049.8408352431
internally; and the ".8408352431" is "afternoon" (i.e., 20:10:48).
If you format your cell to show you only whole part of the datetime value
(i.e., only date), you do not change your calculations, which still see the
actual value stored in the cell, not the result of formatting.
Also it looks like you have formatted N307 to not show you fractional part, so
it rounds the result of the subtraction, and ".8408352431" is shown as "1",
while "0.23456" is shown as "0".
You likely need to use TODAY [2] instead of NOW.
Closing NOTABUG.
[1] https://help.libreoffice.org/6.4/en-US/text/scalc/01/func_now.html
[2] https://help.libreoffice.org/6.4/en-US/text/scalc/01/func_today.html
--
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
