Re: [libreoffice-users] extracting cell values

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 inform you that you are pasting over existing
data: if so, just accept. Then, if you look in the cells, you should
now only have the results of the cells. I recommend you paste to a new
worksheet to keep the formulas intact for a future use.

I hope this helps.
Rémy.

Le dimanche 26 septembre 2021 à 09:05 +1300, Steve Edmonds a écrit :
> 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 A2 
> paste-special selecting only numbers to paste.
> I arrange the type of calculation above so that I can copy/paste-
> special 
> rows or columns at a time.
> Steve
>
> On 26/09/2021 05:02, mxk wrote:
> > 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 will contain A1/10, not 16.7,even
> > though 
> > it will display as 16.7.
> >
> > I want to get away from cell references and use the contained
> > values. 
> > Can I?
> >
> > I thought that =VALUE(A1)/10 might work, but the result continues
> > to 
> > use the cell reference, not the contained value.
> >
> > Miss K


-- 
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy