9

Whenever I create a new document with Calc the cell background is set to white. Therefore the first thing I must do before start working is modifying the background to an eye-friendly colour (usually just grey).

Is there a way to set this default cell colour to avoid having to change it every time I create a new document?

Luís de Sousa
  • 358

2 Answers2

10

Another way would be to modify the overall color settings:

  1. Menu "Tools" -> "Options"
  2. in options: "LibreOffice" -> "Application Colors"
  3. modify the very first color property "General" -> "Document background":

enter image description here

This will affect every document including writer and draw; it will affect every document independent from its source (assume working with a spreadsheet created by other people); and it won't affect other users working with your document (since it isn't a document / cell property but a user-specific application property). Of course, setting the cell background color manually or by using styles will override the general document background.

tohuwawohu
  • 10,678
7

One way is to change the default template:

  • Create a new blank document
  • Press F11 to open the Styles editor
  • Find the Default style and right-click then choose Modify...
  • Set Background Color as desired enter image description here
  • Click OK
  • Click File->Templates->Save as Template...

  • Choose a name, e.g. Default

    enter image description here

  • Set the Template Category to My Templates
  • Tick Set as default template
  • Click Save

Now when you create a new Calc document it will use the template you just created.

James P
  • 11,333
  • 1
    Valuable answer, but the one by tohuwawohu is leaner and solves the issue with all LibreOffice programmes. – Luís de Sousa Nov 29 '17 at 14:25
  • 1
    @LuísdeSousa, your comment isn't what you asked in the question. If you were interested in all of the LO apps, the question should have reflected that. I had actually written an answer with the same solution as tohuwawohu's. When James posted his answer, I realized that mine was written during a brain fart because his solution is the obvious, surgical way to accomplish what was asked without the "undesirable" effect on all other LO apps. So I deleted mine. If you desired the effect on all LO apps, that's a different question and answer. But at least now readers will have both solutions. – fixer1234 Nov 29 '17 at 18:21
  • @fixer1234 No, the other LibreOffice programmes are not a relevant to me, I do not use them. However, I think that other users that may in the future end up here will find tohuwawohu's answer more useful. – Luís de Sousa Nov 30 '17 at 08:53