This seems like new behavior in 7.5.5.2 or one of the more recent releases:
Create a blank calc spreadsheet, fill a few cells with some random text. The new text will be in the default font:
Select all cells using Crtl-A, by clicking in the box in the corner of the row/column headers, etc.
Increase the font size using format bar, Format->Cells, etc:
Only the cells with text in them are resized, blank cells retain the default font size:
I seem to remember that not long ago the behavior was that resizing fonts for “all” cells used to change the default font size for empty cells as well.
Am I mistaken? If this has been Calc’s behavior all along then I’m OK with this, I can just change the default font for new cells some other way.
No clue then. Why should 7.5.5.2 have a bug neither found in 7.5.3.2 nor in 7.6.0.0?
Concerning possible special problems with Fedora (or any Linux) I can’t help. But I also can’t imagine a reason in this case for a different behaviour.
See correction below.
I can reproduce the issue. However, I would never format a spreadsheet like that.
Hit F11, right-click cell style “Default” and change formatting attributes. Then remove any hard formatting (Ctrl+M).
Sorry. There must have been a mistake with my previous testing.
Repeating the test I also get the issue under Win 10.
Clue: This seems to be a bug introduced with V7.4 when the maximum number of columns was increased (from 2^10 to 2^14) . My portable V7.3.6 doesn’t show it.
With V7.5.3.2: If just the last column (XFD; number 16384) is excluded from the selection after Ctrl+A, or one of its cells is not blank, the changed cell attribute is applied as expected also to blank cells.
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.
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.
I can’t find out the bug report, I think this was a modification to avoid having the whole sheet with direct format, inadvertently, so only up to the last cell with data it’s modified.
It increases the file size, making slower save/open, Calc doesn’t like too much the whole sheet with direct format.
I claimed there was a bug and @erAck suggested (to a different user) such a report should be filed.
Nobody did, seemingly, and I won’t. I have >30 open bugs, and this one isn’t important for me. Anyway I would reject any guess the change was intentional. Also mass-occurring direct cell formatting is handled efficiently by Cal (and .odf storage).
In addition: After Ctrl+A and de-selection of a single cell (A1 e.g.) the complete sheet (except A1) accepts the font attribute.
Jumbo Sheets is still something different, with 16 million rows, and it’s not default but experimental. 1M rows are supported for years already. The switch from 1k columns to 16k columns was made.
Not true, if talking about file format. Calc was always able to save formatting per column/row. The article talks about in memory representation, where formatting runs per column (over rows) was always implemented, but with increasing columns to 16k a different approach to individual columns had to be taken (and that’s not only about formatting).
That was always exactly one formatting run within a column, not 1024 individual cell attributions.
The conclusion about Ctrl+A resulting in millions of individual formattings thus does not hold.
It’s been quite a while since I read those linked posts/talks, so probably need a refresher myself through all those ol’ bug reports + blog posts with fresh eyes!
