Perhaps you can change the text colour to be the same as the background colour - effectively hiding it.
Then protect the sheet/cells as per this in the help http://help.libreoffice.org/Calc/Protecting_Cells_from_Changes On Tuesday 12 Aug 2014 09:16:15 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. > > > To hide individual cells it might be easier to grab a graphic, drag it onto > the spreadsheet, perhaps right-click again to "Anchor to" - "page" and > resize to fit the cell(s). > > It's also probably possible to put a frame over the cells and then have > writing or number in the frame although it might be difficult to then reach > those numbers in calculations in the rest of the spreadsheet because they > wont be recognised as being in a cell. > > Regards from > 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 > > > > > > -- 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
