<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><span class="vcard"><a class="email" href="mailto:jluth@mail.com" title="Justin L <jluth@mail.com>"> <span class="fn">Justin L</span></a>
</span> changed
<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="https://bugs.documentfoundation.org/show_bug.cgi?id=47349">bug 47349</a>
<br>
<table border="1" cellspacing="0" cellpadding="8">
<tr>
<th>What</th>
<th>Removed</th>
<th>Added</th>
</tr>
<tr>
<td style="text-align:right;">Priority</td>
<td>medium
</td>
<td>high
</td>
</tr></table>
<p>
<div>
<b><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="https://bugs.documentfoundation.org/show_bug.cgi?id=47349#c18">Comment # 18</a>
on <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="https://bugs.documentfoundation.org/show_bug.cgi?id=47349">bug 47349</a>
from <span class="vcard"><a class="email" href="mailto:jluth@mail.com" title="Justin L <jluth@mail.com>"> <span class="fn">Justin L</span></a>
</span></b>
<pre>Upgrading to high importance - lots of CCs and more than 5 duplicates and has
been reported for both Windows and Linux.
A partial work-around is to click the mouse after the = (still in the cell).
Yes, the cursor is already blinking there, but clicking there anyway refocuses
it, and then it will pick up the other sheet reference. HOWEVER, when you
return to the original sheet and click in a different cell, it does NOT replace
the other sheet reference, but ADDs it in front.
In some of my testing, it worked on sheets that were farther way, but not on
directly adjacent sheets on either side. However, that wasn't always true.
A key area to start debugging at looks to be sc/source/ui/app/inputhdl.cxx
void ScInputHandler::SetReference
ESelection aSel = pActiveView->GetSelection();
if ( aSel.nStartPara == 0 && aSel.nStartPos == 0 )
return;
since nStartPos is reported as zero in the problematic columns.</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>