Re: [office-formula] CONVERT

[Eike Rathke <erack@sun.com>]

Hi Andreas,

On Thursday, 2007-02-01 18:02:45 -0700, Andreas J Guelzow wrote:

> It sounds to me like OOo's function is primarily multiplication. So
> there is no OOo compatibility function as far as I know.

Yes, OOo does only multiplication/division by a factor.

> > I don't have my "stuff" with me right now... I vaguely remember
> > a EUROCONVERT being involved somewhere.
> 
> Well there is an
> 
> EUROCONVERT(n,source,target)

Actually it's
EUROCONVERT(number,source,target,full_precision,triangulation_precision)
full_precision controls the precision returned and
triangulation_precision controls the significant digits used in the
conversion.

Btw, EUROCONVERT is not listed as a predefined function in the Ecma
spec. It is also not installed per default and available only if the
Euro Currency Tools Add-in is installed. Do we want to define it?

> EUROCONVERT converts the currency value @n of @source currency to a
> target currency @target. Both currencies are given as three-letter
> strings using the ISO code system names.  The following currencies are
> available:
> 
>     ATS	(Austria)
>     BEF	(Belgium)
>     DEM	(Germany)
>     ESP	(Spain)
>     EUR	(Euro)
>     FIM	(Finland)
>     FRF	(France)
>     GRD	(Greek)
>     IEP	(Ireland)
>     ITL	(Italy)
>     LUF	(Luxembourg)
>     NLG	(Netherlands)
>     PTE	(Portugal)

Which lacks the Slovenian Tolar SIT. Slovenia joined the Euro community
per 2007-01-01. This is one of the reasons why OOo decided to have the
conversion factors in the configuration, new factors can be added by the
user.


> * If the given @source or @target is other than one of the above,
> EUROCONVERT returns #VALUE! error.
> 
> as well as an 
> EURO(currency)
> 
> EURO converts one Euro to a given national currency in the European
> monetary union.

Where did you find that function? My Excel 2003 doesn't have it, not
even if the Euro Tools are installed. It also isn't in the Ecma spec.

  Eike

-- 
Automatic string conversions considered dangerous. They are the GOTO statements
of spreadsheets.  --Robert Weir on the OpenDocument formula subcommittee's list.