Date returned by NOW() has 0 as double value

[HSinger04]

Hello, I am trying to write a macro in BASIC where I use “NOW()”. Using the debugger, I can see
that the Variant/Date value of its output is correct (i.e. 13/5/2025 + the time), but when converting it
to a double with CDbl, I get 0, even though it should be 45790 + some decimal. I can also confidently say that it is a bug related to “NOW()” since if I do e.g. a subtraction against some other date without explicit conversion, I just get the negative version of the date (i.e. as if subtracted from 0). Even if I use “TODAY()”, I have the same problem i.e. its double value is 0. I am using the Flatpak version of LibreOffice.

Thank you in advance!

[Villeroy]

[HSinger04]

Are you also using the Flatpak version or a different one? Since I would like to be able to narrow down on whether the bug occurs due to the Flatpak version or that something is wrong due to my personal settings or the like.

[mikekaganski]

If that’s flatpack’s fault, they needed to do something really weird to make that happen… but first, it could help to show your problem on a screenshot. And provide the full version info.

[HSinger04]

Just reinstalled the flatpak and the bug is now gone, so seems like a personal setting caused it. Sorry, should have just tried the usual “Have you tried restarting?” idea from the get-go.