Spreadsheet default font

[Aardo]

Can I set a default font for the entire spreadsheet?

I have this situation: I often cut and paste cells. Each time I cut a cell, this cell defaults to a Helvetica Neue font, which I don’t even have on my system, and it looks bad. And I have to successively select the entire spreadsheet, and manually set the font to say, Arial.

Can I set a default font, such as Arial, so I don’t have to reformat the spreadsheet manually each time?

[anon73440385]

Hello

you need to define a new Calc default template (since your existing one contains non - existing fonts)

To create a new default template for LibreOffice Calc perform:

• Open a new Calc spreadsheet
• Go to Styles -> Manage Styles (or F11)
• Click icon Cell Styles (leftmost icon below Styles*)
• Right click on Default → Modify -> Tab: Font
• Set your preferred font + options
• Click OK
• Menu File -> Templates -> Save as Template
• Provide a Template Name (e.g. MyCalcTemplate)
• Select a Template Category (e.g. My Templates)
• Important Check option [x] Set as default template
• Click Save
• Close your document (no further save required) and open a new Calc spreadsheet
• Check your new settings

Note This won’t apply to existing documents. Hence, whenever you re-use old documents with new content, you won’t get the new default template applied.

Hope that helps.

[Lupp]

Evrything in that range is controlled by styles and templates.

The attributes a cell has after you applied a Cut are those defined by the Default CellStyle as it is defined for the spreadsheet document, and thts is the CellStyle inherited from the template you used when creating the document.

If you didn’t choose a specific template at that time, your default template for spreadsheet documents was used.

Yes, you can change all that, and you can even …

I suggest you read Chapter 4 of https://extensions.libreoffice.org/assets/downloads/7/CG64-CalcGuide.pdf to learn more.