https://bugs.documentfoundation.org/show_bug.cgi?id=101104
Bug ID: 101104
Summary: Conditional Formatting with Icon Set Doesn't Work When
All Values Above the Upper Cutpoint
Product: LibreOffice
Version: 5.1.4.2 release
Hardware: x86 (IA32)
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Created attachment 126390
--> https://bugs.documentfoundation.org/attachment.cgi?id=126390&action=edit
Minimal test of non-appearing icons
It seems like conditional formatting with an icon set fails to show any icons
if all of the values in the range are strictly greater than the upper cutpoint
threshold. (I discovered this originally in a spreadsheet of average GPAs where
every category was above 3.0.)
Consider the minimal attachment TestIconSet.ods. In column A are certain values
with conditional formatting applied, in which icons appear correctly (this
example was taken from the documentation at
https://wiki.documentfoundation.org/Faq/Calc/141). In column B are values 3.1
or 3.3 with the same formatting applied, and no icons visible. In particular,
the conditional formatting in each column was: All Cells, Icon Set, 3 Arrows,
yellow >= 0, green >= 1.
Some things we can try:
- If any cell in column B is changed to the value 1 or below, then icons appear
for all cells in column B. If that cell is then changed back to a value above 1
(by manual entry, not undo), then icons in column B all disappear again.
- If the conditional formatting is edited so the upper green category is >= 3.1
or any higher value, then icons appear for all cells in column B. Again, if
that criteria is edited to be anything below 3.1, then icons disappear from all
of column B.
- This malfunctions the same way for any icon set tested (it was originally
discovered attempting to use Traffic Lights 1).
--
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
