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: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/
Privacy Policy: https://www.documentfoundation.org/privacy