Date: prev next · Thread: first prev next last
2020 Archives by date, by thread · List index

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

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

Contents of a simple spreadsheet

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)
 Guam - Where America's Day Begins
 G4L Disk Imaging Project maintainer

To unsubscribe e-mail to:
Posting guidelines + more:
List archive:
Privacy Policy:

Alan Boba
CISSP, CCENT, ITIL v3 Foundations 2011

To unsubscribe e-mail to:
Posting guidelines + more:
List archive:
Privacy Policy:


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.