You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@openoffice.apache.org by bu...@apache.org on 2020/01/16 15:45:49 UTC
[Issue 128269] New: Cell conditional formatting has a logic error
https://bz.apache.org/ooo/show_bug.cgi?id=128269
Issue ID: 128269
Issue Type: DEFECT
Summary: Cell conditional formatting has a logic error
Product: Calc
Version: 4.1.7
Hardware: PC
OS: Windows 10
Status: UNCONFIRMED
Severity: Normal
Priority: P5 (lowest)
Component: formatting
Assignee: issues@openoffice.apache.org
Reporter: craigydon14@yahoo.co.uk
Target Milestone: ---
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.
--
You are receiving this mail because:
You are the assignee for the issue.
[Issue 128269] Cell conditional formatting has a logic error
Posted by bu...@apache.org.
https://bz.apache.org/ooo/show_bug.cgi?id=128269
jeffooo <je...@orange.fr> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |jeffooo@orange.fr
--- Comment #8 from jeffooo <je...@orange.fr> ---
Hi,
Because your conditional formatting must be refer to :
"x"
And not :
x
So, this issue is not a bug ;)
--
You are receiving this mail because:
You are the assignee for the issue.
[Issue 128269] Cell conditional formatting has a logic error
Posted by bu...@apache.org.
https://bz.apache.org/ooo/show_bug.cgi?id=128269
oooforum (fr) <oo...@free.fr> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|UNCONFIRMED |RESOLVED
CC| |oooforum@free.fr
Resolution|--- |NOT_AN_OOO_ISSUE
--- Comment #1 from oooforum (fr) <oo...@free.fr> ---
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
--
You are receiving this mail because:
You are the assignee for the issue.
[Issue 128269] Cell conditional formatting has a logic error
Posted by bu...@apache.org.
https://bz.apache.org/ooo/show_bug.cgi?id=128269
--- Comment #6 from Maggie Rodway <cr...@yahoo.co.uk> ---
Created attachment 86817
--> https://bz.apache.org/ooo/attachment.cgi?id=86817&action=edit
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.
--
You are receiving this mail because:
You are the assignee for the issue.
[Issue 128269] Cell conditional formatting has a logic error
Posted by bu...@apache.org.
https://bz.apache.org/ooo/show_bug.cgi?id=128269
Regina Henschel <rb...@t-online.de> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |rb.henschel@t-online.de
--- Comment #5 from Regina Henschel <rb...@t-online.de> ---
Please attach a small file that shows the error. That make it easier to
investigate.
--
You are receiving this mail because:
You are the assignee for the issue.
[Issue 128269] Cell conditional formatting has a logic error
Posted by bu...@apache.org.
https://bz.apache.org/ooo/show_bug.cgi?id=128269
Matthias Seidel <ms...@apache.org> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |mseidel@apache.org
--- Comment #4 from Matthias Seidel <ms...@apache.org> ---
Maggie,
What Marcus are you talking to?!
And please do not spam this issue with useless replies...
--
You are receiving this mail because:
You are the assignee for the issue.
[Issue 128269] Cell conditional formatting has a logic error
Posted by bu...@apache.org.
https://bz.apache.org/ooo/show_bug.cgi?id=128269
Marcus <ma...@apache.org> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|RESOLVED |CLOSED
--
You are receiving this mail because:
You are the assignee for the issue.
[Issue 128269] Cell conditional formatting has a logic error
Posted by bu...@apache.org.
https://bz.apache.org/ooo/show_bug.cgi?id=128269
--- Comment #3 from Maggie Rodway <cr...@yahoo.co.uk> ---
(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
--
You are receiving this mail because:
You are the assignee for the issue.
[Issue 128269] Cell conditional formatting has a logic error
Posted by bu...@apache.org.
https://bz.apache.org/ooo/show_bug.cgi?id=128269
Maggie Rodway <cr...@yahoo.co.uk> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|UNCONFIRMED |RESOLVED
Resolution|--- |FIXED
--- Comment #7 from Maggie Rodway <cr...@yahoo.co.uk> ---
Now resolved by trial and error. Thanks for all the help.
--
You are receiving this mail because:
You are the assignee for the issue.
[Issue 128269] Cell conditional formatting has a logic error
Posted by bu...@apache.org.
https://bz.apache.org/ooo/show_bug.cgi?id=128269
Matthias Seidel <ms...@apache.org> changed:
What |Removed |Added
----------------------------------------------------------------------------
Resolution|FIXED |NOT_AN_OOO_ISSUE
Status|RESOLVED |CLOSED
--
You are receiving this mail because:
You are the assignee for the issue.
[Issue 128269] Cell conditional formatting has a logic error
Posted by bu...@apache.org.
https://bz.apache.org/ooo/show_bug.cgi?id=128269
Maggie Rodway <cr...@yahoo.co.uk> changed:
What |Removed |Added
----------------------------------------------------------------------------
Resolution|NOT_AN_OOO_ISSUE |---
Status|CLOSED |UNCONFIRMED
--- Comment #2 from Maggie Rodway <cr...@yahoo.co.uk> ---
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.
--
You are receiving this mail because:
You are the assignee for the issue.