Office Excel Macro Shows Wrong Values (server time) for Dynamic Excel Functions as TODAY() and NOW()

XMLWordPrintable

    • 1
    • Severity 3 - Minor

      Issue Summary

      Using dynamic functions as NOW() or TODAY() in the Excel file, Office Excel Macro displays them based on the server timezone

      Steps to Reproduce

      1. Create an Excel file and put NOW() function into one cell. It will show the current time like ’6/26/2024 14:57:52’
      2. Upload the file to a Confluence and the NOW() function shows the time as '6/26/2024 12:58:24’

      Expected Results

      Office Excel Macro should render dynamic functions like NOW() and TODAY() based on user profile or system timezone.

      Actual Results

      Office Excel Macro renders dynamic functions like NOW() and TODAY() based on server time.



      2 minutes late while taking the screenshot

      Workaround

      N/A

        1. image-2024-06-26-15-00-26-820.png
          81 kB
          Puventhira Mannen Pragasam Selladurai
        2. image-2024-06-26-15-01-02-231.png
          8 kB
          Puventhira Mannen Pragasam Selladurai
        3. image-2024-06-26-15-01-42-891.png
          7 kB
          Puventhira Mannen Pragasam Selladurai

            Assignee:
            Unassigned
            Reporter:
            Puventhira Mannen Pragasam Selladurai
            Votes:
            1 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated: