Cell does not automatically update over days

I have a formula using TODAY(), however the output value does not automatically update when a day passes. (To clarify, I keep this file open overnight) If I edit the cell in some way that does not change the actual formula (e.g. backspacing and retyping a character) the cell will update to the new value. Does this problem happen for anyone else?
This may be a bug that needs fixing, but for the time being I would just like to know if there is any workaround that makes the cell automatically update.

Info for my particular installation
Version: 6.1.5.2
Build ID: 1:6.1.5-3+deb10u6
CPU threads: 8; OS: Linux 4.19; UI render: default; VCL: gtk3;
Locale: en-US (en_US.UTF-8); Calc: group threaded

Do you mean that it does not update when you open the file tomorrow, or do you mean that your file is open on screen, and at midnight the display does not change?

Also what version do you use?

I mean that the file is open and at midnight the cell doesn’t update. Thanks for asking! I’ve updated the main post to add this info and my version

No function at all does update when you don’t perform any action on a sheet. And TODAY() requires at least any arbitrary single cell to be modified. For testing purposes use NOW() in a cell and format to YYYY-MM-DD HH:MM:SS - you won’t see any seconds updating until you modify any cell of your sheet,

i agree with previous commenters that your wish is not a self-going task in LO calc,

but there are workarounds …

two which come to my mind just now:

1.) use a ‘link to external data’ and ‘update every xx seconds’ to trigger frequent updating of something in your workbook, and that changing to trigger updating of the timer or counter you want, or

2.) use macro code, e.g.

sub clock1

rem ----------------------------------------------------------------------
rem define variables
dim document   as object
dim dispatcher as object
rem ----------------------------------------------------------------------
rem get access to the document
document   = ThisComponent.CurrentController.Frame
dispatcher = createUnoService("com.sun.star.frame.DispatchHelper")

for i = 0 to 10000 

wait 1000

rem ----------------------------------------------------------------------
dispatcher.executeDispatch(document, ".uno:Calculate", "", 0, Array())

next i

end sub 'clock1

will upate @Opaques wall clock every second for the next 10.000 seconds, it’s not even blocking other work in the sheet,

(be careful, i didn’t check how much of the sheet will be recalculated, just used what macro recorder got for a recorded ‘F9’, could be problematic to recalculate a large sheet too often)

[edit] !!! be careful, nice problems trying to close the program / sheet while macro is running, and even nicer problems trying to restart, save all work beforehand !!! (at least with ver. 7.1.0.0.a0+) [/edit]

there will be plenty of other aproaches, use the search engine of your choice and keywords like libreoffice, calc, time, timer, clock, dynamic, update or similar,

hope that helps … :slight_smile:

Thanks, I tried the first workaround and it’s worked so far!