Macro to delete rows in Writer

rancio · March 2, 2020, 4:18pm

Hi, I’m new to LibreOffice and I was wondering if I could somehow adapt my old MS Word macros or find an equivalent for LibreOffice Writer.

I’ve got an app the gives me several tables with multiple columns as output and I want do delete all columns that contain a certain term (step two would actually be to repeat the same, but for rows).

Thanks in advance for you help!

In MS Word I was using the following macro:

Sub DeleteRowWithSpecifiedText()
Dim sText As String

sText = InputBox("Enter text for Row to be deleted")
Selection.Find.ClearFormatting
With Selection.Find
    .Text = sText
    .Wrap = wdFindContinue
End With
Do While Selection.Find.Execute
    If Selection.Information(wdWithInTable) Then
        Selection.Rows.Delete
    End If
Loop

End Sub