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

On 08/12/2014 01:22 AM, Tom Davies wrote:
> Hi :)
> Also the 4.1.0 was VERY early in that branch's cycle.  There have been
> numerous updates to fix lots of bugs and make it more stable.  So instead
> of the 4.1.0 it would be better to try the 4.1.6.
>
> Similarly with the 4.0.1.  That 3rd digit shows it had only 1 update (to
> fix bugs) since the beginning of it's branch.  Better to try the 4.0.6 !

I had him reinstall OpenOffice 4.0.1 because that was the previous
version he used before I upgraded it to 4.1.0.

Thanks!

Peace..

"The Other" Tom

> On 12 August 2014 09:16, Tom Davies <tomcecf@gmail.com> 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.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