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.
I trust this helps.
To unsubscribe e-mail to: firstname.lastname@example.org
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Impressum (Legal Info)
: 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