https://bugs.documentfoundation.org/show_bug.cgi?id=92961
Yousuf Philips (jay) <[email protected]> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |[email protected]
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) <[email protected]> ---
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._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
