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

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

nikolka5130
11 ●2 ●3 ●3

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

Alex Kemp

flag of United Kingdom of Great Britain and Northern Ireland

21584 ●22 ●61 ●60 http://etmg.altervista...

=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

add a comment

1

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

erAck

9195 ●44 ●82 https://erack.de/

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.