<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><table border="1" cellspacing="0" cellpadding="8">
<tr>
<th>Bug ID</th>
<td><a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - Calc loses spreadsheet rows when creating .xlsx file from .CSV file containing CR (ascii=13) character. Creating plain .xls file works properly."
href="https://bugs.documentfoundation.org/show_bug.cgi?id=139707">139707</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>Calc loses spreadsheet rows when creating .xlsx file from .CSV file containing CR (ascii=13) character. Creating plain .xls file works properly.
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>unspecified
</td>
</tr>
<tr>
<th>Hardware</th>
<td>All
</td>
</tr>
<tr>
<th>OS</th>
<td>All
</td>
</tr>
<tr>
<th>Status</th>
<td>UNCONFIRMED
</td>
</tr>
<tr>
<th>Severity</th>
<td>normal
</td>
</tr>
<tr>
<th>Priority</th>
<td>medium
</td>
</tr>
<tr>
<th>Component</th>
<td>Calc
</td>
</tr>
<tr>
<th>Assignee</th>
<td>libreoffice-bugs@lists.freedesktop.org
</td>
</tr>
<tr>
<th>Reporter</th>
<td>teccardt@gmail.com
</td>
</tr></table>
<p>
<div>
<pre>Description:
I lost a lot of by-hand-input data when I created an XLSX file, starting from a
CSV file, and adding a few columns.
Subsequent experimentation showed that this loss was not caused by additional
data, but Calc will not save ANY data when a CSV file with CR char is used.
For some reason, saving to plain XLS file works.
Steps to Reproduce:
1. Create a CSV file with an asci=13 (CR) character in one text cell (within
quotes)
2. Click on it to open it with Libreoffice CALc
3. Notice that file looks okay in LibreOffice (contains data from CSV file)
4. Save file as a XLSX file.
5. Click on XLSX file and notice that all data after the line with the CR
character is gone.
6. Now try same procedure, but saving as an XLS file. This works correctly.
Actual Results:
XLSX file is missing all data after the CR (ascii=13) character
Expected Results:
XLSX should look like XLS file
Reproducible: Always
User Profile Reset: No
OpenGL enabled: Yes
Additional Info:
Version: 5.1.6.2
Build ID: 1:5.1.6~rc2-0ubuntu1~xenial10
CPU Threads: 4; OS Version: Linux 4.15; UI Render: default;
Locale: en-US (en_US.UTF-8); Calc: group</pre>
</div>
</p>
<hr>
<span>You are receiving this mail because:</span>
<ul>
<li>You are the assignee for the bug.</li>
</ul>
</body>
</html>