Solved How can I turn off auto centering in LibreOffice Calc?
-
Install the current version from the libreoffice website rather than the Ubuntu App Center.
-
@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.
-
@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 -
@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
Not centered looks like this
-
@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
Not centered looks like this
That isn't my issue. Expand the size of the columns to match my example.
-
@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:
Without centering
-
@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:
Without centering
Again not my issue
-
Centered centers on the cell, so what the hell are you asking?
-
Before I click to Column D
When I click on column D it moves the view to the center of column D
-
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.
-
@IRJ said in How can I turn off auto centering in LibreOffice Calc?:
Before I click to Column D
When I click on column D it moves the view to the center of column D
Where in the OP does it say the view changes?! FFS
-
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.
-
@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
When I click on column D it moves the view to the center of column D
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 -
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?
-
@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
-
@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.
-
@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.
-
@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.
-
@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
-
@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.
