Issue 46939

When the current selection is in the unfrozen area and when you search for an
item that is in a frozen row/column, the view scrolls unnecessarily, which is
annoying. The view will scroll even if the searched "target" is already visible.
 Sadly, I was unable to create test cases that always provide the same result. A
random element remains, which seems to be somehow tied to window size. However,
a part of the behavior is unchanging.


Example :
* Paste this formula in cell A1: =SUBSTITUTE(ADDRESS(ROW(A1);COLUMN(A1));"$";"")
* Extend/copy the formula to A1:E5 area
* Freeze row 1 and column A (select cell B2 and do menu Window > Freeze)
* Scroll down one row and right one column.
* Resize the Calc window to hide all empty cells – that is show only area A1:E5,
with row 2 and columns B hidden thanks to the freeze feature.

The window should show:

A1	C1	D1	E1
A3	C3	D3	E3
A4	C4	D4	E4
A5	C5	D5	E5


* Select a cell in any column but column A and search for A4. I alternatively
got 3 different results in my numerous attempts to provide a fault-proof test
case. The random element seems to be dependent on window size and OOo session
history and independent of which cell is selected before the search (provided it
is outside column A).

The three possible (encountered) results are :

A1	B1	C1	D1
A3	B3	C3	D3
A4	B4	C4	D4
A5	B5	C5	D5

or

A1	B1	C1	D1
A4	B4	C4	D4
A5	B5	C5	D5
.	.	.	.

or

A1	B1	C1	D1
A2	B2	C2	D2
A3	B3	C3	D3
A4	B4	C4	D4

In the first case, the search operation only scrolled the view horizontally. In
the second and third case, the horizontal scroll is the same as in case one but
a vertical scroll is added.

There is no need to scroll the unfrozen area horizontally as A4 is already
visible. This unnecessary scrolling hides columns, which can be quite annoying.
For example, suppose you are editing some data in column E, you will have to
scroll back to it after each search (if you forgot to move you selection in
column A beforehand). Searching for an out-of-view cell, for example A2 instead
of A4, also provoke the troublesome horizontal scroll.

The vertical scroll is also unnecessary. It's random aspect is rather pesky.

The search scrolling behavior seems to be consistent if you consider searching
for a frozen ow cell instead of a frozen column one, give or take the random
element.

In my opinion, this unnecessary scrolling defeats the purpose of Freeze when
using Search. When editing a large array, I'd like the view to scroll only the
minimum necessary amount and not to have to scroll back to my working area after
each search for which I forgot to move the selection into the frozen area.

I hope this rather long description was sufficiently clear – do not hesitate to
contact me if something isn't.

Sincerely,

Fousage