[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 #8 from Oliver Brinzing <oliver.brinzing at gmx.de> ---
(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.

-- 
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/20190102/35a3326e/attachment.html>