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

[black3dynamite]

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

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

[DustinB3403]

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

[IRJ]

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

It's a highlighter

[IRJ]

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

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

A little older but not ancient..

[DustinB3403]

@IRJ

You're pretty far behind

[IRJ]

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

@IRJ

You're pretty far behind

This this latest version in Ubuntu Software Center. Default repository

[DustinB3403]

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

[DustinB3403]

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

[IRJ]

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

[IRJ]

@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

[DustinB3403]

@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

[IRJ]

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

[DustinB3403]

@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

[IRJ]

@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

[DustinB3403]

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

[IRJ]

Before I click to Column D

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

[DustinB3403]

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.

[DustinB3403]

@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

[bnrstnr]

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.

[IRJ]

@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