<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 - active cell is not considered a single-cell selection in find (& replace) tool"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=111843">111843</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>active cell is not considered a single-cell selection in find (& replace) tool
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>5.3.5.2 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>stephane.guillou@member.fsf.org
</td>
</tr></table>
<p>
<div>
<pre>Description:
When using the "find & replace" tool after clicking on a single cell and using
the "current selection only", the tool will not find a search criteria even if
it exists in the active cell.
I think this is not intuitive. I assume most people would consider that the
active cell they just clicked on is considered a "selection".
I am aware of the fact that it is not highlighted like a cell range would be,
and that it is possible to click and drag from A1 over to A2 and back to A1 in
order to highlight what we could call a "single-cell range", but that would not
be straight-forward. An active cell is in my opinion a selection, and I can't
think of a case when the active cell is not part of a selected range.
In my opinion, the following is a further confirmation that this is a bug:
When the active cell contains something, the option "Current selection only" is
selectable; however, when the active cell is empty, the option "Current
selection only" is greyed out. This shows that the tool differentiates between
active cells that contain something and cells that don't, just like it does for
ranges.
Steps to Reproduce:
1. Open a new document
2. Write "blah" in cell A1
3. Click on cell A1
4. Open the "Find & Replace" tool
5. Write "blah" in the "Find" field
6. Tick the option "Current selection only"
7. Click "Find All" (or alternatively, click "Replace All")
Actual Results:
The tool returns "Search key not found".
Expected Results:
The tool finds the term in the selected (active) cell.
Reproducible: Always
User Profile Reset: No
Additional Info:
System details:
Version: 5.3.5.2
Build ID: 50d9bf2b0a79cdb85a3814b592608037a682059d
CPU Threads: 2; OS Version: Linux 3.13; UI Render: default; VCL: kde4; Layout
Engine: new;
Locale: en-GB (en_GB.UTF-8); Calc: group
User-Agent: Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:54.0) Gecko/20100101
Firefox/54.0</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>