Users Ahoy:
Is there a way to get LO (v5.2.7.2) calc to extract the numerical value
from a cell, and use that instead of the cell reference in further
calculations?
Frinstance, if I have 167 in cell A1, and want 16.7 in A2, how can I
program it, (if at all)?
If I put =A1/10 into A2, A2 wil
Original Message
From: mxk [mailto:mxkeat...@comcast.net]
Sent: Saturday, September 25, 2021, 16:02 UTC
To: users@global.libreoffice.org
Subject: [libreoffice-users] extracting cell values
> Users Ahoy:
>
> Is there a way to get LO (v5.2.7.2) calc to extract the
02 UTC
To: users@global.libreoffice.org
Subject: [libreoffice-users] extracting cell values
Users Ahoy:
Is there a way to get LO (v5.2.7.2) calc to extract the numerical value
from a cell, and use that instead of the cell reference in further
calculations?
Frinstance, if I have 167 in cell A1, and
Hi Miss K.
The purpose of your request is not clear.
For the situation where I want to de-reference a value I use copy and
then paste-special selecting only numbers.
If you want 167 in A1 and 16.7 in A2 so that is stays 16.7 even if A1
changes then possibly in B1 put =A1/10 then copy B1 and in
At 12:02 25/09/2021 -0400, Miss Keating wrote:
Is there a way to get LO (v5.2.7.2) calc to extract the numerical
value from a cell, and use that instead of the cell reference in
further calculations? Frinstance, if I have 167 in cell A1, and want
16.7 in A2, how can I program it, (if at all)? I
Den lör 25 sep. 2021 kl 22:07 skrev Steve Edmonds <
steve.edmo...@ptglobal.com>:
> Hi Miss K.
> The purpose of your request is not clear.
> For the situation where I want to de-reference a value I use copy and
> then paste-special selecting only numbers.
> If you want 167 in A1 and 16.7 in A2 so
Hello,
You can convert the formulas to only keep the values by doing a
copy/paste special where what you will keep are only the numbers. To
do: select the cells, copy (CTRL-C or Edit > Copy) and then paste
special (Edit > Paste Special), and select to keep only the numbers.
You may be prompted to
On Sun, 26 Sep 2021 02:33:33 +0200
Johnny Rosenberg wrote:
Hello,
>Well, that kind if defeats the purpose with a spreadsheet in the first
>place, so you just have to do that manually, or write a macro that does
>that for you.
OP's request whiffs of an XY problem to me. Of course, I may be
wron
Hello Miss K.
The result, 16.7, may be pasted into another cell using "Paste value". This
will not paste the formula.
If your result cell is displaying the formula and not the result then there
is a Calc setting to change. Even if you are seeing the formula, using
"Paste value" will paste the val