OASIS Mailing List ArchivesView the OASIS mailing list archive below
or browse/search using MarkMail.


Help: OASIS Mailing Lists Help | MarkMail Help

office-formula message

[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]

Subject: EUROCONVERT (was: [office-formula] CONVERT)


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..


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

[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]