[Libreoffice-bugs] [Bug 47349] EDITING: Can't point and select cell from sheet (to set formula reference) with freeze column/row enabled

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=47349

Justin L <jluth at mail.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
           Priority|medium                      |high

--- Comment #18 from Justin L <jluth at mail.com> ---
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.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20201106/0576139f/attachment-0001.htm>