Office documents Applications

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

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

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

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

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

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

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

  • 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).

  • It's Apache.

  • 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?:)

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

Log in to reply
 

Looks like your connection to Opera forums was lost, please wait while we try to reconnect.