On 08/12/2014 01:16 AM, Tom Davies wrote: > Hi :) > +1 > Also ... > Errr, how are the cells being hidden?!?? > > Of course it is possible to hide an entire row or column by clicking on the > row/column header (1, 2, 3 etc or A, B, C etc) and then right-click to hide > the entire row/column.
This is what my dad does to hide the rows in question. :) Peace... "The Other" Tom :) > On 12 August 2014 04:33, Brian Barker <b.m.bar...@btinternet.com> wrote: > >> At 19:34 11/08/2014 -0700, Tom Williams wrote: >> >>> My dad is a long time OpenOffice user and today he called me about a >>> problem he's having with one of his spreadsheets. Apparently, he hides rows >>> to reduce the amount of information he sees when he's looking at the >>> spreadsheet. Today, he needed to change a cell in one of the hidden rows. >>> When he tried to make a change, he showed the row but wasn't able to change >>> a cell because something prevented him from making changes. When he showed >>> the hidden row, he saw an icon for an anchor and green squares along the >>> perimeter of the selection of the now shown rows. >>> >>> He sent the spreadsheet to me and when I open it in LibreOffice Calc, >>> 4.2.4.2 on Linux, I see the same behavior he describes. From what I can >>> tell, it looks like Calc converts the hidden row into an image or graphic >>> of some kind such that when he tries to change it, he can't because those >>> rows are now part of an image/graphic or "object" that's embedded in the >>> file. >>> >> I doubt very much that Calc has converted values to a picture of those >> values. But yes: you very probably do have a graphic or other object in or >> covering the relevant cells. If you need to modify a cell which appears >> inaccessible because of an overlaid graphic, there are a number of ways to >> do this. >> >> o You can type the cell reference into the Name Box and then edit the >> contents in the Input Line. >> >> o You can (temporarily?) suppress display of the graphic at Tools | >> Options... | LibreOffice Calc | View | Objects | Objects/Graphics. >> >> o Most easily, you can send the graphic to the background using >> right-click | Arrange > | To Background. If you do this, you may want to >> bring it back to the front after you have completed the edit, but you will >> not be able to select it by simply clicking on it precisely because it is >> now in the background. One convenient way to select the graphic is to open >> the Navigator (go to View | Navigator or press F5) and double-click the >> name of the graphic. You can then use right-click | Arrange > | To >> Foreground to reset the position. >> >> Of course, if you cannot see the graphic and are not missing anything, it >> may be that you don't want it and can merely delete it. >> >> I trust this helps. >> >> Brian Barker >> >> >> >> -- >> To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org >> Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to- >> unsubscribe/ >> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette >> List archive: http://listarchives.libreoffice.org/global/users/ >> All messages sent to this list will be publicly archived and cannot be >> deleted >> >> -- /When we dance, you have a way with me, Stay with me... Sway with me.../ -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted