How can I change the set of gradients in Calc?

I’m trying once again to change my company over to Calc from Excel 2003. I created a doppelganger of our Excel charts in OO.o a couple years ago, but using them day-to-day proved more time-consuming than Excel. Since the newer versions of Excel are going to make duplicating the original charts equally problematic, we’re ditching the original style and I’m trying out LO. Back when I made the OO.o version of our charts I edited some config files to replace the default list of gradients with custom ones, and my original question on the OO.o forum is no longer online. Anybody know where the config files to change things like default colors, fonts, sizing, etc. is located in LO? Is there now an easier way to do it via templates or styles? Thanks

To change the default color palette, replace the standard.soc file in this directory:


Individual colors can be changed in Tools > Options > Colors.

The gradients file, standard.sog, is located in the same folder.

The default font can be changed by going to Tools > Options, under LibreOffice Writer, go to Basic Fonts (Western) and select the font you wish to be the default.

Default font sizes can be changed by creating a template and editing the styles within the template.

1 Like