<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#c9">Comment # 9</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:xiscofauli@libreoffice.org" title="Xisco Faulí <xiscofauli@libreoffice.org>"> Xisco Faulí</a> <pre>(In reply to Oliver Brinzing from <a href="show_bug.cgi?id=122378#c8">comment #8</a>) > (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_NEW " title="NEW - 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. Hi Oliver, Do you think this is a valid bug ?</pre> </div> <hr> You are receiving this mail because: <ul> <li>You are the assignee for the bug.</li> </ul> </body> </html>