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
