Re: [office] YEARFRAC, etc.

From
Eike Rathke <>
Date
2008-04-15T13:28:39+00:00
ID
Thread
Re: [office] YEARFRAC, etc.
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