Confused by err:502??

classic Classic list List threaded Threaded
1 message Options
Michael D. Setzer II Michael D. Setzer II
Reply | Threaded
Open this post in threaded view
|

Confused by err:502??

Tried to use regex to convert info to formula to convert.
Got result that is correct, but try to use value to get number and it
fails with err:502
If I manually put the value in a cell it works,
but it I put same value in cell with quotes it also fails.
What am I missing??

03°15'090"E
"=REGEX(REGEX(REGEX(REGEX(REGEX(A57,"°","+"),"'","/60+"),"""","/3600"),"[EN
]",""),"[OSW]","*(-1)")
03+15/60+090/3600TRUEcheck if text
Err:502"=VALUE(A59)
03+15/60+090/3600"=CELL("CONTENTS",A59)
Err:502"=VALUE(A61)
03+15/60+090/3600copy VALUE OF A61
Err:502"=VALUE(A63)
3.275"=VALUE(3+15/60+90/3600)
Err:502"=VALUE("3+15/60+90/3600")

+------------------------------------------------------------+
 Michael D. Setzer II - Computer Science Instructor (Retired)    
 mailto:[hidden email]                            
 mailto:[hidden email]
 Guam - Where America's Day Begins                        
 G4L Disk Imaging Project maintainer
 http://sourceforge.net/projects/g4l/
+------------------------------------------------------------+




--
To unsubscribe e-mail to: [hidden email]
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