I was about to say that is very handy --- but then I noticed that it does not work for me - and Im on Kubuntu 25.04 Version: 25.8.4.2 (X86_64) / LibreOffice. I did try CTRL and the large + button on the numeric pad of my keyboard but that only inserts cells.
On Sunday 04 January 2026 03:30:31 PM (-06:00), Michael H wrote: > 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 > > > -- -- Registered Linux User: #480675 Registered Linux Machine: #408606 Linux since June 2004 -- 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
