[Libreoffice-bugs] [Bug 128881] Conditional Formats sometimes evaluated wrongly when using Named Ranges

bugzilla-daemon at bugs.documentfoundation.org bugzilla-daemon at bugs.documentfoundation.org
Fri Jun 25 14:59:41 UTC 2021


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

m.a.riosv <miguelangelrv at libreoffice.org> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |miguelangelrv at libreoffice.o
                   |                            |rg

--- Comment #6 from m.a.riosv <miguelangelrv at libreoffice.org> ---
Maybe I'm missing something, but third condition is:
STYLE(IF(Shading="";"WhiteOnMagenta";VLOOKUP(Shading;StyleTbl;2;0)))
Delete A2 -> Shading="", so WhiteOnMagenta style is applied.

-- 
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/20210625/9a5ee7ae/attachment.htm>


More information about the Libreoffice-bugs mailing list