Bug 91930 - Styles and Formatting: White background when background option is "No fill"
Summary: Styles and Formatting: White background when background option is "No fill"
Status: RESOLVED NOTABUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
4.4.3.2 release
Hardware: Other All
: medium major
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2015-06-08 09:23 UTC by Eldar
Modified: 2017-08-23 13:11 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments
tdf91930_backgroundCellStyle.ods: notabug - print preview shows page background image through no-fill cells. (14.72 KB, application/vnd.oasis.opendocument.spreadsheet)
2017-08-23 13:11 UTC, Justin L
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Eldar 2015-06-08 09:23:15 UTC
When I creating new custom style then by default style have no background with "No fill" option in "Background" tab. If I set background (green, for example) and pressing OK and then set background again to "No Fill" then background becomes white instead of no background.
Comment 1 Eldar 2015-06-08 09:47:53 UTC
Also if I don't change background, just press OK button, then background becomes white.

How to reproduce:
1. Create empty worksheet and change background color to any non-white color for cell "A1"
2. Create new custom style "Untitled1" and press OK
3. Set conditional formatting for "A1" cell and apply "Untitled1" style created in point 1
4. Select modify "Untitled1" style and go to "Background" tab. Press OK button

You can see than background has changed to white in "A1" cell. That's bug.
Comment 2 raal 2015-06-09 08:52:12 UTC
I can confirm with LO 4.4.3, win7
Comment 3 Timur 2015-06-09 10:54:59 UTC
Please see Bug 34585
Comment 4 OfficeUser 2015-06-24 19:47:32 UTC
Related with Bug 92319?
Comment 5 QA Administrators 2016-09-20 10:11:35 UTC Comment hidden (obsolete)
Comment 6 Justin L 2017-08-23 13:09:11 UTC
Not sure if I would call this a bug.
1.) start a new calc document.  Set default cell style background to blue.
2.) click in B2. In styles, right click on Default and create newCellStyle.
3.) on the Organizer tab, notice that "contains" is empty.  Click OK and apply newCellStyle to B2.  Notice that the whole sheet is still blue.
4.) modify newCellStyle and go to the background tab. Click OK, and notice that nothing happens.  Everything is still blue.
5.) modify newCellStyle and go to the organizer tab.  Notice that "contains" is still empty.  Go to the background tab.  Select No-Fill and press OK.  Notice that B2 is now white.
6.) modify newCellStyle and go to the organizer tab.  Notice that "contains" has "Automatic, Transparent".

Since the "automatic" color is white, that is what your cell background is.  Automatic is different from "inherit from parent".  

If you want to re-inherit the parents value...
7.) modify newCellStyle and go to the background tab.  Press the "standard" button and the background preview should turn to blue.  Go to the organizer tab, and notice that "contains" is empty again.
Comment 7 Justin L 2017-08-23 13:11:08 UTC
Created attachment 135748 [details]
tdf91930_backgroundCellStyle.ods: notabug - print preview shows page background image through no-fill cells.