When using the feature "Export to Excel", only the first 300 rows are returned

book

Article ID: 39793

calendar_today

Updated On:

Products

CLARITY PPM FOR ITG CLARITY PPM FEDERAL Clarity PPM On Premise

Issue/Introduction

When using the feature "Export to Excel" (E2E), only the first 300 rows are returned. If you export a list of projects, for example, only the first 299 projects are exported (plus the header row). 

Cause

This limit cannot be changed or disabled. The intention of the option for 'Export to Excel' or 'Export to PowerPoint' is to provide a nicely formatted output.  Therefore, a restriction on the number of rows to be exported into this format is implemented.

Environment

Release:
Component:

Resolution

Use "Export to Excel (Data Only)" instead, as it does not have a 300 row limit.  This option allows the user to export the numerical data into a spreadsheet and then it can be formatted as desired.