Excel BIP report: Comment field split over several rows and columns
BIP report: How can we make sure that comment field is not split up over several rows and columns when exporting report to Excel?
we have built a custom BIP report for performance data using an RTF template.
When we export the report to Excel, we are facing the issue that the comments are split up over several rows and columns in Excel, depending on how the comments are entered in the performance document (e.g. when using bullet points).
Could anyone help what we can do here, so the columns are always displayed in one row and one column when we export to Excel (and not splitting up?).