Ask Your Question
0

What is the difference between CONVERT and CONVERT_OOO functions?

asked 2017-04-04 09:47:50 +0100

nikolka5130 gravatar image

=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

edit retag flag offensive close merge delete

2 Answers

Sort by » oldest newest most voted
0

answered 2017-04-04 11:19:46 +0100

karolus gravatar image

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

edit flag offensive delete link more
0

answered 2017-08-23 18:46:01 +0100

erAck gravatar image

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.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2017-04-04 09:47:50 +0100

Seen: 237 times

Last updated: Aug 23 '17