Re: [libreoffice-users] extracting cell values

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