<html> <head> <base href="https://bugs.documentfoundation.org/"> </head> <body> <div> <a class="bz_bug_link bz_status_NEW " title="NEW - Calc: Cells background color is printed even when cell protection is "hide from printing"" href="https://bugs.documentfoundation.org/show_bug.cgi?id=43720#c9">Comment # 9</a> on <a class="bz_bug_link bz_status_NEW " title="NEW - Calc: Cells background color is printed even when cell protection is "hide from printing"" href="https://bugs.documentfoundation.org/show_bug.cgi?id=43720">bug 43720</a> from <a class="email" href="mailto:muddbug66@yahoo.com" title="Phil Nichols <muddbug66@yahoo.com>"> Phil Nichols</a> <pre>(In reply to Yousuf Philips (jay) from <a href="show_bug.cgi?id=43720#c8">comment #8</a>) > Not sure if this a bug or not, as i wouldnt classify the cell background to > be part of the cell data unless maybe it was formatted based on conditional > formatting, but lets see what the exports say. @Regina: What does ODF say > about this setting? > > <a href="https://help.libreoffice.org/Calc/Cell_Protection">https://help.libreoffice.org/Calc/Cell_Protection</a> Yes, it's a bug. The setting is to hide or display the entire CELL, not just the text. The cell's color, border and text contents are all part of and properties of the cell. Otherwise you can have a sheet that's full of "hidden when printing" cells, blank, but instead of a printed blank sheet you get a sheet with a bunch of scattered yellow rectangles with no text.</pre> </div> <hr> You are receiving this mail because: <ul> <li>You are the assignee for the bug.</li> </ul> </body> </html>