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-2704

ACCRINT description is inconsistent

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Deferred
    • Priority: Major
    • Resolution: Later
    • Affects Version/s: ODF 1.2 CD 05
    • Fix Version/s: ODF-Next
    • Component/s: OpenFormula
    • Labels:
      None
    • Resolution:
      Hide

      In definition of ACCRINT (Part 2, section 6.12.2) make the following changes:

      Replace Constraints with "issue < settlement ; coupon > 0; par > 0"

      Show
      In definition of ACCRINT (Part 2, section 6.12.2) make the following changes: Replace Constraints with "issue < settlement ; coupon > 0; par > 0"

      Description

      The description of ACCRINT has several issues:

      1) The constraint is given as: issue < first < settlement ; coupon > 0; par > 0. OOo and Excel clearly permit settlement<first and most examples on the web seem to be of that kind.

      2) The short description of calc_method reads "A logical value that specifies how to treat the case where settlement>first." which seems to imply that there is a permitted case where settlement > first does not hold.

      3) The formula given contains the undefined variables start-of-period and end-of-period. Especially in view of the statement "ACCRINT
      supports short, standard, and long coupon periods.", it is not clear what those values are.

      4) If the constraint is changed, a formula for the settlement < first case is needed.

        Attachments

          Activity

            People

            • Assignee:
              rcweir Robert Weir (Inactive)
              Reporter:
              aguelzow Andreas Guelzow (Inactive)
            • Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: