[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]
Subject: 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.