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 <msetze...@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? > > 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) > 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