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

XMLWordPrintable

    • 2
    • Severity 3 - Minor

      Issue Summary

      Using dynamic functions that need to refresh themselves as NOW() or TODAY() in the Excel file, Office Excel Macro isn’t able to refresh it dynamically.

      Steps to Reproduce

      1. Create an Excel file and put NOW() function into one cell. It will show the current time like ’25/04/2023 10:15’
      2. After a minute it should execute the NOW() function again and show the time as '25/04/2023 10:16’, but it will continue to show the first.

      Expected Results

      Office Excel Macro should render dynamic functions like NOW() and TODAY().

      Actual Results

      Office Excel Macro and Confluence view options show the wrong values for the dynamic fields;

      The first image is Office Excel Macro and in a red square cell contains the NOW() function, the second image is the original Excel file that shows the correct time.

      Workaround

      Edit and Upload file again shows the correct value again. For TODAY() function can work properly for a day, but there is no workaround for NOW() function.

            Assignee:
            Unassigned
            Reporter:
            Kaan Çalışkan (Inactive)
            Votes:
            2 Vote for this issue
            Watchers:
            3 Start watching this issue

              Created:
              Updated: