-
Type:
Bug
-
Resolution: Unresolved
-
Priority:
Low
-
None
-
Affects Version/s: 7.19.6
-
Component/s: Integrations - Office Connector
-
None
-
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
- Create an Excel file and put NOW() function into one cell. It will show the current time like ’25/04/2023 10:15’
- 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.
- is related to
-
CONFSERVER-96031 Office Excel Macro Shows Wrong Values (server time) for Dynamic Excel Functions as TODAY() and NOW()
-
- Gathering Impact
-