Apache OpenOffice (AOO) Bugzilla – Issue 104078
Cannot preserve background color set in advance when I apply conditional formatting
Last modified: 2013-01-29 21:49:02 UTC
Also found in DEV300m54 (but I could not find this version from bug reporting form) STEPS TO REPRODUCE AND ACTUAL RESULT: 1. Set two cells whose background color is different 1-1-1. open Calc 1-1-2. select A1 Cell 1-1-3. right click to show context menu 1-1-4. select "Format Cells" 1-1-5. Goto "Background" Tab 1-1-6. select "Light Green" 1-1-7. click "OK" to close the dialog 1-2-1. set A2 Cell Background to "Light Cyan" by following simillar steps as described in 1-1-x. 2. Create two styles 2-1-1. if "Formatting and Styles" dialog is shown, goto 2-1-4. 2-1-2. select "Format" Menu 2-1-3. select "Styles and Formatting" 2-1-4. Click "cell style" icon 2-1-5. on the list box below, right click to show context menu 2-1-6. select "New" 2-1-7. goto "Organizer" Tab and rename the style to "minus" 2-1-8. goto "Background" Tab and select "No Fill" 2-1-9. goto "Font Effect" Tab 2-1-10. change "Font color" to "red". 2-1-11. Click "OK" to close the dialog. 2-2-1. create "plus" style with backgound-color - no fill and Font color - "blue" by following simillar steps described in 2-1-x. 3. Apply Conditional Formatting to A1 and A2 Cell. 3-1-1. select A1 Cell 3-1-2. select "Format" Menu 3-1-3. select "Conditional Formatting" 3-1-4. set "Condition1" as follows. Cell value is greater than or equal to 0 Cell style : plus 3-1-5. check "Condition2" 3-1-6. set "Condition2" as follows. Cell value is less than 0 Cell style : minus 3-1-7. click "OK" to close the dialog. 3-2-1. set same conditional formatting to A2 Cell by following simillar steps described in 3-1-x. 4. 4-1-1. be sure that background colors of A1 and A2 are somehow gone and their cell backgrounds are in white. 4-1-2. select A1 cell 4-1-3. press "F2" to Edit Cell Contents 4-1-4. be sure that background colors of the A1 Cell is back to "Light Green" 4-1-5. input 5 and press OK 4-1-6. be sure that background colors of A1 is white again. 4-1-7. press "F2" to Edit Cell Contents 4-1-8. be sure that background colors of the A1 Cell is back to "Light Green" 4-1-9. input 5 and press OK 4-1-10. be sure that background colors of A1 is white again. EXPECTED RESULT: on steps 4-1-1,4-1-6,4-1-10, the background colors should be Light Green. Excel 2003 in my Windows XP behaves so with simillar steps. ---------------- QUESTION1: If this issue goes to WONTFIX Should I create styles a1-plus style linked with plus a1-minus style linked with minus a2-plus style linked with plus a2-minus style linked with minus OR a1-plus style linked with a1 a1-minus style linked with a1 a2-plus style linked with a2 a2-minus style linked with a2 and so on FOR ALL THE CELLS where I want to use combinations of background color and Conditional Formatting for workaround? QUESTION2: Even this issue is resolved, do I have to create separate styles for combinations of two or more styles? Is it good idea to make it possible to make combinations of styles without making another style? (but probably this will make the dialog more complicated, and it may bring "which style to be hornored" problem.)
Can reporduce it in DEV300m54 on WinXP But I think it may be related to hard formatting and soft formatting
Oops, I made mistakes again.(the first one is on another bug) >4-1-5. input 5 and press OK 4-1-5. input 5 and press Enter >4-1-9. input 5 and press OK 4-1-9 input -5 and press Enter
himajin100000, I guess so.^_^