To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=106169 Issue #|106169 Summary|Calc "Column Selector" to Hide/Show(Unhide) Columns/Ro |ws (Like Layers) Component|Spreadsheet Version|current Platform|Macintosh URL| OS/Version|Mac OS X Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|FEATURE Priority|P3 Subcomponent|viewing Assigned to|spreadsheet Reported by|scriptures4life
------- Additional comments from [email protected] Thu Oct 22 05:11:12 +0000 2009 ------- 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 --------------------------------------------------------------------- Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
