Calc 7.5.5.2, 64 bit.
Windows 10 Pro
When selecting an entire sheet with the global select control on the top left at the corner of the sheet row1/column1, I select the cell formatting I want for font, font size and cell contents alignment. The newly selected format is applied only to filled cells and empty cells that are bounded by other filled cells. Cells outside the area bounded by filled cells do not have their formatting changed when I enter new data in them; i.e. the cell format remains at the default Liberation Sans, 10 pt., no alignment. E.g.: if R6C6 is the last filled cell in the sheet, an empty cell at R5C5 will take on the new formatting but a cell at R7C5 will not have the new format, nor will any cell beyond R6 or C6.
I would have thought that with the entire sheet selected and applying a new cell format, that all the cells in the sheet would take on the new attributes but they don’t. Am I expecting too much or is this a bug?
Cheers,
Hugo.