Hi Patrick,
On Monday, 2008-04-14 15:52:52 -0400, Patrick Durusau wrote:
> Remember that we are standardizing functions that users *expect* to see in
> spreadsheets. Unfortunately, if we were to lose YEARFRAC, there are other
> financial functions that depend upon it. I know there are at least three
> but suspect if we looked closely we would find others.
Roundabout 25, actually all financial functions of section 6.11 that
take an optional parameter "Integer basis = 0".
> I really don't see any alternative to following the "Excel non-definition"
> however it gets defined.
Exactly. But only if their definition defines the behavior as it is
implemented, not wishful thinking ...
Eike
--
OpenOffice.org Engineering at Sun: http://blogs.sun.com/GullFOSS