Global cell formatting bug?

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.

Select all cells and remove direct formatting (Ctrl+M).
Open the stylist window (F11), right-click cell style “Default” and modify that.

Working with cell styles (in this case ‘Default’) is recommendable, of course.
However, the described behaviour is a bug - and it’s reproducible with v 7.6.1.2,

2 Likes

In version 25, problem fixed.

tdf#153527

4 Likes

Villeroys sollution worked for me.
But for any reason the empty file I created first did not work to change formating the normal way not even for a single cell from English (US) to anything else.
After changing the “Default” formating as described by Villeroy to “German (Germany)” I was able to change the formating of single sheets reproductively to English (UK) and English (US).

Since I do not know where these bug comes from and I created some empty test files, I will attach them so it may be easier for you to find the cause for these bug.
Spreadsheet-Default-Formating-changed-to-german_no-Formating-Issues-anymore_2025-03-21.ods (7.9 KB)
Spreadsheet-Bug-Formating-Issues_2025-03-21.ods (7.9 KB)

Please clarify the problem with the second file.
I changed the language of cell A1 to English(UK).
The rest of the cells have the language English(USA) according to the default cell style.
Spreadsheet-Bug-Formating-Issues_2025-03-21.ods (9.4 KB)

I simply was not able to override the default formatting by changing the formatting of a single cell or multiple cells in the second file with name “Spreadsheet-Bug-Formating-Issues_2025-03-21.ods”.

After I changed the default formatting to "Germany (German) for my second file “Bug-Formating.ods” I was able to override the formatting of a single cell or multiple cells using the formatting option.

I made a short video too, but I do not want to take 50MiB on your Server just to upload something to document an issue caused by a bug of the program itself or my fault.