[Libreoffice-bugs] [Bug 122378] 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

--- Comment #10 from Oliver Brinzing <oliver.brinzing at gmx.de> ---
(In reply to Xisco Faulí from comment #9)
> Do you think this is a valid bug ?

i think if:

>  ThisWorkbook.Names("Region").RefersTo = "=Input!$B$4:$C$23"

will keep the formula valid (still pointing to "Region") we can not call it a
bug, cause removing a named range will make references invalid.

the main problem seem to be the missing formula update as described in issue:
Bug 122420 - FILESAVE: VBA Worksheet_Change Listener lost on saving .xlsm in LO

-- 
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/20190708/a0ae7378/attachment.html>