https://bugs.documentfoundation.org/show_bug.cgi?id=103344
Bug ID: 103344
Summary: Calc conditional formatting works inverse
Product: LibreOffice
Version: 5.1.4.2 release
Hardware: x86-64 (AMD64)
OS: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
If I add a conditional formatting condition like this:
*If cell values is equal to "x" apply style "Green background".*
All the empty cells are colored green and if I put an "x" into any, the color
disappears.
To get what I wanted, I needed to use a "not equal to" condition.
Then the selected style is applied when the cell's value IS EQUAL to "x".
This is completely opposite to what I'd expect.
Actual Results:
"Cell value equal to X" condition applies formatting to all the cells that have
value different than X.
Expected Results:
If the condition says "equal to" I'd expect it to not behave as if it was
really a "not equal to" condition.
Reproducible: Always
User Profile Reset: No
Additional Info:
Here's a screenshot depicting the problem:
https://mega.nz/#!69YhEIZb!c9-H7S8uP2ogdRRtDyLatHlsxiQzzR7FQssTwiAFrYM
User-Agent: Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:49.0) Gecko/20100101
Firefox/49.0
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
