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: [OASIS Issue Tracker] Commented: (OFFICE-2630) YEARFRAC ambiguity

    [ http://tools.oasis-open.org/issues/browse/OFFICE-2630?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=18367#action_18367 ] 

Dennis Hamilton commented on OFFICE-2630:

I would assume that the actual/actual case means use 366 days in the denominator for each leap year that has part of the actual interval, use 365 for each non-leap year that has a part of the actual interval.

That's on principle of course.  Whether that is the actual practice in the financial services industry, who knows?  I can imagine arcane cases where it matters whether February 29 is included in the actual interval or not, and so on.

It looks like we have two issues with these things:

 1. We need to have a clear-cut, unambiguous definition of these where anyone can understand pricely what the rule is.  That way, when someone is dealing with a system that honors the OpenFormula definitions, they know how to get what they want from what OpenFormula has.

 2. It would be great if what (1) is aligns with what is "common" in the sense of the dominant expectation and existing experience with spreadsheet programs already in use.  That probably is most-safely determined by carefully-crafted inspection.

> YEARFRAC ambiguity
> ------------------
>                 Key: OFFICE-2630
>                 URL: http://tools.oasis-open.org/issues/browse/OFFICE-2630
>             Project: OASIS Open Document Format for Office Applications (OpenDocument) TC
>          Issue Type: Bug
>          Components: OpenFormula
>    Affects Versions: ODF 1.2 Part 2 CD 1
>            Reporter: Robert Weir 
> I thought we nailed this one a while ago, but I see the problem still in Part 2, CD 01.
> YEARFRAC is currently defined as "Computes the fraction of the number of years between a StartDate and EndDate.
> Basis is the system for determining how many days are in a month or year."
> OK.  So YEARFRAC is A/B where A= number of days between the two dates, using the counting conventions of the basis.  And B is what? A year certainly.  But how many days?  365?  365.25?  Dependent on whether date 1 or date 2 is in a leap year?  
> I thought David figured this out at one point.

This message is automatically generated by JIRA.
If you think it was sent incorrectly contact one of the administrators: http://tools.oasis-open.org/issues/secure/Administrators.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira


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