on col A.
Sent fromMailfor Windows 10
From:Dan LewisSent:03 October 2020
11:58To:users@global.libreoffice.orgSubject:Re: [libreoffice-users] Static vs.
dynamic time
There is an option that I have found accidentally: If you want to enter
the present time as static, use InsertTimeor
ent: Sat, 3 Oct 2020 10:31:58 +1000
Subject:Re: [libreoffice-users] Static vs. dynamic time
To: LibreOffice
When I have needed a static date or time in Libreoffice Calc, I have found
that the only way to do this is to enter the date or time direc
: Michael Manning
Date sent: Sat, 3 Oct 2020 10:31:58 +1000
Subject:Re: [libreoffice-users] Static vs. dynamic time
To: LibreOffice
> When I have needed a static date or time in Libreoffice Calc, I have found
> that the only way
When I have needed a static date or time in Libreoffice Calc, I have found
that the only way to do this is to enter the date or time directly into the
spreadsheet and not to use a formula.
As an example of this, I have been using Calc to measure the drift of
timepieces compared to a time standard
On Fri, 2 Oct 2020 21:27:30 +0200
Johnny Rosenberg wrote:
> In Google Spreadsheets
What does this have to do with LO?
--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines +
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
Some disappointment:
Now I'm not so sure any more that this is possible. My idea was to check
the currently selected cell, but it has two big flaws:
1: When updating cell contents, any cell can be selected.
2: ThisComponent.CurrentSelection.getValue() seems to always return 0 in a
situation like
Den fre 2 okt. 2020 kl 11:41 skrev Chimel :
> 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
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, not the time I
typed something in column A.
I tried looking for a static version of