ML
    • Recent
    • Categories
    • Tags
    • Popular
    • Users
    • Groups
    • Register
    • Login

    Solved How can I turn off auto centering in LibreOffice Calc?

    IT Discussion
    libreoffice calc
    5
    32
    1.6k
    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.
    • IRJI
      IRJ @black3dynamite
      last edited by

      @black3dynamite said in How can I turn off auto centering in LibreOffice Calc?:

      @DustinB3403 said in How can I turn off auto centering in LibreOffice Calc?:

      I don't see a difference here.

      Also what is this button do, looks like you're using linux (and I'm on my work system atm).

      chrome_K4KFp8Co9n.png

      Must be an older version of LibreOffice. I believe @IRJ is using Ubuntu 18.04 LTS.

      A little older but not ancient..

      304c2ad5-12c7-4913-a727-7b036634ef8f-image.png

      DustinB3403D 1 Reply Last reply Reply Quote 0
      • DustinB3403D
        DustinB3403 @IRJ
        last edited by

        @IRJ soffice.bin_Lf9c3acS3b.png

        You're pretty far behind

        IRJI 1 Reply Last reply Reply Quote 0
        • IRJI
          IRJ @DustinB3403
          last edited by

          @DustinB3403 said in How can I turn off auto centering in LibreOffice Calc?:

          @IRJ soffice.bin_Lf9c3acS3b.png

          You're pretty far behind

          This this latest version in Ubuntu Software Center. Default repository

          f178e839-3ba0-49c0-b939-75dc1450657b-image.png

          DustinB3403D 1 Reply Last reply Reply Quote 0
          • DustinB3403D
            DustinB3403 @IRJ
            last edited by

            @IRJ Yeah because LTS means they are only going to offer you security patches (if that).

            IRJI 1 Reply Last reply Reply Quote 0
            • DustinB3403D
              DustinB3403
              last edited by

              Install the current version from the libreoffice website rather than the Ubuntu App Center.

              IRJI 1 Reply Last reply Reply Quote 0
              • IRJI
                IRJ @DustinB3403
                last edited by

                @DustinB3403 said in How can I turn off auto centering in LibreOffice Calc?:

                @IRJ Yeah because LTS means they are only going to offer you security patches (if that).

                Yep, but like I said this isn't an ancient version. This is not the type of change that they make in a security update.

                DustinB3403D 1 Reply Last reply Reply Quote 0
                • IRJI
                  IRJ @DustinB3403
                  last edited by

                  @DustinB3403 said in How can I turn off auto centering in LibreOffice Calc?:

                  Install the current version from the libreoffice website rather than the Ubuntu App Center.

                  I may try from this repository. I want to ensure I am able to updated automatically.

                  sudo add-apt-repository ppa:libreoffice/ppa

                  1 Reply Last reply Reply Quote 0
                  • DustinB3403D
                    DustinB3403 @IRJ
                    last edited by

                    @IRJ said in How can I turn off auto centering in LibreOffice Calc?:

                    @DustinB3403 said in How can I turn off auto centering in LibreOffice Calc?:

                    @IRJ Yeah because LTS means they are only going to offer you security patches (if that).

                    Yep, but like I said this isn't an ancient version. This is not the type of change that they make in a security update.

                    Which again, you didn't answer my question. You just showed an example of you using the Format Painter function instead of actually reading the question.

                    Centered looks like this

                    soffice.bin_pmUWZTyCUo.png

                    Not centered looks like this

                    soffice.bin_EUSbND44gN.png

                    IRJI 1 Reply Last reply Reply Quote 0
                    • IRJI
                      IRJ @DustinB3403
                      last edited by

                      @DustinB3403 said in How can I turn off auto centering in LibreOffice Calc?:

                      @IRJ said in How can I turn off auto centering in LibreOffice Calc?:

                      @DustinB3403 said in How can I turn off auto centering in LibreOffice Calc?:

                      @IRJ Yeah because LTS means they are only going to offer you security patches (if that).

                      Yep, but like I said this isn't an ancient version. This is not the type of change that they make in a security update.

                      Which again, you didn't answer my question. You just showed an example of you using the Format Painter function instead of actually reading the question.

                      Centered looks like this

                      soffice.bin_pmUWZTyCUo.png

                      Not centered looks like this

                      soffice.bin_EUSbND44gN.png

                      That isn't my issue. Expand the size of the columns to match my example.

                      DustinB3403D 1 Reply Last reply Reply Quote 0
                      • DustinB3403D
                        DustinB3403 @IRJ
                        last edited by

                        @IRJ said in How can I turn off auto centering in LibreOffice Calc?:

                        That isn't my issue. Expand the size of the columns to match my example.

                        No difference.

                        Centered:

                        soffice.bin_GTju8IMWNI.png

                        Without centering

                        soffice.bin_q6X3ZStqUF.png

                        IRJI 1 Reply Last reply Reply Quote 0
                        • IRJI
                          IRJ @DustinB3403
                          last edited by

                          @DustinB3403 said in How can I turn off auto centering in LibreOffice Calc?:

                          @IRJ said in How can I turn off auto centering in LibreOffice Calc?:

                          That isn't my issue. Expand the size of the columns to match my example.

                          No difference.

                          Centered:

                          soffice.bin_GTju8IMWNI.png

                          Without centering

                          soffice.bin_q6X3ZStqUF.png

                          Again not my issue

                          1 Reply Last reply Reply Quote 0
                          • DustinB3403D
                            DustinB3403
                            last edited by

                            Centered centers on the cell, so what the hell are you asking?

                            1 Reply Last reply Reply Quote 0
                            • IRJI
                              IRJ
                              last edited by

                              Before I click to Column D

                              8d69d573-d50d-4bca-b435-1d11626f2f39-image.png

                              When I click on column D it moves the view to the center of column D

                              2e7c7228-ca1f-4ba4-824e-8ee80dfed090-image.png

                              DustinB3403D 1 Reply Last reply Reply Quote 0
                              • DustinB3403D
                                DustinB3403
                                last edited by

                                Are you sure you're using the correct verbiage to describe the issue? I don't think you are because what I've just listed in detail is centering.

                                1 Reply Last reply Reply Quote 0
                                • DustinB3403D
                                  DustinB3403 @IRJ
                                  last edited by

                                  @IRJ said in How can I turn off auto centering in LibreOffice Calc?:

                                  Before I click to Column D

                                  8d69d573-d50d-4bca-b435-1d11626f2f39-image.png

                                  When I click on column D it moves the view to the center of column D

                                  2e7c7228-ca1f-4ba4-824e-8ee80dfed090-image.png

                                  Where in the OP does it say the view changes?! FFS

                                  IRJI 1 Reply Last reply Reply Quote 0
                                  • B
                                    bnrstnr
                                    last edited by

                                    lol, Excel does this same exact thing. In the first pic you can see 3 columns left of column D. When he starts to edit Column D, it automatically shifts the window so you can only see 2 columns to the left. It's super annoying.

                                    1 Reply Last reply Reply Quote 2
                                    • IRJI
                                      IRJ @DustinB3403
                                      last edited by

                                      @DustinB3403 said in How can I turn off auto centering in LibreOffice Calc?:

                                      @IRJ said in How can I turn off auto centering in LibreOffice Calc?:

                                      Before I click to Column D

                                      8d69d573-d50d-4bca-b435-1d11626f2f39-image.png

                                      When I click on column D it moves the view to the center of column D

                                      2e7c7228-ca1f-4ba4-824e-8ee80dfed090-image.png

                                      Where in the OP does it say the view changes?! FFS

                                      Well I did give an example WHERE my text isn't centered. So maybe that was a clue 😉 and I never said Font or field data is centering. I never specified anything, but gave an example

                                      DustinB3403D 1 Reply Last reply Reply Quote 0
                                      • DustinB3403D
                                        DustinB3403
                                        last edited by

                                        Do you have Column A locked so when you scroll everything else moves and A is hidden? Or is that filter on A only to find numbers etc?

                                        IRJI B 2 Replies Last reply Reply Quote 0
                                        • IRJI
                                          IRJ @DustinB3403
                                          last edited by

                                          @DustinB3403 said in How can I turn off auto centering in LibreOffice Calc?:

                                          Do you have Column A locked so when you scroll everything else moves and A is hidden? Or is that filter on A only to find numbers etc?

                                          Column A is just filtering

                                          1 Reply Last reply Reply Quote 0
                                          • DustinB3403D
                                            DustinB3403 @IRJ
                                            last edited by

                                            @IRJ said in How can I turn off auto centering in LibreOffice Calc?:

                                            I never specified anything, but gave an example

                                            A super shitty example with a confusing explanation.

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