Ask Your Question

the entire sheet has background color, that cell's background color disappers after cutting a certain cell [closed]

asked 2015-06-06 09:55:15 +0200

lolax gravatar image

updated 2020-08-21 23:06:31 +0200

Alex Kemp gravatar image

Libreoffice and the module is Calc. WIndows 7 enterprise sp1 64bits.

I put the background color on a sheet and input data in a certain cell, then I tried to cut that cell and found the background color disappeared for that cell.

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2020-08-21 23:07:20.082593

1 Answer

Sort by » oldest newest most voted

answered 2015-06-06 12:41:10 +0200

pierre-yves samyn gravatar image


I guess you have selected cells by clicking the intersection of the row headers and column and then applied color. The solution would have been to change the default style.

  1. Display the style window (Sidebar or menu Format or F11)
  2. Display the Cell Styles (default display)
  3. Right click Default Modify

I would like to emphasize that changing background color to all the cells will affect printing...


edit flag offensive delete link more


Thanks and yes, I clicked the gray box beside column A to select all cells , then clicked the background color from the tool bar and found that cell's background color turned into white after cutting a certain cell. Thanks for your quick answer, but I still don't understand what the difference is..

lolax gravatar imagelolax ( 2015-06-06 17:37:58 +0200 )edit

@lolax - LibreOffice is designed for using styles. Apply a color to the selected cells as you do, do not change the default style. By analogy, if you name a sheet "Foo", the next created by default will take the name "Sheet2" and not "Foo". If you want to change the default color must change the default style as said. Regards.

pierre-yves samyn gravatar imagepierre-yves samyn ( 2015-06-06 18:35:36 +0200 )edit

Question Tools

1 follower


Asked: 2015-06-06 09:55:15 +0200

Seen: 353 times

Last updated: Jun 06 '15