<html> <head> <base href="https://bugs.documentfoundation.org/"> </head> <body> <div> <a class="bz_bug_link bz_status_UNCONFIRMED " title="UNCONFIRMED - conditional formatting with formula is VLOOKUP(C14,Region,1,0) is VLOOKUP(C14,#NAME?,1,0)" href="https://bugs.documentfoundation.org/show_bug.cgi?id=122378#c8">Comment # 8</a> on <a class="bz_bug_link bz_status_UNCONFIRMED " title="UNCONFIRMED - conditional formatting with formula is VLOOKUP(C14,Region,1,0) is VLOOKUP(C14,#NAME?,1,0)" href="https://bugs.documentfoundation.org/show_bug.cgi?id=122378">bug 122378</a> from <a class="email" href="mailto:oliver.brinzing@gmx.de" title="Oliver Brinzing <oliver.brinzing@gmx.de>"> Oliver Brinzing</a> <pre>(In reply to Heinrich Padrutt from <a href="show_bug.cgi?id=122378#c7">comment #7</a>) > 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 <a class="bz_bug_link bz_status_UNCONFIRMED " title="UNCONFIRMED - FILESAVE: VBA Worksheet_Change Listener lost on saving .xlsm in LO" href="show_bug.cgi?id=122420">https://bugs.documentfoundation.org/show_bug.cgi?id=122420</a> 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.</pre> </div> <hr> You are receiving this mail because: <ul> <li>You are the assignee for the bug.</li> </ul> </body> </html>