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: [email protected]
Reporter: [email protected]
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._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
