Was looking for options on this, but haven't found exactly what I'm
looking for.
Closest I've found is Ctrl + ; that inserts current date
and Ctrl + Shift + ; that inserts the current time.
Both seem to be the fixed value?
But have found no way to do that in a formula??
Recall long ago in
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
Den fre 2 okt. 2020 kl 16:20 skrev Chimel :
> A cell with a formula can have a whole "history" of values that change
> every
> now and then.
>
I'm pretty sure it can not. Please prove me wrong. I'd love to know what
this is all about. Maybe I just don't understand what you are trying to say.
Although I could manage it, I could no longer find it except to manage it...
Cannot check it again until Sunday when I am again near a computer
Sent from BlueMail
On Oct 2, 2020, 3:13 AM, at 3:13 AM, Heiko Tietze
wrote:
>On 01.10.20 22:11, Andrew Pitonyak wrote:
>> I noticed it seemed to
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
At 06:41 02/10/2020 -0700, Chimel Noname wrote:
... I am also stuck with extracting the maximum value of one given
cell. For instance, A1 contains variable numbers, and I want to
store the maximal value of this cell in B1.
As others have said, the cell, does not "contain variable numbers",
Le 2020-10-01 01:13, Tom Williams a écrit :
Hi! A friend of mine sent me an Excel 365 spreadsheet to get my help
to
add a formula. The spreadsheet is "simple", in that it had about 90
rows of data, with only one column being a numeric value. Everything
else was plain text. I added the
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
This is exactly the formula I needed, it works just fine every time. Thanks
again, Brian.
--
Sent from:
http://document-foundation-mail-archive.969070.n3.nabble.com/Users-f1639498.html
--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems?
Thanks, Brian. The formula I mentioned earlier works now.
I tried the Iterations settings before, enabled and disabled it with
different values (step, min), but when I clicked on the Reset button to
restore the default options, it actually only restores the previous values I
played with before,
On 10/2/20 7:32 AM, sandralo...@vivaldi.net wrote:
> Le 2020-10-01 01:13, Tom Williams a écrit :
>> Hi! A friend of mine sent me an Excel 365 spreadsheet to get my help to
>> add a formula. The spreadsheet is "simple", in that it had about 90
>> rows of data, with only one column being a numeric
On Fri, 2 Oct 2020 15:03:17 +0100
Dave Howorth wrote:
Hello Dave,
>So the entire notion of the 'maximum' value of a cell is meaningless.
I /think/ what Chimel wants is
B1=A1 if A1>B1
How to achieve that in LO Calc, IDK; I keep getting circular reference
errors.
--
Regards _
/
A cell with a formula can have a whole "history" of values that change every
now and then.
It has only one value at one given time, it's this value that I want to
compare with its previous values so I can extract the maximal value the cell
ever reached.
--
Sent from:
On Fri, 2 Oct 2020 06:41:27 -0700 (MST)
Chimel wrote:
> Hi,
>
> I must be of a conservative mind today, because after the message
> about static NOW(), I am also stuck with extracting the maximum value
> of one given cell.
What do you mean by 'the maximum value' of a cell?
It sounds like you
Hi,
I must be of a conservative mind today, because after the message about
static NOW(), I am also stuck with extracting the maximum value of one given
cell.
For instance, A1 contains variable numbers, and I want to store the maximal
value of this cell in B1.
The trouble is that MAX() compares 2
On 01/10/2020 20:36, JPS wrote:
On 01/10/2020 13.28, Philip Jackson wrote:
In LO 6.4.5.2 and 6.4.6.2 (UbuntuStudio), whenever I open one of my spread
sheets, made years' ago but in weekly use, I find that the font name and the
font size is slightly corrupted in the formatting toolbar.
The
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
FWIW, the MODIFIED flag is apparently the status for unpublished extensions
(maybe you changed something but the extension file?). And after pressing the
button again it shows up now on the page.
On 01.10.20 22:11, Andrew Pitonyak wrote:
> I noticed it seemed to have just disappeared but I can
On 01.10.20 22:11, Andrew Pitonyak wrote:
> I noticed it seemed to have just disappeared but I can see if to maintain it
> but not navigate to it. my best guess is that it is because I inadvertently
> changed the title but I don't really know. I tried to put entitled back, but
> did not cause
21 matches
Mail list logo
