Apache OpenOffice (AOO) Bugzilla – Issue 18582
Insufficient Online Help about Hidden Columns: (how not to lose column "A")
Last modified: 2013-08-07 15:15:02 UTC
The online help is quite poor about showing/hiding rows & columns. It says: ***************************************************************** Hide Use this command to hide selected rows, columns or individual sheets. To access this function... Choose Format - Row - Hide Choose Format - Column - Hide Choose Format - Sheet - Hide Select the rows and columns that you want to hide, and then choose Format - Row - Hide or Format - Column - Hide. You can hide a spreadsheet by selecting the sheet tab and then choosing Format - Sheet - Hide. Hidden sheets are not printed unless they occur within a print range. A break in the row or column header indicates whether the row or column is hidden. To display hidden rows, columns or spreadsheets, use the Format - Row/Column - Show or Format - Sheet - Show command. **************************************************************************** Ok. What if you hide the "A" column ? How can you recover it later ? There is no "lefter" column which could be selected together any "righter" column. But there is a solution indeed. It's the "corner", the empty cell, flagged with a * below: * B C D ... 1 2 3 First note that a double-click on the "corner" selects the whole sheet (just like pressing Ctrl-A). Now here come the trick: 1) select the "B" column (click on the B letter on that column's header); hold the left mouse button down. 2) drag the mouse pointer to the "corner". 3) release the button and select the menu "Format", submenu "Column", subsubmenu "Show". 4) suddenly, the "A" column reappears. Of course, the same procedure works with rows instead of columns. Below in french. Voici une autre lacune dans la documentation en ligne. Il s'agit de cacher des lignes ou colonnes dans le tableur (Calc). L'aide en ligne dit ceci: ********************************************************************************* [analogous] ********************************************************************************* Bien. Et si on cache la colonne A ? Comment faire pour la retrouver après ? En effet, on ne peut pas aisément sélectionner de colonne + à gauche ! Solution: le "coin". C'est la case vide nommée * dans le schéma ci-dessous. * B C D ... 1 2 3 Si on double-clique sur le "coin" la feuille de calcul entière est sélectionnée (comme Ctrl-A). Voici la manoeuvre pour sélectionner les colonnes A et B quand A est cachée: 1) sélectionner la colonne B (cliquer dans son en-tête et maintenir le bouton enfoncé). 2) tirer la souris vers le "coin" 3) lâcher le bouton et aller sélectionner le menu "Format", "Colonne", "Montrer". 4) Et hop! la colonne A réapparait. Bien entendu, le mêmes manipulations fonctionnent sur les lignes.
Hi Uwe, what's your thoughts about it ? Would you incorporate it into the help ? If so, just do it. Frank
forgot the target
Just submitted to Sophie Gautier as rewriting to the 13th FAQ entry for Calc (http://fr.openoffice.org/FAQ/calc_fr/c13fr.html).
Created attachment 8745 [details] Unhiding - step 1
Created attachment 8746 [details] Unhiding - step 2
Created attachment 8747 [details] Unhiding - step 3
Created attachment 8748 [details] Unhiding - final
I enclose 4 very small GIF images. They show the process required to unveil the hidden "A" column. You can use these as a basis for the online help. A note: images "coin2.gif" & "coin3.gif" are NOT identical. The third image correspond to the leftmost mouse move, and (secretly) selects the "A" column.
Thank you for the comments and images. The guide will be enclosed in the next Help.
.
edited text\scalc\01\05030300.xml
UFI: QA, pls verify in CWS helpcontentbeta and close
Please note that the mouse pointer is missing on the enclosed GIFs. The Online Help would be quite clearer with the mouse pointer added. I haven't time to redo the images at present.
Set to correct state 'resolved fixed'.
kla: verified in cws helpcontentbeta
ok in master m64 ->closed