There's a predefined shortcut (CTRL+; on linux... it's probably Command+; on Mac) that enters the date into the currently selected field.
You can add a different keystroke if you want in On Sun, Jan 4, 2026 at 10:53 AM Johnny Rosenberg <[email protected]> wrote: > Den fre 2 jan. 2026 kl 14:39 skrev william <[email protected]>: > > > I have task that involves logging activities into a 2 column > > table: date, activity. Is there any way that I can automagically > > put the current date into column 1 when I open the row by tabbing > > the last row of the table? > > > > > I assume you are using Calc and that you mean that you want the current > date as a fixed date (not =DATE()). In that case, I actually do a similar > thing pretty often. > My method is to use a Sheet Event (right click a sheet tab, and there it > is) to assign a macro to an event for that sheet only. The macro then > detects which cell was changed and fills the cell on the same row in the > Date column with the current date, so when using the sheet, you just enter > values in your other column, and after you done that, the current date > appears in the corresponding date cell. > If you don't know how to write the actual macro, maybe I (or someone else) > can help. > > > Kind regards > > Johnny Rosenberg > > > > > > Thanks for your time > > --bill > > > > > > -- > > To unsubscribe e-mail to: [email protected] > > Problems? > > https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ > > Posting guidelines + more: > https://wiki.documentfoundation.org/Netiquette > > List archive: https://listarchives.libreoffice.org/global/users/ > > Privacy Policy: https://www.documentfoundation.org/privacy > > > > -- > To unsubscribe e-mail to: [email protected] > Problems? > https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ > Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette > List archive: https://listarchives.libreoffice.org/global/users/ > Privacy Policy: https://www.documentfoundation.org/privacy > -- To unsubscribe e-mail to: [email protected] Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
