https://bugs.documentfoundation.org/show_bug.cgi?id=122378
--- Comment #9 from Xisco Faulí <[email protected]> ---
(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._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
