Details

    • Type: Bug
    • Status: Closed
    • Priority: Blocker
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: ODF 1.2 Part 2 CD 3
    • Component/s: OpenFormula
    • Labels:
      None
    • Proposal:
      Hide

      A few corrections:

      Replace "Basis: [optional] indicates how the year is to be treated; see section 3.11.6"

      with

      "Basis: [optional] indicates the day count basis to use; see section 3.11.6"

      Replace "Constraints: If settlement date or maturity date is not valid, INTRATE returns an error."

      with

      Constraints: Settlement < Maturity

      From Semantics remove
      "If the Settlement date is equal to or after the maturity date, an Error is returned."

      And add the formula:

      The return value for this function is: ( (Redemption- Investment)/Investment ) / YEARFRAC(Settlement; Maturity; Basis)

      Show
      A few corrections: Replace "Basis: [optional] indicates how the year is to be treated; see section 3.11.6" with "Basis: [optional] indicates the day count basis to use; see section 3.11.6" Replace "Constraints: If settlement date or maturity date is not valid, INTRATE returns an error." with Constraints: Settlement < Maturity From Semantics remove "If the Settlement date is equal to or after the maturity date, an Error is returned." And add the formula: The return value for this function is: ( (Redemption- Investment)/Investment ) / YEARFRAC(Settlement; Maturity; Basis)

      Description

      Copied from office-comment list

      Original author: "David King" <openoffice@drking.plus.com>
      Original date: 5 Sep 2008 17:35:41 -0000
      Original URL: http://lists.oasis-open.org/archives/office-comment/200809/msg00007.html

        Attachments

          Activity

            People

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

              Dates

              • Created:
                Updated:
                Resolved: