As per the above question. I want my text to come out “centered” in the cell from default.
Thanks.
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.
Danke, Herr Jäger
"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?