Posted: 6 Jun 2018 14:54 EDT Last activity: 29 Jun 2018 7:35 EDT
Customization on export to excel functionality
We have a requirement to customize the export to excel functionality and want to know if the following options are feasible in Pega 6.1 SP2 after clicking on Export to Excel button.
1. Disable Wrap Text feature
2. Adding filter to each column in the excel
3. Freezing the columns in excel
Other than the "Export Format" field on the list view "Display Fields" tab, I don't know of any way to affect the formatting of exported Excel reports. You might be able to create a "no wrap" text control to use there, but I doubt you will be able to implement the other 2 requirements there.