Hi :) +1 I think it's more likely that the user has found ingenious and unexpected ways to hide cells, such deliberately using images. Regards from Tom :)
On 12 August 2014 14:24, Alex McMurchy <mcmurchy1917-libreoff...@yahoo.co.uk > wrote: > 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 > > -- 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