Recent searches
Search options
Handy #LibreOffice Calc tip! Press Ctrl+; to insert the current date, or Shift+Ctrl+; for the current time. Want a date and time that's always updating? Use the =NOW() function. https://help.libreoffice.org/latest/en-US/text/scalc/01/04060102.html #foss #opensource
@libreoffice
I wonder how that works on European keyboards where typing ; needs shift.
@leeloo @libreoffice It doesn't, at least not out of the box, but at least you can change the default key bindings.
@leeloo @libreoffice
On french keyboard, Ctrl+; for current date and Crtl+: for current time.
@libreoffice : but wouldn't the time change the next time the workbook is opened/refreshed?
Need static data, not dynamic data...
@mars1024 @libreoffice
If I'm reading it correctly, the keypresses insert a static date / time, the function is dynamic.
So you should be able to subtract them and show "this document is x days old".
