To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=104078
Issue #|104078
Summary|Cannot preserve background color set in advance when I
| apply conditional formatting
Component|Spreadsheet
Version|DEV300m47
Platform|Unknown
URL|
OS/Version|Windows XP
Status|UNCONFIRMED
Status whiteboard|
Keywords|
Resolution|
Issue type|DEFECT
Priority|P3
Subcomponent|formatting
Assigned to|spreadsheet
Reported by|himajin100000
------- Additional comments from himajin100...@openoffice.org Fri Aug 7
08:52:39 +0000 2009 -------
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.)
---------------------------------------------------------------------
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscr...@sc.openoffice.org
For additional commands, e-mail: issues-h...@sc.openoffice.org
---------------------------------------------------------------------
To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org
For additional commands, e-mail: allbugs-h...@openoffice.org
