Den fre 2 okt. 2020 kl 11:41 skrev Chimel <[email protected]>: > Hi, > > I use the formula IF(A1<>"";NOW()) copied to every cell of column B. > It gives me the correct time every time I type anything on a line of column > A. > But this is refreshed constantly by the time of the computer,
Yes, that's the point with the NOW() function. It's usually used for calculating time, for instance how long ago a certain date was, for instance =NOW()-A1, which you then format to whatever format you like. With no formatting you get it in days. not the time I > typed something in column A. > That's correct and intended. I tried looking for a static version of NOW() or playing with iterations > (probably not correctly) or looking for a way to stop recomputing this > specific column to no avail. > Is there a way to set on column B the time of the typing on each line of > column A and keep it as a static time. > Yes, I actually do that in a Google Spreadsheet, but it can be done in all spreadsheets that support macros or scripts, I think. > > I am usually good with formulas, but this very basic need escapes me. > It's probably because there is no cell function for that. You have to create your own. As far as usability is concerned, a STATICNOW() function seems much more > useful than the current NOW() function. It depends on what you want to do. See above. I find both useful, but in different situations. > Or inserting a 0,1 argument for > staticness or something. > So far, I am forced to type or insert the time manually each time. > Let me repeat it: Manually each time! Me! ;) > I'll experiment a bit with a macro for this. I'm back when done, if nobody beats me to it. Kind regards Johnny Rosenberg > > Thanks, > Chimel. > > > > -- > Sent from: > http://document-foundation-mail-archive.969070.n3.nabble.com/Users-f1639498.html > > -- > 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
