Re: [libreoffice-users] Question about Calc and hiding rows

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+unsubscribe@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