[Bug 161469] NOW() Function in Calc Macro Omits Sub-Seconds

[bugzilla-daemon]

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

--- Comment #4 from Daniel Baran <d.j.ba...@frontier.com> ---
Having researched this further, I found that this rounding to
seconds is a known behavior of the NOW() function in Basic.

https://forum.openoffice.org/en/forum/viewtopic.php?p=455955&sid=32227f1e230f851464c32171720f030e#p455955

The suggested solution works for me in Libre Calc.

Example:

Dim TimeStamp()
        Dim svc As Object
        svc = createUnoService("com.sun.star.sheet.FunctionAccess") 
        Cell.Value = svc.callFunction("NOW",TimeStamp())

It is a somewhat unanticipated behavior of the NOW() function.
It's not clear to me what Status is warranted.

-- 
You are receiving this mail because:
You are the assignee for the bug.