nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle Analytics and AI

Child Item

Unable to introduce new line within an excel cell

Pribin Chacko

Summary

Unable to introduce new line within an excel cell

Content

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?

Thanks,

Pribin

expected result.xlsx

observed result.xlsx

Find more posts tagged with

BI Publisher

BI Publisher Report Templates

Comments

Pribin Chacko

Any update on this? It would be really helpful for us if somebody can confirm whether this works or not?

Sandeep S. Chauhan-Oracle

Hi Pribin,

This is expected behavior when generating the output in Excel file. carriage returns/new paragraphs will affect the output.

These control character can be eliminated in SQL data set under data model.

Or you can also try Excel (html) output as this output type ignores the control characters.

Hope this will help you.

Regards,

Sandeep S. Chauhan

Adhakshi-Oracle

Hi Sandeep,

Excel HTML output also doesn't seem to be working for us. Do you have any other inputs?

Thanks

Alagappan

Sarika Chaudhari-Oracle

Hello Sandeep,

We are also facing same issue, and we have data where we need print product list in cell one after other. But because of new line excel creates new rows and customer is does not want.

Because it will difficult for them to filter the values.

Can you please assist here.

Thanks,

Sarika