OASIS Open Document Format for Office Applications (OpenDocument) TC

 View Only

  • 1.  Arne's comment on ACCRINT function

    Posted 04-02-2026 20:12
    Hello Rich,

    (member list in CC)

    I had a first look at Arne's comment on the ACCRINT function (see mail
    from Patrick from 2026-04-01). Arne wrote,
    "- 6.12.2 ACCRINT: the paragraph "Constraints" requires "First <
    Settlement". The "Semantics" text says: "CalcMethod: A logical value
    that specifies how to treat the case where Settlement > First", which is
    the same as "First < Settlement", which is already required by the
    paragraph "Constraints" anyway. The parameter "CalcMethod" seems to be
    superfluous, which probably means that one of the texts is wrong."

    Arne is correct in his observation about the CalcMethod parameter.

    Google Docs and LibreOffice do not have a CalcMethod parameter.
    PlanMaker has ACCRINT not implemented at all.
    The implementation in LibreOffice has bug 150019 and bug 100450, the
    latter is about the missing 8th parameter.
    The CalcMethod parameter was handled in OFFICE-2566. Andreas Guelzow
    told in that issue, that Gnumeric has not really implemented it.

    Excel uses the CalcMethod parameter and has different results in case
    settlement<first></first>

    So it seems, that only Excel actually uses this parameter. Thus could
    you please ask your Excel-Team to look at the comment from Arne and
    perhaps give us a corrected specification?

    Kind regards,
    Regina


  • 2.  RE: Arne's comment on ACCRINT function

    Posted 04-03-2026 08:39
    Hi members,

    some additions:

    ISO/IEC 29500-1:2016 has the function ACCRINT in section 18.17.7.2. The
    function has only seven arguments there. The constrain there is issue <
    settlement. It has no constraint about first-interest.

    The 8th parameter is an addition of Excel to OOXML. It is documented in
    section 2.1.874, page 396 in [MS-OI29500] - v20250218.

    It might be a solution to remove first-interest from the constraint in ODF.

    Kind regards,
    Regina


    Original Message


Related Content