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

ODFF: IPMT Type parameter should be Logical

    XMLWordPrintable

    Details

    • Proposal:
      Hide

      Type: the due date for the payments (optional). FALSE() if omitted. If
      type is TRUE(), then payments are made at the beginning of each
      period. If type is FALSE(), then payments are made at the end of
      each period.

      Show
      Type: the due date for the payments (optional). FALSE() if omitted. If type is TRUE(), then payments are made at the beginning of each period. If type is FALSE(), then payments are made at the end of each period.

      Description

      6.12.23 IPMT
      defines the last parameter as [ ; Number Type = 0 ]

      Excel, LibreOffice and Gnumeric treat it as Logical instead, the
      definition should be [ ; Logical Type = FALSE() ]
      and
      "
      Type: the due date for the payments (optional). Zero if omitted. If type
      is 1, then payments are made at the beginning of each period. If
      type is 0, then payments are made at the end of each period.
      "
      be changed to
      "
      Type: the due date for the payments (optional). FALSE() if omitted. If
      type is TRUE(), then payments are made at the beginning of each
      period. If type is FALSE(), then payments are made at the end of
      each period.
      "

        Attachments

          Activity

            People

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

              Dates

              • Created:
                Updated: