Bug 126733 - Inverted emoticons sets for the conditional formatting
Summary: Inverted emoticons sets for the conditional formatting
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected) release
Hardware: x86-64 (AMD64) Windows (All)
: medium normal
Assignee: Not Assigned
Depends on:
Blocks: Conditional-Formatting-Editing
  Show dependency treegraph
Reported: 2019-08-06 17:32 UTC by britfox42
Modified: 2020-02-09 11:21 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:

Actual emoticons sets (33.42 KB, image/png)
2019-08-06 17:33 UTC, britfox42
work around for invert icons (36.51 KB, application/octet-stream)
2020-02-09 11:21 UTC, gmolleda

Note You need to log in before you can comment on or make changes to this bug.
Description britfox42 2019-08-06 17:32:17 UTC
The happy and sad faces are inverted for both the normal and colored sets of emoticons (look at the screenshot)

Actual Results:
The happy and sad faces are inverted.

Expected Results:
The opposite of the actual result...

Reproducible: Always

User Profile Reset: No

Additional Info:
Comment 1 britfox42 2019-08-06 17:33:46 UTC
Created attachment 153178 [details]
Actual emoticons sets
Comment 2 raal 2019-08-07 16:26:35 UTC
confirm with Version: (x64)
Build ID: 6eefac3b3744f806b0a35afbd0d9669d840118f4
CPU threads: 4; OS: Windows 6.1; UI render: default; VCL: win; 
and Version:
Build ID: fc8f44e82de4ebdd50ac5fbb9207cd1a59a927e3
Comment 3 gmolleda 2020-02-09 11:15:18 UTC
There are times when the high value is bad (number of errors) and the low value is good. It should be possible to change the icons individually, choose even the color, or also be able to change the signs> = to <=, or choose in all three cases if <, <=, =,>,> =, <>
Comment 4 gmolleda 2020-02-09 11:21:40 UTC
Created attachment 157755 [details]
work around for invert icons

One way to invert the icons is to use a second column that inverts the values, apply the conditional formatting and change the ink of the values to white to hide them. You can see the attached file.