Ask Your Question
0

Change default text alignment settings (calc) [closed]

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

appreciatethehelp gravatar image

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

Thanks.

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
0

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

Comments

Danke, Herr Jäger

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

Question Tools

1 follower

Stats

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

Seen: 19 times

Last updated: Apr 21