[Libreoffice-bugs] [Bug 122378] New: conditional formatting with formula is VLOOKUP(C14, Region, 1, 0) is VLOOKUP(C14, #NAME?, 1, 0)

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 122378
           Summary: conditional formatting with formula is
                    VLOOKUP(C14,Region,1,0)   is  VLOOKUP(C14,#NAME?,1,0)
           Product: LibreOffice
           Version: 6.1.3.2 release
          Hardware: x86-64 (AMD64)
                OS: Windows (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: hpadrutt at ggaweb.ch

Hi
In my short Excel I use conditional formatting with formula. Using Excel it
works, using LibreOffice Calc it doesn’t work.
The problem seems to be in the conditional formatting as the Name “Region” is
not valid after the value in the name “Region” changes.
Conditional formatting Formula is  VLOOKUP(C14,Region,1,0)    
as soon as the value in the “Region” changes it get this error
Conditional formatting Formula is  VLOOKUP(C14,#NAME?,1,0)

This formula is used in Range D14:D44 with ConditionlaStyle_1 which also does
not work

LibreOffice Version 6.1.3.2 (x64) same in Version 6.2

If it helps I can attached the full Excel

Regards, Heinrich

-- 
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/20181230/9964fee2/attachment-0001.html>