When exporting records through ‘Export to Excel (Data Only)’ YEAR is not displayed in the Excel sheet if Period Type is set to Quarterly in the Time-scaled Value (TSV)
Steps to Reproduce:
1. Go to a portlet with the Export to Excel (Data only) option
2. Configure a TSV attribute to show Quarterly periods
One method to do this:
- Select the Options drop down for the portlet, then Configure
- Select 'Time-scaled Value'
- Change Time Scale to 'Quarter'
- Click 'Save and Return'
- From the Options drop down select 'Export to Excel (Data only)' to export the data
Expected Results: The exported file shows the Quarter number and year (Example: Q2 2016, Q3 2016, Q4 2016, Q1 2017, Q2 2017, Q3 2017)
Actual Results: The exported file shows just the Quarter number but not year (Example: Q2, Q3, Q4, Q1, Q2, Q3)