[Libreoffice-bugs] [Bug 92961] FILESAVE: XLSX - New line doesnt import correctly into Excel when text has multiple direct formatting parts

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=92961

Yousuf Philips (jay) <philipz85 at hotmail.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |philipz85 at hotmail.com
             Blocks|                            |108662
            Summary|direct formatting of of     |FILESAVE: XLSX - New line
                   |text garbles line breaks on |doesnt import correctly
                   |export to OOXML             |into Excel when text has
                   |                            |multiple direct formatting
                   |                            |parts

--- Comment #8 from Yousuf Philips (jay) <philipz85 at hotmail.com> ---
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 comment #5)
> If direct formatting is removed from the cell, with <Ctrl>+M, the cells
> honor the line break on MS Excel.

Yes it is exported correctly in this case, as it did add the xml:space
attribute.

<t xml:space="preserve">A
B</t>


Referenced Bugs:

https://bugs.documentfoundation.org/show_bug.cgi?id=108662
[Bug 108662] [META] Cells with multiple direct formatting text parts
-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20170702/b4e7270d/attachment-0001.html>