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

6.10.14 NETWORKDAYS has inconsisten semantics.

    XMLWordPrintable

    Details

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

      In 6.10.14 NETWORKDAYS replace the first sentence of the semantics:
      "Semantics: Returns the whole number of days between two dates, ignoring weekends."
      with
      "Semantics: Returns the whole number of work days between two dates."

      Show
      In 6.10.14 NETWORKDAYS replace the first sentence of the semantics: "Semantics: Returns the whole number of days between two dates, ignoring weekends." with "Semantics: Returns the whole number of work days between two dates."

      Description

      "6.10.14 NETWORKDAYS
      Summary: Returns the whole number of work days between two dates."

      appears to be the correct intention for this function. The Semantics section starts:

      "Semantics: Returns the whole number of days between two dates, ignoring weekends.
      Work days are defined as non-weekend, non-holiday days. By default, weekends are Saturdays
      and Sundays and there are no holidays."

      In view of the second sentence the first sentence conflicts with the summary. Since if we were only ignoring weekends we would not need the holidays specified. So I suspect that the first sentence of the semantics should be:

      "Semantics: Returns the whole number of work days between two dates."

        Attachments

          Activity

            People

            • Assignee:
              patrick Patrick Durusau
              Reporter:
              aguelzow Andreas Guelzow (Inactive)
            • Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: