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

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.barker@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+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


-- 
/When we dance, you have a way with me,
Stay with me... Sway with me.../

-- 
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