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 ... Eike -- OpenOffice.org Engineering at Sun: http://blogs.sun.com/GullFOSS