Re: [libreoffice-users] Question on value command and Err:502

At 14:48 24/11/2020 +1000, Michael D. Setzer II wrote:
> Put a more complex question, and got no responses yet.

You have to admit that your description and layout were pretty foggy! 
Did anyone understand it?

> So, here it is in simplest form
> =value(1+1) converts the 1+1 to 2
> But =value( ) fails with Err:502 if text "1+1" is used or if a cell 
> containing the text 1+1 is used??
> I've looked thru command, and this seems to be the one to convert a 
> text string to a value?

It is. But the text string "1+1" is not a value expressed as text but 
a numerical expression in text form. And VALUE() does not undertake 
to evaluate such expressions.

> Is there another command, ...;

What you need instead is the EVALUATE() function. (PS: It doesn't exist!)

I think the fact that VALUE(1+1) entered as part of a formula does 
what it does is a lucky side effect. Clearly in this case LibreOffice 
is doing something similar to the automatic editing that is done when 
any material is entered into a spreadsheet cell. I'm talking about 
this sort of thing: when you type "+02" (no quotes) into a cell 
formatted as Number, you see just 2. The "1+1" in this case is being 
entered into a cell (as part of a formula), not arising as the result 
of some calculation.

I trust this helps.

Brian Barker


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