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 2013/11/05 16:23:02 UTC
[Bug 123641] New: Conditional Formatting selects only empty cells
when changing background color
https://issues.apache.org/ooo/show_bug.cgi?id=123641
Bug ID: 123641
Issue Type: DEFECT
Summary: Conditional Formatting selects only empty cells when
changing background color
Product: Calc
Version: 4.0.1
Hardware: PC
OS: Windows 7
Status: UNCONFIRMED
Severity: normal
Priority: P3
Component: formatting
Assignee: issues@openoffice.apache.org
Reporter: gzn.conundrum@gmail.com
CC: issues@openoffice.apache.org
--
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
You are watching all bug changes.
[Bug 123641] Conditional Formatting selects only empty cells when
changing background color
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=123641
Edwin Sharp <el...@mail-page.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|UNCONFIRMED |RESOLVED
CC| |elish@mail-page.com
Resolution|--- |NOTABUG
--- Comment #4 from Edwin Sharp <el...@mail-page.com> ---
Conditional formatting OK.
AOO410m1(Build:9750) - Rev. 1536093
Rev.1536093
Win 7
--
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
You are watching all bug changes.
[Bug 123641] Conditional Formatting selects only empty cells when
changing background color
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=123641
rbrunner@iupui.edu changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |rbrunner@iupui.edu
--- Comment #2 from rbrunner@iupui.edu ---
Rob Brunner, 11/5/2013:
OpenOffice Version 4.0.1
OS: Windows 8
I can confirm that this is an issue for his or her test file. The conditional
formatting rules also seem to fail if only non-empty cells are selected. Here
is a step-by-step way to recreate the issue:
1. Select a range of cells
2. Go to Format > Conditional Formatting...
3. Add a background change
When applied, the background will fail to update if non-empty cells are in the
selected cell range.
--
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
You are watching all bug changes.
[Bug 123641] Conditional Formatting selects only empty cells when
changing background color
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=123641
Andreas Säger <vi...@t-online.de> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |villeroy@t-online.de
--- Comment #3 from Andreas Säger <vi...@t-online.de> ---
from unit a
is the condition for cell A8. All conditionsl formatting expressions are
formula expressions, though. WHenever you want to compare literal text, you
need to put it in double-quotes.
Click A8, call the c.f. dialog and add the quotes so the condition reads "from
unit a". The cell turns green according to style Untitled5.
--
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
You are watching all bug changes.
[Bug 123641] Conditional Formatting selects only empty cells when
changing background color
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=123641
--- Comment #1 from Conundrum <gz...@gmail.com> ---
Created attachment 81883
--> https://issues.apache.org/ooo/attachment.cgi?id=81883&action=edit
Test document for conditional formatting problem
Test document as mentioned
--
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
You are watching all bug changes.