Uploaded image for project: 'Confluence Data Center'
  1. Confluence Data Center
  2. CONFSERVER-37079

Office Excel Macro doesn't work correctly with NetWorkDays function

    XMLWordPrintable

Details

    Description

      We use the NetWorkDays function often to know how many work days do we have in real.
      But when we would like to show the Excel file with the Office Connector it shows the wrong day count, if we do not include the weekends.
      And this won't work always, too.
      If you open the Excel file with MS Excel the counts are right.

      Find attached the example Excel file and a screenshot of our test in Confluence.
      You can work with the Excel file in your test system.

      We gave the prio "Major", because we use this function often in our Excel files.

      Attachments

        1. NetWorkDays-Bug.jpg
          NetWorkDays-Bug.jpg
          351 kB
        2. NetWorkDaysTest.xlsx
          11 kB

        Activity

          People

            Unassigned Unassigned
            1dbeaf2ce8d9 CGM
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: