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.
