Navigation

    • Login
    • Search
    • Categories
    • Recent
    • Tags
    • Users
    • Groups
    • Rules
    • Help

    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

    Lounge
    4
    11
    1454
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • 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?

      Reply Quote 0
        1 Reply Last reply
      • 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.

        Reply Quote 0
          1 Reply Last reply
        • joshl
          joshl last edited by

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

          Reply Quote 0
            1 Reply Last reply
          • Deleted User
            Deleted User last edited by

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

            Reply Quote 0
              1 Reply Last reply
            • joshl
              joshl last edited by

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

              Reply Quote 0
                1 Reply Last reply
              • 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.

                Reply Quote 0
                  1 Reply Last reply
                • joshl
                  joshl last edited by

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

                  Reply Quote 0
                    1 Reply Last reply
                  • 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).

                    Reply Quote 0
                      1 Reply Last reply
                    • Deleted User
                      Deleted User last edited by

                      It's Apache.

                      Reply Quote 0
                        1 Reply Last reply
                      • 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?:)

                        Reply Quote 0
                          1 Reply Last reply
                        • 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...

                          Reply Quote 0
                            1 Reply Last reply
                          • First post
                            Last post

                          Computer browsers

                          • Opera for Windows
                          • Opera for Mac
                          • Opera for Linux
                          • Opera beta version
                          • Opera USB

                          Mobile browsers

                          • Opera for Android
                          • Opera Mini
                          • Opera Touch
                          • Opera for basic phones

                          • Add-ons
                          • Opera account
                          • Wallpapers
                          • Opera Ads

                          • Help & support
                          • Opera blogs
                          • Opera forums
                          • Dev.Opera

                          • Security
                          • Privacy
                          • Cookies Policy
                          • EULA
                          • Terms of Service

                          • About Opera
                          • Press info
                          • Jobs
                          • Investors
                          • Become a partner
                          • Contact us

                          Follow Opera

                          • Opera - Facebook
                          • Opera - Twitter
                          • Opera - YouTube
                          • Opera - LinkedIn
                          • Opera - Instagram

                          © Opera Software 1995-