I created a simple Calc template modifying all cells (Ctrl+A) to use FreeMono 12pt, and have Set as default template. (File > Templates > Save as Template... > apply name > check "Set as default template" > Save)
If I insert columns, or rows or cells; the template font family and size are applied to the new cells.
If I select a group of cells and move them to a different location on the sheet, the cells that replace those moved (in the original location) revert to the "factory" style of Liberation Sans 10pt.
Is there any way to adjust this "factory" style to match the template font family and size?
Additional information:
OS; Ubuntu 20.04.3 LTS x86_64 fresh install at release of 20.04, fully updated daily.
LibreOffice upgraded to 7.2.5.2: the issue remains.
11 Answer
You followed the wrong approach. Ctrl+a then formattng all cells applies direct formatting to each cell. Not only does that increase the size of your file, it also causes the effects you see: direct formatting is not default formatting.
You instead want to change the cell styles, then save the template and set it as default.
1
