Issue 128269 - Cell conditional formatting has a logic error
Summary: Cell conditional formatting has a logic error
Status: CLOSED NOT_AN_OOO_ISSUE
Alias: None
Product: Calc
Classification: Application
Component: formatting (show other issues)
Version: 4.1.7
Hardware: PC Windows 10
: P5 (lowest) Normal (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2020-01-16 15:45 UTC by Maggie Rodway
Modified: 2020-03-03 10:43 UTC (History)
4 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

Attachments
Screen shot of formatting error (125.66 KB, image/png)
2020-01-25 13:23 UTC, Maggie Rodway 		no flags Details
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description Maggie Rodway 2020-01-16 15:45:49 UTC 
Conditional formatting has a logic fault. 

I try to display certain text with a background colour for emphasis and put the condition as "is equal to" to display text "X" with a background colour. When I apply this filter the result is the inverse of what it should be - all cells that DO NOT contain the text "X" have a background colour added, and the cell with "X" has no colour.
Comment 1 oooforum (fr) 2020-01-17 14:02:32 UTC 
You are in wrong place here. This tool is a bug tracking system and not a help
desk.

You must use a style and a template if you want this setting.

Please refer first on users mailing list or forum:
http://www.openoffice.org/support/index.html
Comment 2 Maggie Rodway 2020-01-24 20:14:12 UTC 
Marcus

Kindly do not treat bug reports so dismissively. Clearly this isn't a help desk as your response is no help at all.

I have been using his kind of software for more than thirty years, so I know how it is supposed to work.

When you apply a conditional formatting filter to display text in a particular colour if the value in the cell is above zero, and the operation works in the reverse manner to the criteria applied in the function, namely turning all cells that are BELOW zero that colour instead, then it is a BUG.

Kindly address the reported problem.
Comment 3 Maggie Rodway 2020-01-24 20:19:32 UTC 
(In reply to oooforum (fr) from comment #1)
> You are in wrong place here. This tool is a bug tracking system and not a
> help
> desk.
> 
> You must use a style and a template if you want this setting.
> 
> Please refer first on users mailing list or forum:
> http://www.openoffice.org/support/index.html
Comment 4 Matthias Seidel 2020-01-24 20:22:39 UTC 
Maggie,

What Marcus are you talking to?!

And please do not spam this issue with useless replies...
Comment 5 Regina Henschel 2020-01-24 20:46:37 UTC 
Please attach a small file that shows the error. That make it easier to investigate.
Comment 6 Maggie Rodway 2020-01-25 13:23:19 UTC 
Created attachment 86817 [details]
Screen shot of formatting error

Please find attached a screen shot showing the conditional format I have applied. If there is an "X" in the cell, the cell should show a green background. As you can see, the green background is being applied to the cells that DO NOT contain an "X".

I don't know how much clearer I can make the explanation.

And kindly don't ask me not to "spam" this thread when it is the responses I have been receiving that qualify as spam.
Comment 7 Maggie Rodway 2020-01-25 13:32:59 UTC 
Now resolved by trial and error. Thanks for all the help.
Comment 8 jeffooo 2020-03-03 10:43:22 UTC 
Hi,

Because your conditional formatting must be refer to :
"x"

And not :
x

So, this issue is not a bug ;)