[LibreCalc] Adding date cell that is always up to date


I’d like to have a cell in LibreOffice Calc that always displays the current date when the file is being opened.

Is that something that is possible? If so how would I do that?

Kind regards,


=TODAY() (or =NOW() and using a proper format code [e.g.: YYYY-MM-DD HH:MM:SS], if you want a time as well).


[1] - LibreOffice Help - TODAY
[2] - LibreOffice Help - NOW

Hope that helps.

Please also note:
The functions TODAY() and NOW() are volatile. This means they will be recalcuölated (and the results updated) as often as any recalculation occurs.
The Date (or DateTiume) shown will therefore not indicate when the document was loaded, but when it was last recalculated. Details will depend on whether or not the AutoCalculate option was enabled.
If you definitely want to show the DateTime value for the event of “opening” you will need user code bound to the document event onViewCreated.

Thanks, you’re the best! That’s exactly what I was looking for.