Issue 106169 - Calc "Column Selector" to Hide/Show(Unhide) Columns/Rows (Like Layers)
Summary: Calc "Column Selector" to Hide/Show(Unhide) Columns/Rows (Like Layers)
Alias: None
Product: Calc
Classification: Application
Component: viewing (show other issues)
Version: 3.3.0 or older (OOo)
Hardware: All All
: P3 Trivial with 2 votes (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Keywords: needmoreinfo
Depends on:
Reported: 2009-10-22 06:11 UTC by scriptures4life
Modified: 2014-01-13 17:25 UTC (History)
3 users (show)

See Also:
Issue Type: FEATURE
Latest Confirmation in: ---
Developer Difficulty: ---


Note You need to log in before you can comment on or make changes to this issue.
Description scriptures4life 2009-10-22 06:11:12 UTC
Hi OOo Team!

I really appreciate all the work that has been done to make this software so awesome!

I'm using NeoOffice 3 and I'd like to suggest the following new feature:

I'd like a Dialogue springing from the View menu that would allow users to hide and/or show columns 
via tickboxes or by entering the column's/row's name into a box.  I'd like to compare the idea to Layers 
in GIMP.  The idea would be that users could save predefined sets of hidden/shown columns/rows, and 
then go in to the dialogue and select which set to view.  With such a tool, vast worksheets could be 
visually trimmed for fast data entry, and then viewed in their entirety when necessary.  Currently, if a 
user wants to show columns, they have to know, in advance, which column they want to unhide, and 
even then, if the specific column is hidden in with many others, it can only be shown by following the 
procedure by Zeddock:

"To show a column or row which is sandwiched between other hidden columns/rows: 
In the upper left corner is the Name Box, just to the left of the formula box. 
This will show your current cell or collection of cells, but you can type into this box a cell you want to 
go to! 
If I have columns B,C,D,E,F,G,H all hidden but decide I need column E shown, I can type E1 into the 
name box and hit enter. (Even though I cannot see it, I am "in" that cell.) 
Now go to Format/Column/Show. 
Zeddock" -

If the "column browser" could tell the user the column labels (i.e., in the case of a column browser, the 
labels in Row 1 ) then the user could just "tick" what columns they needed and they'd be done in a jiffy!  
It would be useful to have a "limit column browser to filled rows" option that would be selected by 
default so that empty  columns would not become endless checkboxes or rows to be selected from in 
the dialogue.

I'd be happy to explain further, and I can provide a worksheet I'm working on that would benefit from 
such a tool (I'm importing inventory into MYOB Accountedge with files in Tab-delimited CSV format 
produced in NeoOffice Calc.)

Thanks for hearing my request!!!
Danny Vanderbyl
Comment 1 scriptures4life 2009-10-22 06:23:13 UTC
...I just thought of one more thing that would be awesome in that tool.  If we could save the viewing zoom 
factor (percentage) with each "set" of columns, that would also be sweet!   Then, as soon as the column set 
was selected, the sheet could immediately be back at the "optimal" zoom (or a user-chosen zoom 
-There could be a tickbox by each column-set's zoom percentage box that would cause Calc to 
automatically zoom "optimal" for the filled columns in the first row once the column-set was opened.

Comment 2 Rainer Bielefeld 2013-06-09 06:26:59 UTC
I am not sure whether I understand all details of the request. At least a part of your request seems to be that you need "something" what allows to hide a predefined set of columns of a sheet? Example for what I beleive:
Let's imagine a Table with meterologic data for 8 Places, Fist columne measuring time, Columns B-I Temperatures 1-8, J-Q Humidities 1-8, R-Y interceptions 1-8, Z-AH Clouds, (... and may be some other measuring data, each always continuous for 8 places in 8 successing rows.
If I no want to see only all Data for Place 1, It would be useful to have a possibility to hide all Columns with Data related to other places, os that only columns A, B, J, R, Z (...) remain visible, and that with 1-2 mouse clicks after column definition has been done. And the same for the other places.
Currently I use macros for such a function, but that is very inflexible and and wxpensive.

IS that at least a part of that what you need?
Comment 3 Edwin Sharp 2014-01-13 17:25:49 UTC
IMHO useful feature.