Uploaded image for project: 'OASIS Open Document Format for Office Applications (OpenDocument) TC'
  1. OASIS Open Document Format for Office Applications (OpenDocument) TC
  2. OFFICE-2630

YEARFRAC ambiguity

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Applied
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: ODF 1.2 Part 2 CD 1
    • Fix Version/s: ODF 1.2 CD 06
    • Component/s: OpenFormula
    • Labels:
      None
    • Proposal:
      Hide

      Replace current treatment of day count bases in Part 2, section 4.11.6 with the latest revision of the following document:

      http://www.oasis-open.org/committees/document.php?document_id=39507

      We should also adopt a uniform way of referring to this materially in the function definitions, when specifying what the "basis" parameter.

      I recommend "basis Indicates the day-count basis to use; see section 4.11.6".

      Editor's choice as to whether day-count is hyphenated or not.

      "The type of day-count basis" is sometimes used in the text, but I think that is inaccurate. This is not specifying a type.

      The note on YEARFRAC (section 6.10.24.) has a note that should be removed, "The Basis default is not the actual number of days in a month or year" since that is not very helpful. Also remove "Basis is the system for determining how many days are in a month or year" and replace with the above recommended language.

      Show
      Replace current treatment of day count bases in Part 2, section 4.11.6 with the latest revision of the following document: http://www.oasis-open.org/committees/document.php?document_id=39507 We should also adopt a uniform way of referring to this materially in the function definitions, when specifying what the "basis" parameter. I recommend "basis Indicates the day-count basis to use; see section 4.11.6". Editor's choice as to whether day-count is hyphenated or not. "The type of day-count basis" is sometimes used in the text, but I think that is inaccurate. This is not specifying a type. The note on YEARFRAC (section 6.10.24.) has a note that should be removed, "The Basis default is not the actual number of days in a month or year" since that is not very helpful. Also remove "Basis is the system for determining how many days are in a month or year" and replace with the above recommended language.

      Description

      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.

        Attachments

          Activity

            People

            • Assignee:
              rcweir Robert Weir (Inactive)
              Reporter:
              rcweir Robert Weir (Inactive)
            • Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: