https://bugs.documentfoundation.org/show_bug.cgi?id=90998
Bug ID: 90998
Summary: replace Window/Freeze mode with something more generic
Product: LibreOffice
Version: unspecified
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: enhancement
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Hey.
There is the helpful Window/Freeze mode in Calc, which freezes/unfreezes parts
of the displayed columns/rows based on which cell was selected when the window
was frozen.
When one moves then around, those rows above and those columns left from the
cell that was selected during freezing are displayed in a "header" like fashion
(on top and left of the window).
This is great and helpful, but also kinda limited, namely to only consecutive
cells/rows on the left and top + starting from column A and row 1.
I propose a much more powerful schema (which allows everything from the current
one plus more):
Let the user specify (not necessarily consecutive or starting at 1/A) single
and ranges of rows and columns which are to be "frozen".
Depending on which part of the screen is visible, the frozen rows would be
displayed either:
- at their "native" position (that is correctly ordered between their
neighbours)
- at the very right, left, top or bottom,.... each time next to their
"following" frozen row respectively column
Some examples:
Imagine we'd have the following sheet:
* * * *
A B C D E F G H
1
*2
*3
4
5
*6
7
*8
(rows/columns marked with "*" are frozen)
But our screen fit's only 6 columns/rows.
a) I've I'd navigate to the very left/top I'd see then the following:
* * * *
A B C D E H
1
*2
*3
4
*6
*8
=> at the left/top, I see the frozen and normal rows/cells, but the normal
rows/cells the the very left/bottom disappear between the frozen ones there.
b) If I stay at the top but move to the right, I'd get e.g.:
* * * *
A C D F G H
1
*2
*3
4
*6
*8
c) At the bottom/right it would be:
* * * *
A C D F G H
*2
*3
5
*6
7
*8
=> as you can see, the frozen ones never disappear, just the normal ones are
hidden as necessary
d) Since the column/row space is positively infinite,... what happens if I move
outside (i.e. even more down and/or more right) the already "used"
rows/columns?
Well that would then look eg. like this:
* * * *
A C D H AB BA
*2
*3
*6
*8
42
43
I think, for convenience, all places where columns/rows are "hidden" should be
indicated somehow.
Actually how, is probably a matter for the UI experts.
The current way of displaying a "line" is IMHO not visible enough.
One possible idea could be to colourise the column/row label fields whenever
there are hidden ones in between, e.g. for columns this would normally look
like:
*************************
* A * B * C * D * E * F *
*************************
And the background of these would be grey (in the standard colour mode).
But when we have some of the columns hidden because of frozen ones, e.g.
analogously to example (a) above:
*************************
* A * B * C * D * E * H *
*************************
then all fields would be grey, except the one from E and H,... which get e.g. a
blinking red plus the PC speaker starts beeping (yes I'm kidding) background,
in order to indicate:
Something is not shown between columns E and H.
Maybe one would even paint only half of the label in the notification colour
for scenarios like this:
*************************
* A * C * D * F * G * I *
*************************
Here, we'd be somewhere very right... and columns B, E and H would have not
been frozen, which is why we don't see them anymore
If we paint the full labels with the notification colour, then every label
would have the notification colour, and it would be hard to see, where actually
something is missing,... if we only paint the right vertical halves (and in
case of rows: horizontal halves) it becomes clear again, e.g.
*************************
* A#*#C * D#*#F * G#*#I *
*************************
with "#" marking the colourised half.
Best wishes,
Chris.
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
