Announcing a new experience for the Oracle Analytics community coming April 4th!
This category will be read-only as we migrate this space from 3/30-4/4, after which you’ll be able to post as usual. See you there!
Unable to introduce new line within an excel cell
SummaryUnable to introduce new line within an excel cell
I am from Oracle Service Cloud (OSvC). We are using BI Publisher in our product to export data in various formats (We have XSL and XML). Our data is in a tabular format with multiple rows and columns. There are line breaks within data in most of the cells. When we export this data to excel, these line breaks are appearing as new rows. But we expect new line within the same cell. This causes the number of rows in excel to increase to a very large value.
Is there any way to introduce line breaks within excel cell?