Date: prev next · Thread: first prev next last
2014 Archives by date, by thread · List index

Hi :)
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 <> 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, 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

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:
Posting guidelines + more:
List archive:
All messages sent to this list will be publicly archived and cannot be

To unsubscribe e-mail to:
Posting guidelines + more:
List archive:
All messages sent to this list will be publicly archived and cannot be deleted


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.