Office documents Applications

[joshl]

joshl last edited by

Well, on my netbook I only have OpenOffice for now.
And I've got a problem.

I created a new sheet/list in my electricity bill table doc, and decided to organise it a bit differently. I realised at a certain moment that I forgot something, and added a couple of columns - they take part in the formulas I use there; it looked ugly etc., I hid them.
Guess what?
Now I can't find any possible way to show or unhide them. There is an option "show" somewhere, but it does nothing - as long as I can't "scroll to" and/or highlight the hidden columns.
I seem to remember I saw such an option to show hidden elements for editing when I used Microsoft Office at work, in yonder days. I thought it must be only natural OpenOffice would do the same. Does it?

[blackbird71]

blackbird71 last edited by

I don't use Open Office, but in both MS Office and Libre Office spreadsheet programs, if you hide a row or column, you have to highlight the rows or columns on both sides of the hidden row or column and then access the menu or button function for unhide/show (naming depends on the software). For example, with column C hidden, you would highlight column B across to column D, then select unhide/show. If you don't do the highlighting, nothing happens. If the column/row that was hidden is the left-most or top (A or 1 respectively), you have to highlight from the visible adjacent column or row into the index column or row before making your unhide/show command.

[joshl]

joshl last edited by

Thanks, Black.
As always now, you were stealth this time again... ;_;

[Deleted User]

Deleted User last edited by

Getting Open Office to behave properly at all has been a bit of a trick.

[joshl]

joshl last edited by

Which version do you have now?
Is it already Apache perhaps? I saw some feedback... :rolleyes:

[sgunhouse]

sgunhouse Moderator Volunteer last edited by

OpenOffice has been under the Apache project for some time now. Of course, in most regards it is the same as LibreOffice.

[joshl]

joshl last edited by

I don't know, Steve. People in that feedback page compared those, and not in favour of the former.

[sgunhouse]

sgunhouse Moderator Volunteer last edited by

Some of them are FOSS-purists, if their comments are about the license then I don't care. Apache OpenOffice is free and open-source even if it isn't under the GPL (it's under the Apache license).

[Deleted User]

Deleted User last edited by

It's Apache.

[joshl]

joshl last edited by

Here's from forum.openoffice.org:

Select all the columns (click in the upper left corner of the cell grid), then right-click on any column header and choose Show.

What do you think?

[joshl]

joshl last edited by

Some of them are FOSS-purists, if their comments are about the license then I don't care. Apache OpenOffice is free and open-source even if it isn't under the GPL (it's under the Apache license).

IIRC, it was about certain glitches...