Formatting all page cells

[KnotInABox]

I’m trying to format all cells on a page, but only the cells with text in them are changing even when I select all cells. What gives?

https://i.imgur.com/CmACsmb.png

…I’m using the upper left square to select all cells. I also tried “select all” from menu. Either selection only changes the cells with text in them.

If I “cut” the text and apply the change, all cells are affected and then I can paste in my text back in. If I have a page full of text this solution could get cumbersome very quickly though. Surely I’m missing a simple element here.

[LeroyG]

Blank Cells Don't Change Font Size After Resizing Font?

I think that it’s a new feature (maybe to avoid CPU or RAM usage). In my screenshot below, initially only B2 and C4 has text. After Select All, and changing font size, only the cell range (B2:C4) between those corner cells get the formatting. [imagen] So if you need to format a range of cells, make sure that at least one cell in the boundary rows and columns has a value. Tested with 7.5.3.2 and 7.6.0.1.

Maybe a bug (maybe not): tdf#156826

[Zizi64]

@KnotInABox

I’m trying to format all cells on a page,

In the Calc use the Cell Styles. Just modify the format properties of the applied Cell Style, even if it is the Default Cell Style. Or you can apply an another cell style (a built is one or a custom one).

[KnotInABox]

it still only modifies the cell with text unless i delete text then apply…which is dumb.