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",), 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",) at the cell containing digits that are
formatted as text the result is "l" (lower case L).
If I point cell("type",) 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
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?
>
> Contents of a simple spreadsheet
>
> 2 "=value(1+1)
> Err:502 "=VALUE("1+1")
> "1+1TRUE=ISTEXT(A3)
> Err:502 "=value(a3)
>
>
> ++
> Michael D. Setzer II - Computer Science Instructor (Retired)
> mailto:mi...@guam.net
> mailto:msetze...@gmail.com
> Guam - Where America's Day Begins
> G4L Disk Imaging Project maintainer
> http://sourceforge.net/projects/g4l/
> ++
>
>
>
>
> --
> To unsubscribe e-mail to: users+unsubscr...@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
>
>
--
Alan Boba
CISSP, CCENT, ITIL v3 Foundations 2011
--
To unsubscribe e-mail to: users+unsubscr...@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