Issue 104078

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.)