Convert Excel Macro to OpenOffice Macro

Hi guys, I have made an Excel macro using VBA, but I need it converted to an Open Office macro for various reasons. I'm just starting with VBA and because the Basic language used by OpenOffice is a bit different I cannot do it by myself. What my macro does is the following: It loops through all the worksheets and replaces words in several specific columns with specific headers. It also change the values of one column entirely. See attachement.