When using the 'Export to Excel' function in Web Dynpro apps, cells automatically merge, which did not occur in their Design Studio equivalents.
Reproducing the Issue
The following example uses the Web Dynpro version of the 'Trial Balance' app (ID F0996):
- Open the 'Trial Balance' app
- Fill out mandatory fields and execute
- Choose 'Export to Excel'
- See cell merging
This is a known feature of the web dynpro equivalent to Design Studio apps.
An 'Export to Excel (Basic)' feature is planned to address this issue in a future release of S/4HANA Cloud.
Please use the following manual workaround until the automatic solution is implemented:
- Select the affected cells in the excel spreadsheet
- In the 'Home' tab, choose 'Merge & Center'
- Choose 'Unmerge'
Excel, merge, unmerge, merged, wrapped, design studio, web dynpro, spreadsheet, header, columns, rows , KBA , FI-FIO-GL-IS , Reporting Apps , How To
SAP S/4HANA Cloud 2105