Apache OpenOffice (AOO) Bugzilla – Issue 106169
Calc "Column Selector" to Hide/Show(Unhide) Columns/Rows (Like Layers)
Last modified: 2014-01-13 17:25:49 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! So: 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" - http://www.oooforum.org/forum/viewtopic.phtml?t=68974 --- 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 Canada
...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 percentage.) -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. Cheers! Danny
@scriptures4life 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?
IMHO useful feature.