Spreadsheet freezes wrong row if other hidden rows exist

[HectorB-2020]

This issue is unique.

• [X] I have used the search tool and did not find an issue describing my bug.

Operating System

Windows 10 / 8.1 / 7

Version information

7.2.1.36

Expected Behavior

The top visible row is frozen regardless of how many other rows are hidden above. This is the behaviour which I observe in MS Word. And there is a strong rationale for that.

Actual Behavior

In spreadsheets with hidden top rows, Freeze Top Row disregards the fact that all rows above are hidden and the first visible row must be frozen instead. The application still freezes the first row which is hidden like I said. Nobody cares hidden rows If one needs to lock the first visible one.

Reproduction Steps

Let's have a sample spreadsheet. Please note that the first three colorful rows intentionally don't contain anything "useful", they rather serve like a multi-row title. Something "useful" begins in row four.

Now we are hiding these the first three rows: right click, Hide.

And finally we are trying to freeze the top row. Menu Freeze Panes, Freeze First Row.

Try scrolling the sheet - in vain :disappointed: - the forth row is not locked. Seems like the frozen row is on line one. But who cares the line number one if it's hidden?

Additional information

No response

[janxkoci]

I can reproduce this using both "Freeze Top Row" as well as "Freeze Panes". I expected at least the second one to work, as it should normally freeze at current position of cursor (selected cell), but it's not working either. :confused:

Edit: I was now trying to unhide the three rows and clicked something there in the corner and alas - the 4th row is now correctly frozen. Too bad I dunno how it happened :shrug: Either way - not user friendly at all!

Edit2: Got it - when I unfreeze cells, then click exactly in the top-left corner in a place where the cursor changes to 4-direction arrow - that's the spot where a click will freeze the current top row (i.e. if you scroll down a bit and try, it will freeze there instead of top). Super tricky to do, should be easier for sure.

Edit3: Stupid me, I was using the "Freeze Panes" wrong - I need to put the cursor below the row I want to freeze, not on it :facepalm: Doing it properly works as expected! (In your case it's the 5th row.)

[rsnegirev]

Hi @HectorB-2020 @janxkoci

I can confirm, this is the bug 63527 in our internal issue tracker.

Thank you for the reports.

[Rita-Bubnova]

The issue is actual in DocumentServer.