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

    How can I turn off auto centering in LibreOffice Calc?

    Scheduled Pinned Locked Moved Solved IT Discussion
    libreofficecalc
    32 Posts 5 Posters 1.9k Views
    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.
    • DustinB3403D
      DustinB3403
      last edited by

      Is this just in 1 document or every brand new document? I don't have this problem with LibreOffice Calc, there is no formatting selected at all.

      Do you have the paintbrush selected?

      soffice.bin_asf2GTei3K.png

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

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

        Is this just in 1 document or every brand new document? I don't have this problem with LibreOffice Calc, there is no formatting selected at all.

        Do you have the paintbrush selected?

        soffice.bin_asf2GTei3K.png

        Before click

        a38dce60-24dc-45e5-bbbb-ef5a77b3b007-image.png

        After click

        da23aaba-e0c2-48b4-a97c-1dc1114d9431-image.png

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

          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

          black3dynamiteB IRJI 2 Replies Last reply Reply Quote 0
          • black3dynamiteB
            black3dynamite @DustinB3403
            last edited by

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

            DustinB3403D IRJI 2 Replies Last reply Reply Quote 0
            • DustinB3403D
              DustinB3403 @black3dynamite
              last edited by

              @black3dynamite In any case, not installing Ubuntu Desktop 18.04 LTS to troubleshoot this. . . 😉

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

                @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

                It's a highlighter

                1 Reply Last reply Reply Quote 0
                • 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
                                            • 1
                                            • 2
                                            • 1 / 2
                                            • First post
                                              Last post