LibreOffice Calc ( replaces moved cells with non-template font family and size

jp flag

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 the issue remains.

Broadsworde avatar
jp flag
@fedkad Added to the question.
cn flag

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.

Broadsworde avatar
jp flag
That approach seems to have worked, thank you. But the documentation bares little to no relation to the options and steps available in the application. e.g. had to right click the Default style and select Modify... But I got there in the end!

Post an answer

Most people don’t grasp that asking a lot of questions unlocks learning and improves interpersonal bonding. In Alison’s studies, for example, though people could accurately recall how many questions had been asked in their conversations, they didn’t intuit the link between questions and liking. Across four studies, in which participants were engaged in conversations themselves or read transcripts of others’ conversations, people tended not to realize that question asking would influence—or had influenced—the level of amity between the conversationalists.