No, I can't believe that Calc is magically converting cells contents to images.
Is the cell subject to a formula somewhere else on the sheet? What happens when you try and delete the object that is symbolised by the anchor and green squares along the perimeter? On Tuesday 12 Aug 2014 13:05:48 Brian Barker wrote: > At 09:16 12/08/2014 +0100, Tom Davies 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. > > > >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. > > Er, the questioner well knows how to hide cells (in the normal way); > his problem is not being able to edit them when he shows them again. > Or do you believe Calc is magically converting cell contents to images? > > 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
