Exporting Gantt chart to Excel file switches colors of Primary and secondary bars with respect to portlet

Products

• Clarity PPM On Premise
• Clarity PPM SaaS

Issue/Introduction

When exporting a Gantt chart to an Excel file, the colors of the bars are reversed with respect to what is displayed in the portlet.
In a Portlet, the Primary bar of the Gannt has a dark blue color and the secondary bar has a light blue color.
However after export to Excel (Export to Excel) the colors switch around. The Primary bar in the output has a light blue color and the secondary bar has a dark color.

Steps To Reproduce:

1. Create a Task in a Project. Set duration for both Task and Project to:  January - July.
2. Create a Baseline.
3. Extend Finish date of the Task to December
4. Create a Grid portlet Task object as data provider.
5. From the 'List Column Section' dropdown of the portlet, navigate to 'Fields' and create a new virtual field with 'Display Type' set to 'Gantt'
6. Set 'Primary Bar' - 'Item Name Attribute' to 'Name', 'Start Date Attribute' to 'Start', 'Finish Date Attribute' to 'Finish'
7. Set 'Secondary Bar' - 'Item Name Attribute' to 'Name', 'Start Date Attribute' to 'Baseline Start', 'Finish Date Attribute' to 'Baseline Finish'
8. Tick the  'Show Secondary Bar' checkbox
9 In Clarity Classic - Home page, navigate to 'Page: Overview - Manage Tabs'. Create a new tab and add the newly created portlet.
10. Display the portlet from the tab in the 'Overview' page. The Gantt display 'Dark blue' and 'Light blue' for Primary and Secondary bars. Now export Gantt to Excel

Expected: Excel output display Gantt chart just like it is displayed in Clarity

Actual: Gantt colors switch around. The Primary bar in the Excel output has a light blue color and the secondary bar has a dark color.

Environment

Clarity 16.3.3, 16.4.1, 16.4.2

Cause

DE205115

Resolution

Currently under review by Engineering