This document outlines how to modify a Service Desk list form (e.g. list_in.htmpl) to display column headings, such as "Projected Violation", over 2 lines,and then export the list to a MS Excel file so that both lines of the headings are displayed in the exported file.
In order to display the column heading over 2 lines in the exported MS Excel file, we need to modify the list form per below.
e.g. "Projected Violation" attribute in list_in.htmpl.
- Copy the list_in.htmpl file from \bopcfg\www\htmpl\web\analyst to NX_ROOT\site\mods\www\htmpl\web\analyst
- Make the following change in NX_ROOT\site\mods\www\htmpl\web\analyst\list_in.htmpl.
<PDM_MACRO name=lsCol hdr="Projected <br> Violation" attr=mintime>
<PDM_MACRO name=lsCol hdr="Projected <br> Violation" attr=mintime exporthdr="Projected \\n Violation">
- Save the file and run a 'pdm_webcache -H' on the server and then clear your browser cache.
Now test the export and verify that the header value is correctly exported.