2020 Archives by date, by thread · List index

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

```Haven't found documentation to confirm but I believe your first example
=value(1+1) is recognized as a formula, the formula is processed and the
result converted to a value.

It works for me if I enter =value(sum(1,1)) the cell displays 2 and
=CELL("type",<address>), pointed at that cell, displays v

If I format a cell as text, enter a decimal digit, e.g. 2, and point
value() at that cell it returns the number 2.

If i point cell("type",<address>) at the cell containing digits that are
formatted as text the result is "l" (lower case L).

If I point cell("type",<address>) at the value() formula that points at the
text formatted digits it returns v.

So, I would say that value() converts a number formatted as text to a
value, converts a formula that results in a number to a value, but will not
recognize a formula written as a text string and convert the string to
produce the value.

On Mon, Nov 23, 2020 at 11:50 PM Michael D. Setzer II <msetzerii@gmail.com>
wrote:

```
```Put a more complex question, and got no responses yet.
So, here it is in simplest form
=value(1+1)  converts the 1+1 to 2
But =value( ) fails with Err:502 is text "1+1" is used or i 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? Is there another command, or am I doing something
wrong?

2   "=value(1+1)
Err:502 "=VALUE("1+1")
"1+1            TRUE            =ISTEXT(A3)
Err:502 "=value(a3)

+------------------------------------------------------------+
Michael D. Setzer II - Computer Science Instructor (Retired)
mailto:mikes@guam.net
mailto:msetzerii@gmail.com
Guam - Where America's Day Begins
G4L Disk Imaging Project maintainer
http://sourceforge.net/projects/g4l/
+------------------------------------------------------------+

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

```
```
--
Alan Boba
CISSP, CCENT, ITIL v3 Foundations 2011

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