I create my table using xslt and want a cell with wrapped text (or better: text with a line break in it).
So my xslt generates the following XML for sheets:
<sheetData> <row r="1"> <c r="A1" t="inlineStr"> <is> <t> a simple string line break jeeeehaaa </t> </is> </c> </row> </sheetData>
After I finished creating my book, I will open it in Excel; and there is no line break, just a simple single line line in A1.
excel , , style.xml. , style.xml, <c r="A1" t="inlineStr"> '( ). , .
<c r="A1" t="inlineStr">
excel , .
sheet.xml, <c> s="1" -.
<c>
s="1"
, style.xml , <cellXfs> <xf>, <alignment> wrapText "1" ( "" ).
<cellXfs>
<xf>
<alignment>
, SO. , :)