setting WrapText on merged Cells

May 20, 2011 at 6:12 PM

hi guyz,

seems this is not working for me. i merged several cells to a single range, but after setting the WrapText = true on the range, its still not wrapping the text to the next line

 

 

Coordinator
May 25, 2011 at 9:28 PM

Hi,

Works for me when I try it (latest source). Is the Wrap text checkbox set when you open the format dialog in Excel?

Also make sure you use \r\n in the string to change to a new line.

Oct 24, 2012 at 6:31 PM

Perfect, working fine now but this also leads to another issue, whenever i merge several cells, not all the contents in the new ranged cell are displayed, the contents are restricted into a single line and the rest contents can only be viewed by manually expanding the row height in Excel

Nov 12, 2012 at 8:28 AM

Plz, anybody (or Jankallman) with tips in fixing this issue?

 

thanx in advance

Nov 21, 2012 at 5:56 PM

Hi,

 

Even i am facing the same issue as phoxware mentioned. anybody please help. Is there any work around or this is bug/limitation for EpPlus. 

Dec 4, 2012 at 8:40 AM

I am facing the same problem when I do: 

ExcelPackage pck = new ExcelPackage();           
var ws = pck.Workbook.Worksheets.Add("newWorkbook");           
ws.Cells["A" + 1].Value = comments;                       
ws.Cells["A" + 1 + ":F" + 1].Merge = true;           
ws.Cells["A" + 1 + ":F" + 1].Style.WrapText = true;            

 

Is this a bug or is it working for anyone else?

Thanks!

Nov 7, 2014 at 2:52 PM
Hi Everyone,

So it is almost 2 years since the last post in this thread and I am also experiencing the same problem.

Has anyone found a solution to this issue? Is there a workaround available?

It would be really great to be able to display all the text in a merged range.

Thanks!