This project has moved. For the latest updates, please go here.

Cell with newline does not show text on multiple lines

Aug 22, 2011 at 2:41 PM

Hi!

I'm getting the data from a SQL-table. One field is adressinformation where name, address, postal address is separated with newline (i.e. Environment.Newline).

First I got the problem that newlines where shown as _x00D_, but I solved by compiling the latest version from source.

Now I have the problem that the text is printed on one line. If I double click on a cell with a newline and then clicks on another cell, the text is show on multiple lines.

Is there a property or similiar to set that does nor require the user to doubleclick a cell to see the content on multiple lines?

/Andreas

Coordinator
Aug 23, 2011 at 7:01 PM

Have you set the Style.WrapText property for the range?

Aug 24, 2011 at 7:08 AM
JanKallman wrote:

Have you set the Style.WrapText property for the range?

No i didn't  set Style.WrapText.  Now I've done it and it works as expected.

Thank you!

Jan 11, 2012 at 3:44 AM

Same problem.

Jan 22, 2015 at 4:39 AM
If the text is lets say "Testing line breaks in Epplus /r/n Not Working"

Setting the Style.WrapText=true is rendering the column as

Testing
line
breaks
in
Epplus
Not
Working

However, I would like to view it as

Testing line breaks in Epplus
Not working