|
Apache OpenOffice (AOO) Bugzilla – Full Text Issue Listing |
| Summary: | Allow 'Data - Group and outline' also for disconnected cell ranges | ||
|---|---|---|---|
| Product: | Calc | Reporter: | Rainer Bielefeld <rainerbielefeld_ooo_qa> |
| Component: | code | Assignee: | AOO issues mailing list <issues> |
| Status: | REOPENED --- | QA Contact: | |
| Severity: | Normal | ||
| Priority: | P3 | CC: | elish, issues, rainerbielefeld_ooo_qa |
| Version: | 4.1.0-dev | ||
| Target Milestone: | --- | ||
| Hardware: | All | ||
| OS: | All | ||
| Issue Type: | ENHANCEMENT | Latest Confirmation in: | --- |
| Developer Difficulty: | --- | ||
Why don't use hyperlinks to avoid excessive scrolling? Why not arrange document so columns to be hidden are contiguous? No info from author. @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. |
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