Symptom
When using the 'Export to Excel' function in Web Dynpro apps, cells automatically merge, which did not occur in their Design Studio equivalents.
Environment
S/4HANA Cloud
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
Cause
This is a known feature of the web dynpro equivalent to Design Studio apps.
Resolution
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'
Keywords
Excel, merge, unmerge, merged, wrapped, design studio, web dynpro, spreadsheet, header, columns, rows , KBA , FI-FIO-GL-IS , Reporting Apps , How To
Product
SAP S/4HANA Cloud 2105