Report Output data getting spit in two rows in excel file due to line breakage
Summary:
We have an OTBI report based on an Analysis where the Data Model is also using Analysis. In the data, there are line breaks within certain fields.
When exporting the report to Excel, we expect the data with line breaks to appear within a single row (in one cell). However, currently the data is splitting across two different rows, which is causing issues.
Could you please suggest any possible workaround to maintain line breaks within a single Excel cell when exporting the report?
Content (please ensure you mask any confidential information):
OTBI Reports
Version (include the version you are using, if applicable):