Export a webi report into xlsx - why does the excel file merge a field on 2 columns

[amadese]

Dear expert,

I need your help because when I export a webi report into xlsx,in the excel file generated; one field is displayed on 2 columns without any reason.

Indeed in the webi report, only on cell is used for displaying the field:

Could you tell me if it's possible to avoid this behaviour or if it's due to the export feature from the tool?

Thanks in adavnce for your halp

[mhmohammed]

Hi Seb,

This is the perfect blog for your question.

https://blogs.sap.com/2016/06/15/how-to-best-export-web-intelligence-data-to-excel/

Thanks,
Mahboob Mohammed

[JohnClark]

I have always seen things like this related to how the fields are formatted in the report. Look for hidden columns, odd alignments, or different cell sizes. It isn't always apparent what the problem is.