To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=115057
User regina changed the following:
What |Old value |New value
================================================================================
CC|'' |'regina'
--------------------------------------------------------------------------------
Ever confirmed| |1
--------------------------------------------------------------------------------
Status|UNCONFIRMED |NEW
--------------------------------------------------------------------------------
Keywords| |oooqa
--------------------------------------------------------------------------------
Priority|P3 |P4
--------------------------------------------------------------------------------
Summary|Coditional formatting ">0"|Conditional formatting ">0
| does include 0 |" does include 0
--------------------------------------------------------------------------------
------- Additional comments from [email protected] Thu Oct 14 16:59:27
+0000 2010 -------
The problem is, that you have mixed the two ways to describe conditions.
One way is to simple specify different formats, divided by semicolon. Then the
first one is for positive, the second one for negative and the third one for
zero. If the third format is missing, then zero is treated as positive.
[RED]#0;[BLACK]#0;[GREEN]#0 ==> positive red, negative black, zero green
[RED]#0;[BLACK]#0 ==> positive and zero red, negative black
The other option is to explicitly specify conditions. But then you would need to
specify a condition in _all_ cases. Missing cases get default format.
[RED][>0]#0;[GREEN][<0]#0
becomes
[RED][>0]#0;[GREEN][<0]#0;Standard ==> positive in red, negative in green, zero
in default black
But you are right, that OOo is not consistent in handling mixed notation.
[RED][>1]#0;[GREEN]#0 ==> 1 is green
[RED][>0]#0;[GREEN]#0 ==> 0 is red
[RED][>-1]#0;[GREEN]#0 ==> -1 is green
---------------------------------------------------------------------
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: [email protected]
For additional commands, e-mail: [email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
