[Libreoffice-bugs] [Bug 115334] variant Icon set in Conditional formatting cant be setup

bugzilla-daemon at bugs.documentfoundation.org bugzilla-daemon at bugs.documentfoundation.org
Sat Apr 7 15:14:05 UTC 2018


https://bugs.documentfoundation.org/show_bug.cgi?id=115334

--- Comment #6 from Markus Mohrhard <markus.mohrhard at googlemail.com> ---
(In reply to Eric from comment #5)
> I set the following:
> =sign(k2-j98) in cell k98
> This gives me 1 or -1 or 0 (not sure if i will ever get a zero but)
> In conditional formatting Icon set, i set the yellow arrow to 0 and the
> green to 1
> 
> The value in the cell is now -1 and a green arrow, it should be a red arrow
> 
> What i am trying to do is to track a changing value compared to a static
> value
> I want to  see an appropriate icon if the dynamic value rises above or falls
> below the static value, if its equal i should see a yellow

Please attach a test document with detailed instructions how to reproduce the
problem.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20180407/c9ea244f/attachment.html>


More information about the Libreoffice-bugs mailing list