search cancel

Clarity: Export to Excel output for icon fields shows an extra column for the value


Article ID: 49191


Updated On:


Clarity PPM SaaS Clarity PPM On Premise



If we have an icon field configured on a grid view and then export the data out to Microsoft Excel, the output automatically shows two columns - one column for the icon color and one column for the data value. Is there a way to change this configuration?

Steps to Reproduce:

  1. Configure any grid list view or portlet to include an image icon attribute. Example attributes are Risk Score and Alignment Score

  2. Navigate to the list view or portlet that has rows with data showing on the image icons

    <Please see attached file for image>

    Figure 1

  3. Click on the 'Options' icon (on the portlet header bar) > Export to Excel (Data Only)

    <Please see attached file for image>

    Figure 1


The application is behaving as expected. The output to Excel for the image icons had the additional column showing the data value because it is expected that the end-user will want to manipulate or analyze the data values for these attributes.

There are several different types of attributes that will have extra columns as shown in the example.

  1. Column C and Column D are shown as icons in the Clarity application and are generated as a single column in the Export output with the 'value'. These types of Icons are for hyperlinks and will show the 'value' output in Excel and the value will be a hyperlink

  2. Number Attributes configured in Clarity to show Image Icons - Export output shows one column for the value and one column for the color

  3. Investment Stage Attribute - this specific attribute will generate 3 columns in the export output - one column for the 'Current Stage Name', one column for the 'Current Stage Number' and one column for the 'Number of Stages'

  4. Money Attributes - Money attributes will have an extra column shown for the associated Currency Code




Release: ESPCLA99000-13.2-Clarity-Extended Support Plus




1558712353424000049191_sktwi1f5rjvs16sll.gif get_app
1558712351461000049191_sktwi1f5rjvs16slk.gif get_app