https://bugs.freedesktop.org/show_bug.cgi?id=58781
Priority: medium
Bug ID: 58781
Assignee: [email protected]
Summary: FORMATTING: conditional formatting have weird result
Severity: normal
Classification: Unclassified
OS: Windows (All)
Reporter: [email protected]
Hardware: Other
Whiteboard: BSA
Status: UNCONFIRMED
Version: 3.6.4.3 release
Component: Spreadsheet
Product: LibreOffice
Created attachment 72140
--> https://bugs.freedesktop.org/attachment.cgi?id=72140&action=edit
my document which has this problem
Problem description:
--------------------
I have 2 style for conditional formatting, one have green background, other
have red background. When cell content is 'y', then the color is green,
otherwise the color is red
Steps to reproduce:
-------------------
1. block the cells
2. use format - conditional formatting
3a. condition1 : cell value is same with 'y', apply style -> create new style
with green background.
3b. condition2 : cell value is not same with 'y', apply style -> create new
style with red background.
Current behavior:
-----------------
some cell has green background, and other is red. whether the value is y or not
(it doesn't care).
When the cell contains y is clicked, the style with green background is
highlighted (format and style window).
When empty or other than y is clicked, the style with red background is
highlighted.
Expected behavior:
------------------
After executing command, all cells contains y will have green background. All
cells that does not contains y will have red background.
Operating System: Windows 7
Version: 3.6.4.3 release
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
