[Bug 120875] Cell background color is printed even though cell is formatted to "hide when printing".

[bu...@apache.org]

https://issues.apache.org/ooo/show_bug.cgi?id=120875

TaLisa Henry <th...@my.fit.edu> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |thenry2010@my.fit.edu

--- Comment #1 from TaLisa Henry <th...@my.fit.edu> ---
I was able to replicate the bug running AOO 3.4.1 Build 9593 on a computer
running Windows 7 64bit. I printed using a HP Officejet 4500 Wireless, printing
wirelessly.

I attempted to replicate the bug multiple ways as shown below:

Test 1
1. open OO Calc
2. enter data into multiple cells
3. Select a single cell, and change the background color
  a. select cell -> right click -> format cells -> background -> select any
color -> OK 
4. Select same cell, check cell protection
  a. select cell -> right click -> format cells -> cell protection -> check
protected box  -> OK 
5. Select same cell, change cell protection "Hide when printing" 
  a. select cell-> right click -> format cells -> cell protection -> check
"Hide when printing"
6. Print

Test 1: replicated the bug as suggested.

Test 2: I ran the test again but selecting multiple cells to protect instead of
one
1. open OO Calc
2. enter data into multiple cells
3. Select multiple cell, and change the background color
  a. select cells -> right click -> format cells -> background -> select any
color -> OK 
4. Select same cells, check cell protection
  a. select cells -> right click -> format cells -> cell protection -> check
protected box  -> OK 
5. Select same cells, change cell protection "Hide when printing" 
  a. select cells-> right click -> format cells -> cell protection -> check
"Hide when printing"
6. Print

for test 2, the background colors of the selected cells can be all one color or
different and the bug is still replicated.

Test 3: I ran the same test as test 2 but also selecting a cell with a no-fill
(no background color)
1. open OO Calc
2. enter data into multiple cells
3. Select multiple cell, and change the background color
  a. select cells -> right click -> format cells -> background -> select any
color -> OK 
4. Select same cells, check cell protection
  a. select cells -> right click -> format cells -> cell protection -> check
protected box  -> OK 
5. Select same cells, change cell protection "Hide when printing" 
  a. select cells-> right click -> format cells -> cell protection -> check
"Hide when printing"
6. Select a sepatate cell with no-fill (no background color) and repeat step 5
7. Print

When I ran test 3, the no-fill cell selected was hidden properly, but the
colors of the cells that were selected were still shown, but the data was
hidden. Since the expected behavior is for the background color not to print,
and it did, the bug was replicated.

-- 
You are receiving this mail because:
You are the assignee for the bug.