https://bugs.documentfoundation.org/show_bug.cgi?id=80149
Eike Rathke <[email protected]> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |[email protected]
--- Comment #5 from Eike Rathke <[email protected]> ---
Characters below 0x20, except tab, carriage return and linefeed, are illegal
characters in XML, see https://www.w3.org/TR/xml/#charsets
EVEN the &#xhhhh; entity reference representation, see
https://www.w3.org/TR/xml/#sec-references "Well-formedness constraint: Legal
Character".
This is the reason why they are not saved to .ods
Actually they should also be dropped when saving to .xlsx as you see Excel
otherwise stumbles.
Excel apparently came up with their own unspecified invention to save such as
_x0016_. As you have to be able to distinguish a literal "_x0016_" they write
that as "_x005F_x0016_". Oh glory. That's "encoding illegal XML characters in
SQL" http://dcx.sap.com/1200/en/dbusage/xmldraftchapter-b-3488944b.html where
"_x" is encoded as "_x005F_x", so they borrowed that from their SQL-Server
guys.
--
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