https://bugs.documentfoundation.org/show_bug.cgi?id=95629
Bug ID: 95629
Summary: CSV "Save as..." format is wrong when exporting from
XLSB with a final \r in a cell value
Product: LibreOffice
Version: 4.3.3.2 release
Hardware: x86-64 (AMD64)
OS: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Open Office Calc gets the CSV format wrong when some cells have a particular
value (a final \r character). It then cannot load back the file as it was from
the exported CSV.
Steps to reproduce
1/ make an XLSB file where a cell has a final \r in its contents (ASCII
character 0x0D, CR)
You may use the attached Perl script for that; fewer rows/cols should suffice.
It will produce a .xls file you can then open in Microsoft Office 2010 to
save it as an .xlsb file
Note: this bug does not show up if working from the XLS format.
2/ save the XSLB file as CSV from LibreOffice Calc (using the Debian package
1:4.3.3-2+deb8u1)
I used options ";" for separator and '"' for text
Looking the .csv resulting file (for example with VIM), one notices the absence
of "..." double quotes around the value of the special cell (but Microsoft
Office does when asked to save this kind of file and produces a valid CSV).
Indeed, Libre Office Calc can not load back the file as it was: it introduces
a row break at the position of this unprotected \r!
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
