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 2.0k 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 @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
                          • DustinB3403D
                            DustinB3403
                            last edited by

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

                            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.

                            This doesn't occur on my screen until I get to column V.

                            My recommendation Zoom out, you'll see more content at once.

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

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

                              It's just the behavior of a normal workbook. Nothing hidden or locked (from my experience anyway). If the column you want to edit extends off the right edge of the screen it moves the window to try to make the whole column visible.

                              Not that it's relevant really, but I don't see a way to turn it off in Excel either.

                              DashrenderD 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?:

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

                                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.

                                This doesn't occur on my screen until I get to column V.

                                My recommendation Zoom out, you'll see more content at once.

                                That is what I ended up doing. It is still readable

                                1 Reply Last reply Reply Quote 0
                                • DashrenderD
                                  Dashrender @bnrstnr
                                  last edited by

                                  @bnrstnr 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?:

                                  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?

                                  It's just the behavior of a normal workbook. Nothing hidden or locked (from my experience anyway). If the column you want to edit extends off the right edge of the screen it moves the window to try to make the whole column visible.

                                  Not that it's relevant really, but I don't see a way to turn it off in Excel either.

                                  Yeah, I've seen this behavior in Excel before - definitely annoying... I get what they are doing - showing all the data for that column... but still.

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

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

                                    @bnrstnr 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?:

                                    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?

                                    It's just the behavior of a normal workbook. Nothing hidden or locked (from my experience anyway). If the column you want to edit extends off the right edge of the screen it moves the window to try to make the whole column visible.

                                    Not that it's relevant really, but I don't see a way to turn it off in Excel either.

                                    Yeah, I've seen this behavior in Excel before - definitely annoying... I get what they are doing - showing all the data for that column... but still.

                                    I understand it, too. It would be nice if it was something you could toggle though

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