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.