Bug 100730 - Not possibble to navigate freezed cells if freezed cells is not in visible window.
Summary: Not possibble to navigate freezed cells if freezed cells is not in visible wi...
Status: RESOLVED NOTABUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
5.3.0.0.alpha0+
Hardware: x86-64 (AMD64) Linux (All)
: low minor
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2016-07-01 14:21 UTC by Gülşah Köse
Modified: 2017-03-20 01:23 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:


Attachments
an example freezing case (16.64 KB, image/png)
2016-07-01 14:21 UTC, Gülşah Köse
Details
My Image (238.02 KB, image/jpeg)
2016-07-02 05:44 UTC, Joel Madero
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Gülşah Köse 2016-07-01 14:21:03 UTC
Created attachment 126025 [details]
an example freezing case

1- Open a sheet
2- Scroll page down till 10th row.
3- Click Freeze rows and columns button while cursor at (11,B)
4- Try to write something (9,B)

Expected behavior: A scroll bar should be there to navigate freezed cells.
Comment 1 Joel Madero 2016-07-02 05:41:13 UTC
Hi Gülşah Köse

I'm tossing this into NEEDINFO because I'm not quite sure what you're getting at.

From your image it looks like rows are hidden? I'll attach an image of what mine looks like when I go to 11,B, freeze, then I'm able to easily write things into 9,B...

Can you please explain a bit more (maybe attach a sheet where you've frozen/hidden things).

After you explain a bit more and perhaps at an additional attachment, mark as UNCONFIRMED. Thanks!
Comment 2 Joel Madero 2016-07-02 05:43:59 UTC
This is in no way a MAJOR problem - moving to MINOR
Comment 3 Joel Madero 2016-07-02 05:44:28 UTC
Created attachment 126029 [details]
My Image
Comment 4 Gülşah Köse 2016-07-12 13:30:51 UTC
(In reply to Joel Madero from comment #1)
 
> From your image it looks like rows are hidden? I'll attach an image of what
> mine looks like when I go to 11,B, freeze, then I'm able to easily write
> things into 9,B...

To see this bug you should scroll sheet till 10th row like at my attachment.
Comment 5 GerardF 2016-07-12 13:45:41 UTC
OK, I don't understand your report at 1st time but now it's fine.

You need to scroll down before freezing rows and yes, rows that are hidden before "freeze" are no more visible.

If you want a scroll bar, may be it is better to use "Split window" instead of "Freeze rows/columns"... ?
Comment 6 Kevin Suo 2017-03-20 01:23:50 UTC
This is not a bug at all.
If you need scroll bar- then use split window instead. Freeze column and rows will freeze columns to the left and rows to the top of current cell.
All other office suites behaves the same way.