=CONVERT(10,“km”,“mi”) returns numeric value
=CONVERT_OOO(10,“km”,“mi”) returns #N/A error
What is the difference between CONVERT and CONVERT_OOO functions?
I can’t find a conversion table for CONVERT_OOO function to compare they
Due to legacy reasons…
The ODF function CONVERT as also known from Excel was named CONVERT_ADD in older versions.
There was also a function CONVERT that worked similar but different, with conversion factors obtained from the configuration, and could be used as a EUROCONVERT replacement once when EUROCONVERT didn’t exist yet…
EUROCONVERT additionally exists.
In newer versions, the old CONVERT was renamed to CONVERT_OOO, and CONVERT_ADD was renamed to CONVERT so it actually matches what is expected from the user. EUROCONVERT is not affected.
The help wasn’t adapted yet.
Yes, confusing.
It seems there are some weird differences between Functionnames in Wizard and Online-Help?!!
CONVERT is linked to CONVERT_ADD
CONVERT_OOO is linked to EUROCONVERT