<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 - Broken focus in Calc after setting cell formula reference"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=138047">138047</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>Broken focus in Calc after setting cell formula reference
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>6.4.6.2 release
</td>
</tr>
<tr>
<th>Hardware</th>
<td>All
</td>
</tr>
<tr>
<th>OS</th>
<td>Linux (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>suokunlong@126.com
</td>
</tr></table>
<p>
<div>
<pre>Created <span class=""><a href="http://bugs.documentfoundation.org/attachment.cgi?id=167072" name="attach_167072" title="testdoc.ods">attachment 167072</a> <a href="http://bugs.documentfoundation.org/attachment.cgi?id=167072&action=edit" title="testdoc.ods">[details]</a></span>
testdoc.ods
Steps to Reproduce:
1. Open the attached test ods file.
2. Click on the autofilter dropdown in colum B of Sheet2, select the first
entry (i.e., 21) only, OK. Then click the autofilter dropdown again and select
ALL, OK.
3. Put cursor in C2, type in =, click Sheet1;
4. Click the formula bar (this step is a workaround of <a class="bz_bug_link
bz_status_NEW "
title="NEW - EDITING: Can't point and select cell from sheet (to set formula reference) with freeze column/row enabled"
href="show_bug.cgi?id=47349">bug 47349</a>).
5. Click B2, ENTER.
--> The problem seems to have started here, see step 7.
7. Now if you click Sheet2, then copy C2 (using Ctrl-C), select range C3:C4 and
paste (Ctrl-V), you will notice that the content is only pasted to C3; even
worse, if you further select C3 and put cursor in the end of the formula bar
then hit Backspace or type in anything, the whole cell content is deleted
(rather then the last digit)
More Info:
Bug does not exists when no column/row freeze in Sheet2.
Bug does not exist when you do not do step 2 .
Build id 2020-11-02 00:57:57 +0100 ccad985c5163224d669e9f0fa70fdff070fc58ca
Fedora 32, gtk3.</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>