Bug 74951 - UI: Make it possible through a setting to select hidden cells using the keyboard
Summary: UI: Make it possible through a setting to select hidden cells using the keyboard
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
unspecified
Hardware: All All
: medium enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Cell-Selection
  Show dependency treegraph
 
Reported: 2014-02-13 21:02 UTC by Chris McKenna
Modified: 2017-07-17 19:28 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Chris McKenna 2014-02-13 21:02:29 UTC
Until version 4.2.0.4 it was possible to select hidden cells using the keyboard in exactly the same way as it is possible to select visible cells. It is now impossible to select anything other than all hidden cells between visible cells. 

Per bug 74658 this change is apparently intentional (although I do not understand how this is at all beneficial), so there needs to be an option to enable to old behaviour to re-enable the workflows that depend on it.

Steps to reproduce:
1. Create a spreadsheet with three columns A, B and C
2. Hide column B
3. Click in cell C1 and press shift+left to select columns

Current behaviour:
Selection becomes A1:C1

Previous and desired behaviour:
Selection becomes B1:C1
Comment 1 Cor Nouws 2014-02-23 23:38:19 UTC
Hi Chris,

(In reply to comment #0)

> Per bug 74658 this change is apparently intentional (although I do not
> understand how this is at all beneficial), so there needs to be an option to
> enable to old behaviour to re-enable the workflows that depend on it.

The workflow that one wants to select hidden cells, really seems the exception to me. I do applaud the fix mentioned in 74658 :)
Imagine you have many rows hidden and want to make a manual selection .. :(

> Previous and desired behaviour:
> Selection becomes B1:C1

I do not agree that it is desired, sorry :)
Cor
Comment 2 Chris McKenna 2014-02-24 10:06:41 UTC
(In reply to comment #1)
> 
> The workflow that one wants to select hidden cells, really seems the
> exception to me. I do applaud the fix mentioned in 74658 :)

Maybe it is less common, but it does exist and I see no reason to make it impossible. I'm asking here for an option to choose the previous or new behaviours.

> Imagine you have many rows hidden and want to make a manual selection .. :(
Then either you use the new behaviour option, or you use ctrl+shift+arrow like you did in all previous versions.

> 
> > Previous and desired behaviour:
> > Selection becomes B1:C1
> 
> I do not agree that it is desired, sorry :)

What you mean is that you don't desire it. This does not stop me desiring it or invalidate my desire for it.
Comment 3 Cor Nouws 2014-02-24 13:00:53 UTC
(In reply to comment #2)

> Then either you use the new behaviour option, or you use ctrl+shift+arrow
> like you did in all previous versions.

Well, not if the selection does not have to go to the end of a range ...

> What you mean is that you don't desire it. This does not stop me desiring it
> or invalidate my desire for it.

Of course not :)
As an option / setting, I cannot object of course.

Adjust accordingly & set to new.

thanks for the issue,
Cor