Applying default format to all cells in Calc

[OldGuyInTheClub]

Hello,
I would like all cells in a spreadsheet to be Top Aligned and with Word Wrap enabled. I have tried two methods:

1. On an empty sheet: Click the upper left hand cell to select all cells, then select the Top Align and Word Wrap buttons
2. Format → Cells → Alignment: Select Top Align and Word Wrap

In both cases, when I add inputs to a cell, it reverts to Bottom Aligned but Word Wrap remains. I have to select the Top Align icon which turned off as soon as I clicked into a new cell

What am I doing wrong?

I’m using v 7.5.0.3 on an Intel Mac running Catalina.

Thanks,

The Old Guy In The Club

Edit: Found the answer through more searching. See below.

[OldGuyInTheClub]

I did more searching and came across this link which I had not seen before. It explained that I need to modify the Default Style. This solved my problem.

Calc: How to set up global cell formatting?

Not sure, I understand why this might be needed, but your problem has a simple solution. Choose Styles - Manage Styles or press F11. From the context menu for the Default style, select Modify and set the formatting options you see fit. All cells in this workbook (even empty ones) will now obey these rules. [EditStyleDefault.png]

[mikekaganski]

@OldGuyInTheClub

when I add inputs to a cell, it reverts to Bottom Aligned

Actually, this looks like a bug. Indeed, when you type anything into a cell with Default number format, the typed data would cause the cell to detect what number that is, and possibly apply a new number format (e.g., to make dates look like dates); it also would apply horizontal alignment (by default, text is left-aligned, while numeric data is right-aligned). But I see no reason it would also change vertical alignment…

But I can’t reproduce the said behavior using v.24.2.5.1.

[OldGuyInTheClub]

Interesting, thanks. I updated to v7.6.7.2 but still had the issue. Thought about trying v24 but the webpage recommended v 7.x for most users so I went with that.

Changing the Default Style solved this problem for me but I’ll be on the lookout for others.