[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 #9 from Xisco Faulí <xiscofauli at libreoffice.org> ---
(In reply to Oliver Brinzing from comment #8)
> (In reply to Heinrich Padrutt from comment #7)
> > Please enplane in more detail this and how to use lo api using my example.
> 
> you can for - example change - the macro code like this:
> 
> If ChRange = "DS" Then
>  ThisComponent.NamedRanges.getByName("Region").Content = "$Input.$B$4:$C$23"
>  Else
>   If ChRange = "SR" Then
>      ThisComponent.NamedRanges.getByName("Region").Content =
> "$Input.$H$4:$I$23"
>   Else
>      If ChRange = "TI" Then
>        ThisComponent.NamedRanges.getByName("Region").Content =
> "$Input.$M$4:$N$23"
>     End If
>   End If
> End If
> 
> but as mentioned in issue
> https://bugs.documentfoundation.org/show_bug.cgi?id=122420 it seems the vba
> "worksheet_change" listener is lost.
> so you need to do the code change with excel.
> 
> if you want to work with LO IMHO the best solution would be to exchange the
> vba code with LO basic code an save with ods file format.

Hi Oliver,
Do you think this is a valid bug ?

-- 
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/02a6f511/attachment.html>