Do more on the web, with a fast and secure browser!

Download Opera browser with:

  • built-in ad blocker
  • battery saver
  • free VPN
Download Opera

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

Locked