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


Help: OASIS Mailing Lists Help | MarkMail Help

office message

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

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


 OpenOffice.org Engineering at Sun: http://blogs.sun.com/GullFOSS

PGP signature

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