Export to Excel (Data Only) and (CSV) does not export the display values for Display mappings (Range Descriptions)

book

Article ID: 130504

calendar_today

Updated On:

Products

CLARITY PPM FOR ITG CLARITY PPM FEDERAL Clarity PPM SaaS Clarity PPM On Premise

Issue/Introduction

We found that exporting the Range Descriptions does not work in Export to Excel (Data Only) and (CSV)
Only numbers get exported, and the regular Export to Excel works fine.

Environment

Release: CODFSS99000-15.5-PPM SAAS FedRAMP-Sandbox-Small Environment
Component:

Resolution

This is working by design
 
* Export to Excel (regular) is meant to provide a quick way to capture limited results that are seen on the screen in Classic out to Excel with Range Descriptions based on the Classic 'view' configuration.
* However, the Export to Excel (Data Only) and CSV are just meant to provide data and more rows for data use; we are not exporting the Classic 'view' configuration of showing a range description.
 
The reason it could actually work in some views is that there it's actually a Lookup value and not a Range Description.
 

Additional Information

For more info:
DE48112 Export to Excel (Data Only) on master object does not use the Range Description for the Aggregated Number Lookups and exports numbers only NAB