<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, on reopen, messes up soft newlines pasted from RichText format"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=114398">114398</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>Calc, on reopen, messes up soft newlines pasted from RichText format
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>5.4.3.2 release
</td>
</tr>
<tr>
<th>Hardware</th>
<td>All
</td>
</tr>
<tr>
<th>OS</th>
<td>Windows (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>hjg.com.ar@gmail.com
</td>
</tr></table>
<p>
<div>
<pre>Description:
When copying a multiline text inside a Cell in Calc, in edit mode, if the text
is available in the Clipboard as Rich TExt Format and it contains soft newlines
(Shift-Enter), then the newlines are correctly shown in Calc. but after closing
and reopening they are lost, and the lines are all joined together (nor even a
blank/space to separate them).
See steps for detail.
It might not a big deal that "importing" loses some formatting. But 1) this is
more than formatting, 2) it looks very bad and unsettling that something looks
ok when working with the document, and when you save and reopen you get
something radically different.
Steps to Reproduce:
1. Open a new Calc Spreadsheet . Enlarge the first cell, say to half the window
width and height.
2. Open Windows Wordpad (or some editor that copies in RichTextFormat) (*)
Type several lines separated not by hard end-of-paragraph newlines (Enter) but
instead by soft line-breaks (Shift+Enter) (**)
3. Select those lines, copy to clipboard (Ctrl-C)
4. In Calc, focus in the big cell in edit mode (F2), and paste from the
clipboard (Ctrl-V)
5. All should look basically ok (also if we switch to another cell, sheet,
document, etc). Close Calc, saving the file.
6. Open the saved document.
[*] I experienced this with a programmers text editor (EditPadPro) that, as a
bonus, copies the text also as rich text format.
[**] these in RTF correspond to \line commands
Actual Results:
Result: all newlines are gone. They are not even replaced by spaces, the
original lines are joined together (a mess).
Expected Results:
Lines should be lines. As were shown originally when copied inside Calc.
Reproducible: Always
User Profile Reset: No
Additional Info:
User-Agent: Mozilla/5.0 (Windows NT 6.1; Win64; x64) AppleWebKit/537.36 (KHTML,
like Gecko) Chrome/63.0.3239.84 Safari/537.36</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>