https://bugs.documentfoundation.org/show_bug.cgi?id=122378
--- Comment #8 from Oliver Brinzing <oliver.brinz...@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.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs