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

6.11.37 PPMT - Test case includes too many arguments, function definition missing

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: ODF 1.2
    • Component/s: OpenFormula
    • Labels:
      None
    • Resolution:
      Hide

      No change required

      Show
      No change required

      Description

      The third expression for the PPMT function appears to be incorrect, containing too many parameters.

      Current Expression:
      =PPMT(3%;1;12;100;1;200;1)

      Result:
      -23.435558876±ε

      I believe the corrected expression should be:
      =PPMT(3%;1;12;100;200;1)

      It's unclear if this affects the text of the function definition until a formula definition is added.

        Attachments

          Activity

            People

            • Assignee:
              ericpa Eric Patterson
              Reporter:
              ericpa Eric Patterson
            • Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: