Issue 123302 - Allow 'Data - Group and outline' also for disconnected cell ranges
Summary: Allow 'Data - Group and outline' also for disconnected cell ranges
Alias: None
Product: Calc
Classification: Application
Component: code (show other issues)
Version: 4.1.0-dev
Hardware: All All
: P3 Normal (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Depends on:
Reported: 2013-09-20 04:52 UTC by Rainer Bielefeld
Modified: 2013-12-14 18:15 UTC (History)
3 users (show)

See Also:
Latest Confirmation in: ---
Developer Difficulty: ---


Note You need to log in before you can comment on or make changes to this issue.
Description Rainer Bielefeld 2013-09-20 04:52:12 UTC
Current situation  with  "AOO 4.0.1 RC2  – German UI / German locale  [AOO401m5(Build:9714)  -  Rev. 1523756 2013-09-16 20:50:21]" on German German WIN7 Home Premium (64bit)", Common 4.0-dev User Profile:

It is possible to define Groups, for example for a columns range D:H. If you do not need to see information in those columns, you can simple switch off those columns using 'Group and outline' and make the columns visible again if you need to see those columns. 

That's a nice tool, but that does not cover all my needs. I have many spredsheets with many columns, where for several "standard business" I would like to hide several single columns, let's say D,F,H,J,L,N,O, to avoid excessive scrolling during my work. And for a different standard business I would like to hide E,G,J-L, P, also to avoid excessive horizontal scrolling.

So for me it would be great if definitions in 'Data - Group and outline' also would be possible for such disconnected column ranges with a proceeding:

1. <control+click> column headings D,F,H,J,L,N,O 
   > only columns  D,F,H,J,L,N,O become selected
2. 'Data -> Group and outline -> Group'
    (Currently impossible, greyed)
    > Croup created, Buttons '1' and '2' and 'Collapse Minus' appear above  
      column headings
    > from now on '-' will hide columns D,F,H,J,L,N,O and '+' will make
      columns visible again
Comment 1 Edwin Sharp 2013-09-20 12:35:30 UTC
Why don't use hyperlinks to avoid excessive scrolling?
Why not arrange document so columns to be hidden are contiguous?
Comment 2 Edwin Sharp 2013-12-14 17:27:11 UTC
No info from author.
Comment 3 Rainer Bielefeld 2013-12-14 18:15:19 UTC
@Edwin Sharp:
You misunderstand intention, you idea with links is not useful.

An example might be some kind of price list with 20 columns of information like Order number manufacturer, Order Number supplier, alternative supplier, list price, transfer factor, net. price, latest ordered, items on stock,  and so on and so on. This might need 4 screen widths. If you want to update the prices from a printed Katalog, it might be useful to see only columns A,E,G,M,O.
For  stocktaking you only want to see A,G,M,P
For some other work only B,D,F,N

Currently I use macros to hide the columns with unnecessary information for particular work, but using groups would be much more comfortable.