<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 - FORMATTING: Validity cell range with invisible characters (e.g. newline) stripped"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=125595">125595</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>FORMATTING: Validity cell range with invisible characters (e.g. newline) stripped
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>6.0.7.3 release
</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>m-Matti-a.Lehtonen@IKI.Fi
</td>
</tr></table>
<p>
<div>
<pre>Description:
When there is defined a validity check with cell range and those cells contain
invisible characters, especially newline character there are multiple issues.
1) The selection menu has stripped the invisible characters e.g. newline
2) When the value selected to cell, the invisible characters e.g. newline are
stripped (visually). How ever vlookup() finds correctly
3) When opening document, then the vlookup() fails, and is fixed after
reselection
Steps to Reproduce:
1. Fill several cells with normal text and newline characters
2. Set a validity for some cell with the cells as a range above
3. Have at another cell a vlookup() to verify validity of selected value
4. save, close and reopen the document
5. Notice the vlookup() to fail
Actual Results:
1. After selection newline characters have no effect of causing a visual new
line
2. vlookup() fails after loading document
Expected Results:
1. Pulldown menu can have a fixed height cells for value selection
2. When a value is selected, newlines work as expected
3. after loading a document, vlookup() do not fail
Reproducible: Always
User Profile Reset: No
OpenGL enabled: Yes
Additional Info:
Version: 6.0.7.3
Build ID: 1:6.0.7-0ubuntu0.18.04.5
CPU threads: 4; OS: Linux 4.15; UI render: default; VCL: gtk3;
Locale: en-CA (en_CA.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>