Re: [libreoffice-users] extracting cell values

Do you have the following checked:

TOOLS -> OPTIONS -> LIBREOFFICE CALC -> VIEW

Value highlighting? If so, uncheck it.

Joe

On 9/25/21 11:08 AM, Dave Barton wrote:
> -------- Original Message --------
> From: mxk [mailto:mxkeating@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 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
> If you don't want to use cell references, how would you inform Calc
> which one of the thousands of cells in a sheet was the one holding the
> value you wanted it to use in your calculations?
>
> If you actually do see A1/10 in cell A2, this suggests that cell A1 is
> formatted as text not a numeric value. In which case =VALUE(A1)/10 does
> work.
>
> You will find some excellent Calc User Guides here:
> https://tinyurl.com/aa4mrlt
>
> LibreOffice version 5.2.7.2 is quite old and I would recommend updating
> to at least version 7.1.6 from:
> https://www.libreoffice.org/download/download/
>
> Dave

--
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