Issue
When Vista reports are opened in Microsoft Excel, various columns show trend log values as times.
The columns above in green are correct, they are formatted correctly. The column in red is in a time format instead of the expected percentage format.
Environment
- Vista 5.1.7
- Microsoft Excel
Cause
There is a formatting incapability between Vista 5.1.7 and Microsoft Excel.
Resolution
The formatting issue will be corrected in Vista 5.1.8. If using Vista 5.1.7, Hotfix 18 will correct this issue and can be downloaded here. The work around for this problem is to reformat the affected column(s) before saving or printing the report. To reformat a column in Microsoft Excel, following these steps:
- Open the Vista report.
-
Select the entire column that has been formatted incorrectly.
- Right click on that column and go to Format Cells...
- Under the Number tab, select the format that is desired for these values. Click OK.
- Now print or save the report.
Note: Once this change is made and saved into Vista, the issue may still occur in the future. This is just a way to correct the problem temporarily to view the correct values.