Date: prev next · Thread: first prev next last
2020 Archives by date, by thread · List index

At 02:37 02/10/2020 -0700, Chimel Noname wrote:
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, not the time I typed something in column A. 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.

This is a simple question but unfortunately does not appear to have a simple answer. But - like with your other question - you can do something using a recursive formula. Enter into B1
Once again, you need to have Tools | Options... | LibreOffice Calc | Calculate | Iterative References | Iterations ticked.

This almost works, in that if A1 is empty and you enter something there, then B1 will change to record the time. But if you now simply overtype what is already in A1, B1 will not change. There is an easy workaround, however: before typing your new value into A1, just press Delete to empty A1 (B1 will now be empty too) and then enter your new value (B1 becomes the new time).

So far, I am forced to type or insert the time manually each time.

No longer!

I trust this helps.

Brian Barker

To unsubscribe e-mail to:
Posting guidelines + more:
List archive:
Privacy Policy:


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.