TableExport icon indicating copy to clipboard operation
TableExport copied to clipboard

Published 20 hours ago • verified publisher icon clarketm

line breaks within a cell

Open rajeev13 opened this issue 8 years ago • 3 comments

Thanks for your effort and support. how can we add line breaks within cell itself.

rajeev13 avatar Oct 17 '17 07:10 rajeev13

I have same question.

smrrrazu avatar Oct 17 '17 10:10 smrrrazu

Hi Travis Clarke,

The reference #70 is about new line creating new row,but i am trying the line break in a particular cell itself .

suggested method didn't helped me.

Thank for reply.

rajeev13 avatar Oct 27 '17 06:10 rajeev13

@rajeev13

You are correct – my mistake. I deleted my comment as soon as I realized it was invalid. XLSX seems to be the exception to the fix delineated in #70 .

There are some quirks with Excel related to consistency and which escape characters are interpreted as linefeed and carriage return across platforms (in open xml format). I may be able to achieve this with a cell-style (if supported), but in the meantime, a workaround is to use standard linefeeds in the HTML (&#10;, <br>, or literal return) and enable wrap text in Excel:

excel

clarketm avatar Oct 27 '17 16:10 clarketm