Conversation

Notices

1. Embed this notice
   LibreOffice (libreoffice@fosstodon.org)'s status on Sunday, 21-Apr-2024 17:25:36 JST LibreOffice

   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

   • Embed this notice
     Leeloo (leeloo@techhub.social)'s status on Sunday, 21-Apr-2024 20:11:15 JST Leeloo

     in reply to

     • Mars 1024 🎄🎁

     @mars1024 @libreoffice
     If I'm reading it correctly, the keypresses insert a static date / time, the function is dynamic.

     So you should ba able to subtract them and show "this document is x days old".

   • Embed this notice
     LibreOffice (libreoffice@fosstodon.org)'s status on Sunday, 21-Apr-2024 20:11:15 JST LibreOffice

     in reply to

     • Mars 1024 🎄🎁
     • Leeloo

     @leeloo @mars1024 Yes, exactly 👍

   • Embed this notice
     Mars 1024 🎄🎁 (mars1024@techhub.social)'s status on Sunday, 21-Apr-2024 20:11:16 JST Mars 1024 🎄🎁

     in reply to

     @libreoffice : but wouldn't the time change the next time the workbook is opened/refreshed?

     Need static data, not dynamic data...