Can we format the excel report?

[carlh]

Hello All,

I have several Scheduled reports that are sent in Excel.   The formatting is really bad so we hope there is a way to make it look better.   Does anyone have a way to do this?   Currently on Helsinki.

Thanks

Carl

[carlh · Accepted solution]

Thanks Lisa and Tara,

We've got resources to do things externally but that's not what we want to do.  

We are not in Istanbul and there is a system property called "glide.export.excel.wrap_cells" and that value is set to "TRUE" which means the cells will be wrapped.   You can change it to false which will NOT Wrap the text.   When Setting to "FALSE" we had an issue where excel couldn't open.   We learned that there is a 255 character limit so anything over, caused the error.   The solution there was to remove those fields that had over 255 characters.

Neither of the options were to our liking so I came up with the idea to add spaces to the end of the "Label" of the fields that have a lot of text and it looks much better.

If you have the system property value set to TRUE, and increase the length of the label by adding spaces, it is able to be opened and eliminates a great deal of the work needed to make the excel file readable.

Screen shot attached.

NOTE: I didn't bother to increase the label length on sys fields such as Created or Updated but those on the incident table seem to work just fine.

I hope that helps some of you with this issue.

Regards!

Carl