Idea Summary
When a column is hidden and included in a download in an Interactive Grid, allow the headers to be set so they are not null in the exported file.
Or when hiding a column using the Actions > Columns setting in an Interactive Grid, provide the option to include that column in the report download.
Use Case
The end user just wants to see a summary view in the APEX app, but will use/need columns when downloading to Excel or PDF.
One such example is that I have an Interactive Grid that summarizes several columns into one column to save on horizontal real estate (imagine concatenating columns in an unordered list or sub-table in an IG cell). However, when the user downloads the report, they want to see the individual columns in the Excel/PDF.
Preferred Solution (Optional)
I have two different solutions to this (maybe implement both to give the user some options):
- Under “Export/Printing” for the column, when “Include In Export / Print” is toggled, add a field called “Export/Print Header”. This opens a lot of possibilities where the user can set their own header for the downloaded item.
- In the Interactive Grid under Actions > Columns, when a column is selected no matter the status of the column (hidden or shown), display an option “Include in Download” and this option is automatically checked if the user selects the column to be displayed. And give the user the option to uncheck the “Include in Download”