Ask Your Question

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

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

lolax gravatar image

updated 2015-09-27 18:33:46 +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 close merge delete

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
Login/Signup to Answer

Question Tools

1 follower


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

Seen: 259 times

Last updated: Jun 06 '15