Conversation

Notices

1. LibreOffice (libreoffice@fosstodon.org)'s status on Sunday, 21-Apr-2024 17:25:40 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

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

     in reply to

     • Mars 1024 🎄🎁
     • Leeloo

     @leeloo @mars1024 Yes, exactly 👍

   • Mars 1024 🎄🎁 (mars1024@techhub.social)'s status on Sunday, 21-Apr-2024 20:11:17 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...

   • Leeloo (leeloo@techhub.social)'s status on Sunday, 21-Apr-2024 20:11:17 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".