Ask Your Question

Change default text alignment settings (calc) [closed]

asked 2017-04-21 00:49:25 +0200

appreciatethehelp gravatar image

updated 2021-05-01 20:14:10 +0200

Alex Kemp gravatar image

As per the above question. I want my text to come out "centered" in the cell from default.


edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by appreciatethehelp
close date 2017-04-21 12:28:57.226772

1 Answer

Sort by » oldest newest most voted

answered 2017-04-21 01:36:45 +0200

Lupp gravatar image

The default alignment is 'Default' meaning "none of the options set". For the display of content and results this is transformed to ImplicitRightAlign in case of numbers and to ImplicitLeftAlign in case of text.
There is no way to change any detail concerning this very specific behaviour of the 'Default' alignment.
However, you can change the 'Default' cellstyle to a different "simple" alignment, horizontally centered, e.g.
If you want to make a difference between numbers and texts you need to use conditional formatting.
Due to some problems and disadvantages I would dissuade from this option.

edit flag offensive delete link more


Danke, Herr Jäger

appreciatethehelp gravatar imageappreciatethehelp ( 2017-04-21 02:24:11 +0200 )edit

"Due to some problems and disadvantages I would dissuade from this option. " thanks for your answer Lupp, would you mind to elaborate your sentence please?

joondoe gravatar imagejoondoe ( 2020-01-07 14:15:30 +0200 )edit

Question Tools

1 follower


Asked: 2017-04-21 00:49:25 +0200

Seen: 760 times

Last updated: Apr 21 '17