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

ODFF: PMT PayType parameter should be Logical, and Nper constraint?

    XMLWordPrintable

    Details

    • Proposal:
      Hide

      PayType: the type of payment, defaults to FALSE(). It is FALSE() if
      payments are due at the end of the period; TRUE() if they are
      due at the beginning of the period. With PayType=TRUE() the
      first payment is made on the same day the loan is taken out.
      "

      Show
      PayType: the type of payment, defaults to FALSE(). It is FALSE() if payments are due at the end of the period; TRUE() if they are due at the beginning of the period. With PayType=TRUE() the first payment is made on the same day the loan is taken out. "

      Description

      6.12.36 PMT
      [ ; Number PayType = 0 ]
      should be
      [ ; Logical PayType = FALSE() ]
      instead, and
      "
      PayType: the type of payment, defaults to 0. It is 0 if payments are due
      at the end of the period; 1 if they are due at the beginning of
      the period. With PayType=1 the first payment is made on the
      same day the loan is taken out.
      "
      should be
      "
      PayType: the type of payment, defaults to FALSE(). It is FALSE() if
      payments are due at the end of the period; TRUE() if they are
      due at the beginning of the period. With PayType=TRUE() the
      first payment is made on the same day the loan is taken out.
      "

      Furthermore, LibreOffice, Excel and Gnumeric treat the Nper parameter
      with constraint Nper != 0 instead of Nper > 0. If and how much sense it
      makes to have Nper < 0 is beyond my financial background..

      Eike Rathke https://lists.oasis-open.org/archives/office-comment/201607/msg00002.html

        Attachments

          Activity

            People

            • Assignee:
              patrick Patrick Durusau
              Reporter:
              patrick Patrick Durusau
            • Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated: