Ask Your Question
1

What is the difference between CONVERT and CONVERT_OOO functions? [closed]

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

nikolka5130 gravatar image

updated 2020-08-10 22:32:24 +0200

Alex Kemp 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 reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2020-08-10 22:32:16.425120

2 Answers

Sort by » oldest newest most voted
1

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

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
0

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

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

Question Tools

1 follower

Stats

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

Seen: 415 times

Last updated: Aug 23 '17