<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><span class="vcard"><a class="email" href="mailto:philipz85@hotmail.com" title="Yousuf Philips (jay) <philipz85@hotmail.com>"> <span class="fn">Yousuf Philips (jay)</span></a>
</span> changed
<a class="bz_bug_link
bz_status_NEW "
title="NEW - FILESAVE: XLSX - New line doesnt import correctly into Excel when text has multiple direct formatting parts"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=92961">bug 92961</a>
<br>
<table border="1" cellspacing="0" cellpadding="8">
<tr>
<th>What</th>
<th>Removed</th>
<th>Added</th>
</tr>
<tr>
<td style="text-align:right;">CC</td>
<td>
</td>
<td>philipz85@hotmail.com
</td>
</tr>
<tr>
<td style="text-align:right;">Blocks</td>
<td>
</td>
<td>108662
</td>
</tr>
<tr>
<td style="text-align:right;">Summary</td>
<td>direct formatting of of text garbles line breaks on export to OOXML
</td>
<td>FILESAVE: XLSX - New line doesnt import correctly into Excel when text has multiple direct formatting parts
</td>
</tr></table>
<p>
<div>
<b><a class="bz_bug_link
bz_status_NEW "
title="NEW - FILESAVE: XLSX - New line doesnt import correctly into Excel when text has multiple direct formatting parts"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=92961#c8">Comment # 8</a>
on <a class="bz_bug_link
bz_status_NEW "
title="NEW - FILESAVE: XLSX - New line doesnt import correctly into Excel when text has multiple direct formatting parts"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=92961">bug 92961</a>
from <span class="vcard"><a class="email" href="mailto:philipz85@hotmail.com" title="Yousuf Philips (jay) <philipz85@hotmail.com>"> <span class="fn">Yousuf Philips (jay)</span></a>
</span></b>
<pre>So Calc exports it like this
<r><t>A </t></r>
and Excel exports it like this
<r><t xml:space="preserve">A
</t></r>
where the binary character of 0x0A was after the A.
So the problem turns out to be the missing xml:space attribute of the <t> tag.
(In reply to V Stuart Foote from <a href="show_bug.cgi?id=92961#c5">comment #5</a>)
<span class="quote">> If direct formatting is removed from the cell, with <Ctrl>+M, the cells
> honor the line break on MS Excel.</span >
Yes it is exported correctly in this case, as it did add the xml:space
attribute.
<t xml:space="preserve">A B</t></pre>
</div>
</p>
<div id="referenced">
<hr style="border: 1px dashed #969696">
<b>Referenced Bugs:</b>
<ul>
<li>
[<a class="bz_bug_link
bz_status_NEW "
title="NEW - [META] Cells with multiple direct formatting text parts"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=108662">Bug 108662</a>] [META] Cells with multiple direct formatting text parts
</li>
</ul>
</div>
<br>
<hr>
<span>You are receiving this mail because:</span>
<ul>
<li>You are the assignee for the bug.</li>
</ul>
</body>
</html>