EUROCONVERT (was: [office-formula] CONVERT)

Hi, 

On Tuesday, 2007-02-06 11:10:38 -0500, David A. Wheeler wrote:

> Eike:
> > - EUROCONVERT with three required and two optional parameters and Excel
> >   semantics for compatibility.
> 
> Okay, I'm easily sold on that.  Does anyone object?
> 
> Unless there are objections, I will modify my version of EUROCONVERT as suggested.

No one objected, and as that section was unmodified I changed it
accordingly when I came across. The different behavior though with and
without 4th parameter (FullPrecision) being supported may be unexpected.
FullPrecision says how to treat the result, True == full precision,
False == round to currency dependent decimals, with a default of False.
However, applications not supporting that parameter may tend to return
the full precision result, implying a default of True there.

As Gnumeric currently is the only application having a EUROCONVERT
function: would the Gnumeric developers be willing to either support the
additional 2 optional parameters, or change their 3 parameter version to
return a result as if a FullPrecision=False was given?

Otherwise we'd have to state in the spec that, depending on the
application, one may or may not get a rounded result, which isn't really
user friendly..

  Eike

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